Comma Delimitted file

[Former Member]

Could some one help me in , how to configure a file adapter, I have 5 fields in the incomming file and they are separated by COMMAS.

Thanks.

[MichalKrawczyk · Accepted solution]

Hi Karen,

have a look at my friend's weblog:

/people/sap.user72/blog/2005/01/06/how-to-process-csv-data-with-xi-file-adapter

fieldseparator colon

but it's the same with comma

Regards,

michal

[Former Member · Accepted solution]

Thanks Michal. One another question related to the File.

Let us say I have 5 fields and the leght of the fields are given, in this case how do we configure the Sender File Adapter.

length Start Position End position

Field 1 10 1 10

Field 2 5 11 15

Field 3 2 16 17

Field 4 3 18 20

Field 5 15 21 35

[MichalKrawczyk · Accepted solution]

hi Karen,

have a look at my first weblog:)

/people/michal.krawczyk2/blog/2004/12/15/how-to-send-a-flat-file-with-fixed-lengths-to-xi-30-using-a-central-file-adapter

Regards,

michal

[Former Member · Accepted solution]

Thanks a lot Michal.

Congratulations for reaching 5000 Mile Stone. Amazing Record, great work.

[MichalKrawczyk · Accepted solution]

>>>Thanks a lot Michal.

glad I could help

>>>great work.

thank you

Regards,

michal