Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Substring Text based on delimiter position defined in another column

Hi Guys,   I want to extract some text from a column based on the position of a delimter defined in another column. Example of data               So i want all three Names column to ...
Need Help
  • camargos88's avatar
    camargos88
    5 years ago

    Anonymous ,

     

    Check the attached file, the result it's different but I believe it can help you.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
5 years ago

Hi,

You may download my PBI file from here.

Hope this helps.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Ashish_Mathur  Thanks for the help.

     

    I am going with the camargos88  solution. But that's neat trick you did with keyword.