CSV conversion problems in File adapter

[Former Member]

Hi,

Hi,

We had a problem with CSV conversions in file adapter.Our scenario is: IDOC>Xi>FTP(csv)

Our target file should be show as when I open in notepad:

"Active","1234","fdsfs","fsdfsdfs"

"","","fsdfda"","Fsdfsfsdfsdf""12202003"

Is this possible for put "Double quotes" for each and every field.

currently my conversion file is coming like this:

Active,1234,fdsfs,fsdfsdfs

,,fsdfda,Fsdfsfsdfsdf,12202003

when I open this file in excel ..some fields data occupying next or before cells...it means mismatching the data between cells.

probably if I put "double quotes" for each and every field then i could aviod this mismatch data presentation in different cells in excel?

Thanks,

PILearn

[Former Member · Accepted solution]

Hi,

When you try to open such files in Excel...if there is no space between two field even it is comma....it will take it as whole string...

if you have fixed length...excel gives you the option either with delimiters or with fixed lengths.

Regards.

Akshay.

• Reward points if find useful.

[Former Member]

Hi,

Is your problem solved??