FCC Parameter

[Former Member]

Hi ,

I have a flat file whtch contain Country code and Country name with sapce in both , As Example is given.

AF Afghanistan

AG Antigua and Barbuda

AI Anguilla

AL Albania

AM Armenia

AN Netherlands Antilles

AO Angola

Please give me Content Converstion parameter details for that.

Thanks

Laxmi Bhushan

[GabrielSagaya]

I assume this is for sender File Adapter with file content conversion

for the input structure

<filecontent_ip_mt>

<root>

<country>

<countrycode/>

<countryname/>

</country>

</root>

</filecontent_ip_mt>

Specify the following in the sender cc.

Adapter Type :FILE

Transport Protocol : FILE SYSTEM(NFS)

Message Protocol : File content conversion

specify the source directory and the file name from where you have to pick the file.

Processing mode should be DELETE.

Document Name : filecontent_ip_mt

Document Namespace:

Recordset name : root

Recordset Structure : country,*

Recordsets per message : *

country.fieldNames=countrycode,countryname

country.fieldSeparator=0X20

country.endSeparator='nl'

[rodrigoalejandro_pertierr]

plase, paste the Data Type you created for this file and we will give you the proper FCC parameters

[Former Member]

Hi Laxmi,

Can you please tell me one thing Country name values have any SPACE in-between or not( E.g.,?.Antigua and Barbuda or Netherlands Antilles )

If it has SPACE in between then it will be a problem if you specify SPACE as field separator.

Regards,

Nayan

[Former Member]

Hi laxmi,

Assuming the recordset name ins row, apply the below FCC parameters:

row.fieldNames: <Name of the 2 fileds(country ID & Country Name)>

row.fieldSeparator: '0x09'

row.endSeparator: 'nl'

-Supriya.

[Former Member]

Hi,

Refer this:

/people/shabarish.vijayakumar/blog/2005/08/17/nab-the-tab-file-adapter

and use this Hexadecimal representaion for space '0 x 20'(instead of Tab in above mentioned blog).

Thanks

Amit