Skip to Content
0

IDOC TO SFTP

Nov 01, 2016 at 08:03 PM

38

avatar image

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 1st line. Basically we need end separator as “+nl.

please help me

Thanks

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Praveen Gandepalli Nov 02, 2016 at 02:43 AM
1

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.

Share
10 |10000 characters needed characters left characters exceeded