Forum Discussion
Mal_Sondh
Helper II
Helper IIExtracting data from a column after a certain character
Hi, What is the best way to extract data such as this into another column: If i have an original field called Col name and i wanted to normailse this as shown in the Normalised column, what form...
You can just add a new column with this formula
= Text.BetweenDelimiters([Col Name], "-", "-")
Regards,
Pat
Hi Mal_Sondh
Further to that, wrap it in Text.Trim to remove leading and trailing space characters
#"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each Text.Trim(Text.BetweenDelimiters([Col Name], "-", "-")))Phil
If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.
PhilipTreacy
Super User
Super UserHi Mal_Sondh
Further to that, wrap it in Text.Trim to remove leading and trailing space characters
#"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each Text.Trim(Text.BetweenDelimiters([Col Name], "-", "-")))
Phil
If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.