Skip to Content
avatar image
Former Member

IDOC TO SFTP

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Nov 02, 2016 at 02:43 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded