Hello,
I am trying to figure out how to remove the Line Feed character and replace it with /^CR^/. I have replaced all the Carriage feed characters with it. But nothing I have tried actually removed the line feed character.
Below is a sample of a .csv file that was processed through my workflow. I open up the .csv in NotePad++ and showed hidden characters.
I used a Replace to remove the Carriage Return. I have also tried Regex_Replace.
Does anyone know what I need to put in my workflow to remove it?
Solved! Go to Solution.
Add some sample data and expected output
In a Formula tool, does this work for you?
Replace([Field1], CharFromInt(10), "/^CR^/")
Yes that works.
THANK YOU!!