Our Community is getting an upgrade! To get everything ready for the relaunch, we’ll be placing the site in read-only mode starting September 21st.
We really appreciate your understanding while we get things set up behind the scenes. Catch up on all the exciting details about the move here.
Need help or have questions? Drop us a line at [email protected]

Support Questions

Find answers, ask questions, and share your expertise
Announcements
Share your experience with Cloudera on G2 and get a $25 Amazon Gift card.
Hi, I'm CLEO! Something exciting is coming to the Community. Stay Tuned!

How to replace Windows linefeed with Linux linefeed

avatar
Explorer

How can I use ReplaceText processor to function like dos2unix command, i.e. change \r\n to \n

My file comes in with ^M at the end of each line

In the ReplaceText process, I have a Search Value of \r\n

That is correctly finding the Windows linefeeds

However, for Replacement value, I have tried \n also $1\n

 

They each put the character n where I want the line feed to be.

Thanks!

1 ACCEPTED SOLUTION

avatar
Master Mentor

@sfishman 

In the "Replacement value" configuration property just hold the <shift> key and hit enter instead of using "\n".
Here is example of what you would see:
Screen Shot 2020-03-05 at 1.50.51 PM.png

This will create the line return you are looking for.

 

Hope this helps,
Matt

View solution in original post

1 REPLY 1

avatar
Master Mentor

@sfishman 

In the "Replacement value" configuration property just hold the <shift> key and hit enter instead of using "\n".
Here is example of what you would see:
Screen Shot 2020-03-05 at 1.50.51 PM.png

This will create the line return you are looking for.

 

Hope this helps,
Matt