Naveen Rayappa
Naveen Rayappa

Reputation: 119

CR removed from csv using mule sftp connector

I am writing a csv file to the 'Linux sftp' location using mulesoft sftp connector. Unfortunately , when i write csv file to sftp location, 'CR' is being removed from each line of the csv . Client is very much specific with 'CR' and they want it be present in file to be able to successfully process it. I was doing some research on this and found out we should use 'ASCII mode ' or 'text mode' for transmitting data to/ from sftp to preserver 'CR'. I don't find any option to set transfer mode on SFTP connector . Anybody has encountered this issue ? can anybody please help me with this .

Upvotes: 0

Views: 186

Answers (1)

Mahesh_Loya
Mahesh_Loya

Reputation: 2832

You can choose the encoding as US ASCII

Go to your SFTP connector > Advanced tab > "Encoding" drop down > Select Encoding US ASCII

Let us know if this resolves the issue.

Upvotes: 1

Related Questions