Reg:FCC to ignore the last field name

[Former Member]

Hi...

I am using FCC in the reciver file adapter.

the output structure is like

94,ESSAR,,,,,,,D,0000100226,10000,12/13/1 KURLA EAST,MUMBAI,,400025,006398765432,,2009-03-24 00:00:00.0,0000100226,20202789,,,,SUCCESS,,

/home/corpuser/Disbursement/DD

I am achieving the above structure. But in that i dont want the last field name "/home/corpuser/Disbursement/DD".

Can you please tell how to ignore the last field name in the receiver file adapter using FCC.

Thanks & Regards,

Leela

[former_member206760]

item.fieldnames :abc,xyz,date

item.fieldfixedLengths:say 5,4,0

item.fixedLengthTooShortHandling:Cut

here it will cut the date field and it will not come as content of the target file.

what it means specifically is it will cut all the characters of the last field that is 'date' starting from the char acter position 0.

hope this will solve your problem

[Former Member]

Hi...

But the problem here is, we dont know the exact length of the file. It is not fixed. Will the solution provided by u will work?

Regards,

Leela

[Former Member]

Why dont you remove the line in your mapping?

[Shabarish_Nair]

94,ESSAR,,,,,,,D,0000100226,10000,12/13/1 KURLA EAST,MUMBAI,,400025,006398765432,,2009-03-24 00:00:00.0,0000100226,20202789,,,,SUCCESS,,
/home/corpuser/Disbursement/DD
I am achieving the above structure. But in that i dont want the last field name "/home/corpuser/Disbursement/DD".
Can you please tell how to ignore the last field name in the receiver file adapter using FCC.

Completely with Jai on that.

Dont do that mapping itself. Handle such conditions in your mapping.

Is there any specific reason why you can do so?

[former_member206760]

no this will work only for fixed field length files..

if you are using comma sepearted files..

there is a parameter like lastfieldoptional or ignoremissing field you can check this option ..i am not quiet sure about there exact functionality

[Former Member]

Hi...

I need that field because i am using varaible substitution based on that field. So after doing varaible substitution , i need the file to be places in the FTP folder. While placing the file in the FTP folder, i need to igore that field.

Regards,

Leela

[Former Member]

>>there is a parameter like lastfieldoptional or ignoremissing field you can check this option .

Nope. They are applicable only for sender file adapter.

[former_member206760]

sabarish/ Jai's option of removing in the mapping is also a good one

[Former Member]

Variable substitution is the oldest trick. Go for the more flexible Dynamic attributes to rename your file.

[Shabarish_Nair]

as i have always recommended, please try using Dynamic configuration.

Ref:

/people/michal.krawczyk2/blog/2005/11/10/xi-the-same-filename-from-a-sender-to-a-receiver-file-adapter--sp14

http://help.sap.com/saphelp_nw04/helpdata/en/43/03612cdecc6e76e10000000a422035/frameset.htm

Also search the forum.. you will get loads of sample codes on this.