cancel
Showing results for 
Search instead for 
Did you mean: 

FCC with one field

former_member206760
Active Contributor
0 Kudos

Hi

I have a txt file which has multiple lines and each line will have only one field.

What should the FCC look like ?

My data type -

recordset(1)->rows(1-unbounded)->data(1)

My file -

A001

A002

A003

I tried

rows.fieldNames      data

rows.endSeparator   'nl'

even if I sepecify

rows.fieldSeparator   as , ( comma )  it is not working

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi ,

Did you tried with

rows.fieldSeparator = 'nl'

rows.endSeparator = 'nl'

Cheers,

Rakesh

Answers (1)

Answers (1)

former_member184681
Active Contributor
0 Kudos

Hi,

Try with:

rows.fieldNames = data

rows.endSeparator = 'nl'

rows.fieldFixedLengths = 1

rows.fixedLengthTooShortHandling = ignore

Regards,

Greg

former_member206760
Active Contributor
0 Kudos

Tried but the same error is coming

 

no. of arguments in 'Rows.fieldFixedLength' does not match 'Rows.fieldNames' (0 <> 1)
former_member184681
Active Contributor
0 Kudos

Dear T Shah,

First of all, you must have had a typo mistake, since it's not fieldFixedLength, but fieldFixedLengths (with an S at the end). Moreover, make sure to provide a value for the fieldFixedLengths attribute, since your error says you did not provide one.

Regards,

Greg