Additional string functions:
left(string,int) to return the left x characters of a string.
right(string,int) to return the right x characters of a string.
btw, Substring() is not the same.
No, I am saying this is basic string functionality that has never been in the built-in functions.
substring(string, int, int) can be similar to right(string, int) but you have to know the length of the overall string and then know the proper starting position.
substring(string, length(string) - x, x) is the same as right(string, int).
substring(string, 0, int) is the same as left(string, int), so I could live that that but you have to remember that strings are 0 indexed.
Got it! Yes - always nice to have a cleaner formula (especially if logic gets complex). I'll let @awarrier comment on this idea from a product perspective.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.