Forum Discussion
Trim Function
I wanted to delete specific strings from the data. But the data is not consistent. sample data 123456_1 123456_10 1234568_01 1234567_1 I need to remove the last strings ( which are highli...
In Power Query, when you don't know which function to use, you can use the following technique:
Select the Column,
Add a Column-> Column from Examples
Type in what each column value should look like i.e. each field without the text after the '_'
See what the Power Query engine suggests.
In this case it gets it bang on.