Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Search from right to left

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 ex...
Need Help
Tips and Tricks
  • Mariusz's avatar
    Mariusz
    6 years ago

    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

     

Mariusz's avatar
Mariusz
Icon for Community Champion rankCommunity Champion
6 years ago

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's avatar
    Anonymous
    Not applicable
    6 years ago

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