KeyFieldValue is blank

[Former Member]

Hi All,

I have a scnenario where the input file is as below

Hearder : AAAA BBBB CCC CCC

Ord line :     BBB  CCC  DDDD ( spaces at the starting of the file )

This is a position delimiter file

The ord line contains blank spaces at the starting. i have to declare a keyFiledValue.

xml.ORD.keyFieldValue = '0x20' is not working in sender adapter.Please provide your suggestions.

Regards

GM.

[Former Member]

Hi All,

Thanks for your suggestions,

I have tried all the options which are specified, Its reading the header line, The ord line is coming blank.

Here i have 3 spaces at the starting of the ord line, i am reading it as1+2.

Regards,

GM

[Former Member]

Hi Muneesh,

You may try considering 3 spaces as key value and specify fixed field lengths accordingly.

I am not sure if spaces can be considered for key field value.

Other option may be run a script before message processing to replace the spaces with some other key value.

Regards,

Beena.

[Former Member]

Hi Muneesh,

If you are using Header,1,Data,*  and keyfieldname than you have to use Keyfieldvalue parameter.

Try to use \0 as keyfieldvalue of Data and than use fieldContentFormatting

Note:  fieldContentFormatting will remove all the leading and subsequent blanks for a value. By default.

If you use 'nothing' the value remains unaltered.

Thanks

Shradha

[Shabarish_Nair]

along with your existing parameters use

NameA.fieldContentFormatting - nothing

this will preserve the blank value and help in FCC

[iaki_vila]

Hi Muneesh,

I think not wildcards can be used as key field values.

From my point of view you have two possible solutions:

1. To put header,1,order,*. In this case if you leave the Key Field Name with no value and not to use keyfield parameter in parameter tab, may be it works, (I dont try it, and im not sure).

2. To take all file as one structure and later in the mapping to split the values in their corresponding tags.

Regards.

[Former Member]

Hi,

One option could be to add a custom key field value using an adapter module.

Thanks,
Sathya