How can I read a flat file into one field with FCC?

[bekirakturk]

Hi Experts,

I am trying to read a flat file into one field wit FCC and my file structure is like

aaaaaaaaaaa

bbbbbbbbbbb

ccccccccccc

Thanks for your replies

[former_member184681 · Accepted solution]

Hi,

Your config is almost ok, assuming your file will never exceed 10 000 000 characters The only thing you need to change is the endSeparator - with your example data, only first line would be read properly. Try using some character that you expect to never occur in the file, e.g. "~" or something.

Regards,

Grzegorz

[bekirakturk]

Hi All,

Thanks for your helps! we did handle the situation by java mapping.

Regards

Bekir

[nabendu_sen]

Hi Bekir,

Please choose the correct answer and close the thread as per .

Regards,

Nabendu.

[nabendu_sen]

You can try Java Mapping to handle this.

Read Input Text File as a Single Field. - Process Integration - SCN Wiki

Regards,

Nabendu.

[Former Member]

Hello,

I think, it's not possible to read entire file into one field usiing FCC. But what u can do is u can read each line into a separate DATA element.

So ur FCC will be:

RecordSet Structure - item,*

item.fieldNames - Data

item.fixedFieldLength - 100000

item.fieldSeparator - 'nl'

Thanks

Amit Srivastava