Removing Line Feed Character

[gesh2112]

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?

[Raj]

Add some sample data and expected output

[ChrisTX · Accepted solution]

In a Formula tool, does this work for you?

Replace([Field1], CharFromInt(10), "/^CR^/")

[gesh2112]

Yes that works.

THANK YOU!!