Forum Discussion
Extracted Text Before Delimiter using another column as the delimiter
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],"")
Can you please post some example data and the expected result to help illustrate your issue?
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
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],"")
Thank you for you quick response and answer which worked perfectly.