Help with FCC parameters

[Former Member]

Hi,

I have the source file in the following format

USD	2345	23443	23454	234543	23456	23456	234546	23456	23454	23462	5634
USD	2345		23454	234543			234546	23456	23454	23462

I want to accept all the data as single Field

What FCC parameters do I need to place?

I placed endseperator as 'nl' and without fieldSeperator, the file s not being picked

I have declared the source file as STRING. how to I specify the maxlength to the MAX when I specify it as "............" generating me error message.

Thanks,

Nikhil.

[nisarkhan_n · Accepted solution]

you can read all the fields using the FCC and in mapping combine it all to one field as said above...

else

use the fieldfixed length and give the maximum length here..use the fieldseprator = 'nl' by default the end separator will be line break else you can try 'nl' also....

[Former Member · Accepted solution]

Nisar,

I get multiple records each time

dont know wats the no of records in each file and dont know wats the fields each records will contain

how can I acheive this using FCC parameters alone?

[Former Member · Accepted solution]

Hi Nikhil,

FCC parameters will be.

Record Structure: Structurename,*

Where * represent it will come many times in the file.

Structurename.fieldFixedlength=maximum length of string in the file (for ex=150)

Structurename.endSeparator='nl'

Structurename.fieldName=STRING

Try this it will work.

Thanks and Regards,

Chirag Gohil

[Former Member · Accepted solution]

Thanks Chirag,

trying it now....

[santhosh_kumarv · Accepted solution]

>>I would like to accept all the records at the same time as Single field

Do u mean that u need to have the total content of the file to be as a single field?

For this input

USD	2345	23443	23454	234543	23456	23456	234546	23456	23454	23462	5634
USD	2345		23454	234543			234546	23456	23454	23462

1. Do u need to create 2 records of single field each 0r

2. Do u need to create a single record with single field holding all the data.

Regards

San

[nisarkhan_n · Accepted solution]

you dnt have to worry about number of records in each file but yes for the length of each row (gove maximum just to try) this should work

[Former Member · Accepted solution]

Yes Santosh,

all the files, fields , records , everything of the source must be sent as one and single input field

Thanks,

nikhil.

[santhosh_kumarv]

Hi Nikil,

>>I want to accept all the data as single Field

Use the FCC

fieldname.fieldSeperator = 'nl'

Regards

San

[Former Member]

hi nikhil,

First you separate all the fields using content conversion

like

<USD>

<2345>

<23443>

....

<USD>

<2345>

<>

....

Then in mapping you can use concat function to combine all the fields in to the resultant string. I think this should work out for you

regards

Ramesh P

[Former Member]

@ Ramesh,

I dont need to seperate it

FM has code to seperate it based on the | symbols

now I need to accept all the records of the file as a single file

@ San

When I place 'nl' its accepting only the first record

I would like to accept all the records at the same time as Single field

thanks

nikhil

[Former Member]

PS :

There are n no of records inside a single file seperated by nl

I have to accept all the records' s field as a single input and send it

thanks

Nikhil.

[Former Member]

hi nikhil,

Can you be bit brief on what your FM returns..

regards

Ramesh P

[Shabarish_Nair]

use the Record Row type FCC as mentioned in this blog - /people/sravya.talanki2/blog/2005/11/29/night-mare-processing-huge-files-in-sap-xi