Sender FCC Field separator

[Former Member]

Hi Gurus,

I am working on a File-to-File Scenario using FCC at sender side. My requirement is to convert source text file into xml file.

Source and target structure:

DT_Customer_SRC

Header

CompanyName

CompanyCode

Body

CName

CCode

FCC Configuration:

Recordset Structure = Header,1,Body,1

Header.fieldNames = CompanyName,CompanyCode

Header.fieldSeparator = #

Header.endSeparator = $

Body.fieldNames = CName,CCode

Body.fieldSeparator = #

Body.endSeparator = 'nl'

Source File:

ABC#100$PQR#10

I am getting the error saying File contains more values than the fields specified.

But when I set the Header.endSeperator = 'nl', i get the desired output.

Is this the case that we cannot use more than one separator?

Is it mandatory to use Key?

Any help in this regard is highly appreciated

Thanks,

Jitesh Talreja

[Former Member]

Hi,

Thanks for your time

I tried the options posted by you guys but none of the option has worked.

Are there any limitations on the number of seperators to be used? Is my requirement correct and achievable?

Regards,

Jitesh Talreja

[Former Member]

Hi Jitesh,

Try giving Header.fieldFixedLengths = 3,3

http://help.sap.com/saphelp_nw04/helpdata/en/14/80243b4a66ae0ce10000000a11402f/frameset.htm

Thanks,

Maheshwari

[Former Member]

Hi Maheshwari,

Thanks for the reply.

But i want to achieve this using seperators only.

Regards,

Jitesh Talreja

[Former Member]

Hi Jitesh,

Raise this to SAP. There must be an issue with this.

regards,

Anirudh.

[prateek]

Make sure that the in the notepad file after 10 you have not placed 'Enter'. If there is, then use backspace and save the file and try again.

Regards,

Prateek

[Former Member]

Also try to past Body.beginSeparator as $.

BR,

Dzmitry

[Former Member]

Hello,

Try to use '0x24' instead of $ sign.

BR,

Dzmitry