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.
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
Super UserHi 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!!!!
