Hi all,
I am trying to remove new line characters present in the data.
Currently we are using the "formula" macro and input Regex_Replace([FIELD], "\r*\n*", "") for each and every field.
When working with 100+ columns it becomes very cumbersome.
Is there a way to remove new line characters in one go from all columns?
Thanks.
Solved! Go to Solution.
Echo,
try with "Multi-Field Formula" tool, then choose the fileds you want to remove new lines something like this Regex_Replace( [_CurrentField_], "\r*\n*", "")
i hope this way you can apply the same logic for multiple fileds in one go
Hidanielbrun,
Thanks for your reply.
The problem is that new line characters are present in the headers as well as the data.
So transposing won't help.
Any other suggestions?
can you post some sample of your data struture
You could also Regex the field names after transposing. Please post some sample data, if you are able to.
Best regards,
Daniel
Hi
In the "Multi-Field Formula" tool, what syntax do we use to select all fields in the expression box??
Regex_Replace( [_ALLField_], "\r*\n*", "")
What do we use in place of ALLFIELDS?
In multi filed toold-->configuration --> select the "text" fileds as you have the New lines in string fileds
it will display all the string fileds then click on All
in the exp, Please the " Regex_Replace( [_CurrentField_], "\r*\n*", "")"
where _CurrentField_ is for all selected string fileds
Refer the below image
That works!
Thank you.
Hi,
Your solution looks like it could work for my problem. However, in my multi-formua tool, it is already truncating my data. Please see attached screen shots. Can you let me know where I'm going wrong here please?