Skip to Content
avatar image
Former Member

File content conversion

Hi SDN,

I have the next task , i'm developing scenario File - XI - File, my input in the sender system is a CSV file , but my issue is when i load the CSV file with the file adapter , the file cann´t load because the next structure

"FRANK","SMITH","FRANK , SMITH"

"RALPH","JONES","RALPH , JONES"

"JOSEHP","",""

this is a example of the file

the fields are :

name,surname,full name

but the problem is that the adapter cann't read the file becase "think" that are 4 fiels instead of 3, because the "," is in the full name field

the standard CSV is correct and i cann´t change the separator field

, how can i configure this ??? ,

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Dec 29, 2006 at 06:26 PM

    Morales,

    You give your field separator as "," and end separator as "'nl'. Then your issue will be resolved.

    ---Satish

    Add comment
    10|10000 characters needed characters exceeded