cancel
Showing results for 
Search instead for 
Did you mean: 

Flat file-XI-Flat file - How to retain space?

0 Kudos

Hi All,

I am trying to upload flat file > XI (XML mapping) > output flat file. Its all working fine but the space characters in the flat file is erased when converted in XI.

Example: my flat file

0123<&nbsp><&nbsp><&nbsp>ABC<&nbsp><&nbsp>XYZ<&nbsp><&nbsp><eof>

is converted to

<Body>0123 ABC XYZ</Body>

What should be configured as that I can have xml element to be like below ?

<Body>0123<&nbsp><&nbsp><&nbsp>ABC<&nbsp><&nbsp>XYZ<&nbsp><&nbsp></Body>

Thanks & Regards,

Kushi

Message was edited by:

Kushi

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi ,

To retain space add the following in FCC.

StructureName.fieldContentFormatting = nothing

Try this if it doesnt work let us know.

Regards,

Sumit

0 Kudos

Hi Sumit,

Thanks yes it did work and the spaces are retained.

But now, the monitor shows success flag and also the mapping is fine but the file is not getting converted/saved as flat txt file in reciever folder ?

Regards,

Kushi

Former Member
0 Kudos

Hi,

Check in Communication Channel Monitoring the error for your Receiver File Adapter. There must be some error in your FCC parameters.

Regards,

Sumit

0 Kudos

Thanks Sumit.

Also the XML presentation on GUI is misleading so when I opened in a text editor you can still see all the spaces. With <structure>.fileContentFormatting = nothing, it helped in keeping the leading and trailing spaces though!.

Former Member
0 Kudos

Hi Khushi,

It is a little misleading/confusing in the beginning. But that is the way it is supposed to behave.

Regards,

Sumit

Answers (0)