Forum Discussion
Solved
Extracted Text Before Delimiter using another column as the delimiter
Hi, Hopefully someone can help as I am a bit stumped... I have two columns, one column contains the same data as the other but is concatenated with other data, I am trying to use 'Extracted Text ...
Brynut wrote:Hi, of course please see example below...
- Column1 - CustomerNameResourceName - Data example... MicrosoftJohn Smith
- Column2 - ResourceName - Data example... John Smith
With the above I need to extract the CustomerName by using column 2 as the delimiter, the customer name and resource name vary in length from row to row.
To do that I would just add a custom column with the following expression:
Text.Replace([CustomerNameResourceName],[ResourceName],"")
Hi, of course please see example below...
- Column1 - CustomerNameResourceName - Data example... MicrosoftJohn Smith
- Column2 - ResourceName - Data example... John Smith
With the above I need to extract the CustomerName by using column 2 as the delimiter, the customer name and resource name vary in length from row to row.
Thanks
Simon
Thank you for you quick response and answer which worked perfectly.