Sign in to Community
Sign in to view all badges
Is there any quick way to get the last index of a string in ax "expression" field of a query activity?
the purpose is to display the last word in a field, so I'm wondering if I can get the last "space" ad use the "Right" function.
Or maybe do you know other way to get it?
Charindex() will return the first position. If you have a (low) upper bound of occurrences you can case-when them all out, or more simply expose your rdbms' regular expression function.