Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

last indexOf in a query activty

Avatar

Avatar
Give Back
Level 2
maurizio_coro
Level 2

Likes

15 likes

Total Posts

37 posts

Correct Reply

0 solutions
Top badges earned
Give Back
Ignite 3
Ignite 1
Validate 10
Validate 1
View profile

Avatar
Give Back
Level 2
maurizio_coro
Level 2

Likes

15 likes

Total Posts

37 posts

Correct Reply

0 solutions
Top badges earned
Give Back
Ignite 3
Ignite 1
Validate 10
Validate 1
View profile
maurizio_coro
Level 2

12-03-2019

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

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Establish
MVP
wodnicki
MVP

Likes

976 likes

Total Posts

1,096 posts

Correct Reply

514 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile

Avatar
Establish
MVP
wodnicki
MVP

Likes

976 likes

Total Posts

1,096 posts

Correct Reply

514 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile
wodnicki
MVP

18-03-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

Answers (0)