Upload flat file with no field separators

[Former Member]

Hi,

how can i upload a flat file containing no field separators? That means the only way to identify rows is to count the characters. If i look at the documention two parameters should help:

- fieldFixedLengths

- fieldSeparator

Problem: If i add the fieldFixedLengths parameter the system expects a comma as field separator (online docu). Why?? Of course i can choose another field separator - but any field separator must be at least as long as one character (online docu).

Any ideas?

[cdumont69 · Accepted solution]

Hello,

I am not sure to understand your problem. If you want to use fieldFiwexLengths you don't need filedSeparator.

When you read in doc "Specify a character string containing a list of fixed column widths that are separated by commas and determine the number and the length of columns generated in the text file". Commas are used to separate your FixedLength.

<u>So for example:</u>

Toto is going to the market

<u>You can use:</u>

FieldFixedLength=5,12,10

<u>That give you:</u>

<actor>Toto </actor>

<action>is going to </action>

<location>the market</location>

Regards,

Chris

[Former Member]

Hi,

chk this blog:

/people/michal.krawczyk2/blog/2004/12/15/how-to-send-a-flat-file-with-fixed-lengths-to-xi-30-using-a-central-file-adapter

here no field separator is used.

regards

Priyanka

[Former Member]

Thanks all... my fault! what a day today!

[Former Member]

Hi Christian,

You need to use File Content Conversion as your message protocol.

You might be talking of this:

<i>If you make an entry here, the system expects a character string that contains the lengths of the structure columns as arguments separated by commas.</i>

You need to give the commas while mentioning the lengths of the records and not while giving the data.

I hope it helps,

Thanks & Regards,

Varun Joshi