FCC field separator

[Former Member]

Hi All,

Is there any solution for the field separator parameter if the flat file is having single space(not the TAB) as a field separator. I tried copy paste of that space. But it is taking all the filed values in one element.

[Former Member · Accepted solution]

Use this parameter for your content conversion in the sender file adapter.

structure.fieldSeparator = '0x20'

this is the hexadecimal conversion for space.

-

---

don't forget to rate.

[Former Member · Accepted solution]

Hi

I tried '0x20' but also it is giving the same result as below

- <Record>

<Sales_Org_cd>0080055688 272491D ADR 0.00 0531140000000 1-NUJGU C C B119 -1512.00 32996836 0.00</Sales_Org_cd>

</Record>

[Former Member · Accepted solution]

did you test it by removing the single quotes around the value.

can you list your FCC parameters.

[Former Member · Accepted solution]

check out this thread.