Forum Discussion
Help please! Remove a string of text with fixed format
Hi Lifan
No problem when you have created the additional column (Column1), when it does not find anything after the delimiter it should then have a result of null
So then what you can do is to create a conditional column where if the Additional Column (Column1) is null then use the Original column.
In doing that you will get the output you require.
Super UserHi Lifan
When using the Query Editor, I would suggest the following:
- Duplicate your column, so that you still have your original column.
- Then in the duplicated column right click and select "Split Column", then select "By Delimeter"
- When the Window Opens where it says "Select or enter delimiter" select "Custom" and then put in ";"
- Then click Ok.
- Now you should see the following as shown below.
Hi Guavaq,
Thanks but problem is the content doesn't always have the code in there... sorry if didn't make it clear earlier.
It's like this:
24f1ef97-5df5-4d3f-8976-eeca0e157432;Creative Production,Production
ABC promotion
Production charge
245B3897-3ef5-4d9f-5184-ebe5015e7432;7/5,6/7 active
need to change to this:
Creative Production,Production
ABC promotion
Production charge
7/5,6/7 active
- GilbertQ
Hi Lifan
No problem when you have created the additional column (Column1), when it does not find anything after the delimiter it should then have a result of null
So then what you can do is to create a conditional column where if the Additional Column (Column1) is null then use the Original column.
In doing that you will get the output you require.
- Phil_Seamark
Microsoft Employee
Maybe split to rows using the ";" char in Power Query and filter out any rows that contain a "-"
Yes it worked! Thank you!!!!
