last indexOf in a query activty | Community
Skip to main content
maurizio_coro
maurizio_coro
New Participant
March 12, 2019
Solved

last indexOf in a query activty

  • March 12, 2019
  • 1 reply
  • 1742 views

Hi experts!

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?

thanks

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by Jonathon_wodnicki

    Hi,

    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.

    Thanks,

    -Jon

    1 reply

    Jonathon_wodnicki
    Jonathon_wodnickiAccepted solution
    New Participant
    March 18, 2019

    Hi,

    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.

    Thanks,

    -Jon

      Terms & ConditionsAccessibility statement

      Loading footer...