Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
Hi @Anonymous
You can do it with Split Column by Delimiter in Power Query as per below.
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
Hi @Anonymous
You can do it with Split Column by Delimiter in Power Query as per below.
Thanks a lot! I didn't think about the query. It works!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
83 | |
67 | |
61 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |