Forum Discussion
Solved
Help please! Remove a string of text with fixed format
Hi, I'm a new user and just playing with a datatable, trying to clean up a text field before publish to users. The field is a free text in our system. However in some lines it included a syst...
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 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.
Yes it worked! Thank you!!!!