Extracting text

Hi gancw1,

One possible approach to extract the supplier name from this column is to use Power Query in Excel or Power BI. Here are the steps:

1. Select the column that contains the supplier names.

2. Click on the "Transform data" button to open the Power Query Editor.

3. Click on the drop-down arrow next to the column header and select "Split Column" -> "By Delimiter".

4. In the "Split Column" dialog box, select "Custom" as the delimiter option and enter "for " (including the space after "for") as the delimiter text.

5. Click on "OK" to split the column into two separate columns.

6. Rename the new columns to something meaningful, such as "Action" and "Supplier".

7. Delete the "Action" column, as it is no longer needed.

8. Click on the drop-down arrow next to the "Supplier" column header and select "Trim" to remove any leading or trailing spaces.

9. Click on "Close & Load" to save the changes and return to the Excel or Power BI interface.
   
   

The resulting "Supplier" column should now contain the extracted supplier names. You may need to do some additional cleaning or formatting depending on the specific requirements of your analysis.

Best regards, 

Isaac Chavarria

If this post helps, then please consider Accepting it as the solution and give Kudos to help the other members find it more quickly

I have figured out I can use the TextBetweenDelimiter() function to extract the supplier name by using "for " and " on" as start and end delimiters

= Table.AddColumn(#"Changed Type", "Supplier", each Text.BetweenDelimiters([Text], "for ", " from", 0, 0))