IDOC TO SFTP

[Former Member]

Hi,

Scenario : Idoc to sFTP (CSV file separated with , ) Requirement is to have all data in “ ” e.g. file should be as below: “xxx”,”YYY”,”ZZZ”“ABC”,”oop”,”qqq” I was thinking to achieve solution with below setting:Begin separator “End Separator “Separatedby “,” But issue is as i have given end separator as “ .. enter is not coming after 1^st line. Basically we need end separator as “+nl.

please help me

Thanks

[former_member182412 · Accepted solution]

Hi Srujan,

Use below FCC in receiver SFTP channel and check below discussion.

File Content Conversion - Double Quotes on Output Fields

user_info.fieldSeparator = "," (doublequotes + comma + doublequotes)
user_info.endSeparator = "'nl' (doublequotes + newline)
user_info.beginSeparator = " (double quotes)
Dont put any space in between the characters. Try this and let us know the output. If you put the above parameters then i feel you should get:
"Bob","Jenkins"
"Mike"," Smith"

Regards,

Praveen.