endSeparator 'nl' is not working in the Receiver FCC parameters

[Former Member]

Hi All,

I am doing a RFC to File scenario in which i need to create a file with following structure:

Item11 Item12 Item13

Item21 Item22 Item23

Item31 Item32 Item33

....

I am able to generate a file which is tab delimited but all the next line items I'm getting continution of the first line..

The file that i am getting is as follows:

Item11 Item12 Item13 Item21 Item22 Item23 Item31 Item32 Item33

I need a new line between each Item level . For rest all parameters are working fine.. that means.. Filed seperator (tab delimited or ,$ every thing is working .. except this new line).

In my file receiver adaptor in Content Conversion I have made following settings:

Data.fieldSeparator = '0x09'

Data.endSeparator = 'nl'

I tried with 'nl' ,'0x0D' ,'\n' .. ect... those all options but those ar not working for getting in a new line... if i keep endSeparator as $ means it is working ... but i want to keep each level in a new line..

Can anybody plz suggest where i am going wrong? Or is there anything else i should do?

Thanks,

Jain

[Former Member · Accepted solution]

Try removing

Data.endSeparator = 'nl'

as newline is default endSeparator.. even if you dont mention it should work..

[Former Member]

Solved

[Former Member]

would be helpful if you explain what are the things you did to resolve this rather than just reply with 'SOLVED'

[Former Member]

Hi All,

I am also facing the same issue,when my csv is generated while opening it in notepad I am not getting endSeparator as newline, The second record is in continuation with the first record.

Please provide some solution to this problem.

Thanks

[former_member190389]

Which tool are you using to open the output file.

If you are using Notepad use Wordpad instead .Sometimes it hppens that new line is present but not seen

[Former Member]

I had tried by removing the endSeparator .. even thogh it is not working...

and I'm using Notepad to view the text file.. .. Even in Wordwrap also it is dispaying in the continution of the first line... ..

any help.. please....

Regards

Jain

[Former Member]

How is your data type?

If it is something like below shown, then you should get newline after each Data as per your requirement..

MT_....

.......Data

.............Item1

.............Item2

.............Item3

Also have you specified

Recordset structure = Data

[Former Member]

Hi,

Check your Message type structure , it should be in the below format

<Docname>

<Recordsetname>

<sub1>

<f1>

<f2>

</sub1>

<sub2>

<f1>

<f2>

</sub2>

now you can assign 'nl' for <sub1> and <sub2> only....

eg:

Orders

Header

OrdNo

Sorg

Items

matno

units

Quant

Now you can asssign 'nl' like below

Header.endSeparator = 'nl'

Items.endSeparator = 'nl'

- Satish