have problem in converting XML to CSV in the following structure.

[Former Member]

structure is as follows:

MT_EAN_MASTER

-E1WBB01

-E1WBB03

-EAN_MASTER

--Item_no

--Item_desc

--ean

I have used FCC and CSV is also generated, but the CSV when opened with NOTEPAD it is not showing endSeparator , i.e my first row last element is concatenated with second row first element,there is no row seperator.

But the same when opened with WordPad,we can see the data, row wise

now the destination system open the file in notepad only.

The parameters I have mentioned in FCC are as follows:

Recordset Structure : E1WBB01,E1WBB03,EAN_MASTER

NAME VALUE

EAN_MASTER.fieldSeparator , (comma)

EAN_MASTER.endSeparator 'nl'

E1WBB03.fieldSeparator ,

E1WBB03.endSeparator 'nl'

E1WBB01.fieldSeparator ,

E1WBB01.endSeparator 'nl'

Please provide a solution,why the endSeparator is not shown in NotePad.

Thanks

[Former Member]

Hi Experts,

structure is as follows:

MT_EAN_MASTER

-E1WBB01

-E1WBB03

-EAN_MASTER

--Item_no

--Item_desc

--ean

I have used FCC and CSV is also generated, but the CSV when opened with NOTEPAD it is not showing endSeparator , i.e my first row last element is concatenated with second row first element,there is no row seperator.

But the same when opened with WordPad,we can see the data, row wise

now the destination system open the file in notepad only.

The parameters I have mentioned in FCC are as follows:

Recordset Structure : E1WBB01,E1WBB03,EAN_MASTER

NAME VALUE

EAN_MASTER.fieldSeparator , (comma)

EAN_MASTER.endSeparator 'nl'

E1WBB03.fieldSeparator ,

E1WBB03.endSeparator 'nl'

E1WBB01.fieldSeparator ,

E1WBB01.endSeparator 'nl'

Please provide a solution,why the endSeparator is not shown in NotePad.

Thanks

[Former Member]

Have you check file with another "reader"??

Sometimes Notepad can have some visualization problems.

[Former Member]

Hi,

it depends on the OS using at the server level also...

Try using carriage return line feed...hexa value for the same is 0D0A set this as endSeparator and check it out..

HTH

Rajesh

[Former Member]

Hi ,

I have tried using the CRLF as endSeparator,but the problem is not solved.It get attached to the last column value of the first row and first column value to the next row.

Before also I have used FCC for conversion of XML to CSV.But in this structure it is not working the way it is expected.

Notepad is not showing the seperator but the WordPad do.

So this is not the problem with OS , i guess.

Please Suggest any other solution to the problem.

Thanks