Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

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
Super 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
Super 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