Search from right to left

[Anonymous]

Hi all,

here is the problem I'm trying to solve:

I have a column with text looks like this 

Campaign1_IG_feed_bumper
Campaign2_IG_feed_10sec

Campaign3_PIN_VideoPin_V2_6sec

I need to extract the text after lest "_". So, i need to have a columns with

bumper

10sec

6sec

I could use Find / Serach function but they both look from left to right and I get as result the position of first "_". Number of "_" could be different as well. So, I need to search from right to left and find a position of the first "_" from the right.

Any ideas how I can do that?

[amitchandak]

In the edit query mode you can use M code

Text.PositionOf(Table[Column], "_", Occurrence.Last)

https://docs.microsoft.com/en-us/powerquery-m/text-positionof

[Mariusz · Accepted solution]

Hi @Anonymous 

You can do it with Split Column by Delimiter in Power Query as per below.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[Anonymous]

Thanks a lot! I didn't think about the query. It works!