Free text mapping

[Former Member]

I need to transform content of a file with the structure as follow

<b>Name</b> [tab] Name1

<b>Name</b> [tab] Name2

....

<b>Name</b> [tab] Name3

<b>Group</b> [tab] Group11 [tab] Group12

<b>Group</b> [tab] Group21 [tab] Group22

<b>Group</b> [tab] Group31 [tab] Group32 [tab] Group33

....

Note: [tab] = '0x09'.

With this kind of structure, what type of mapping should I use?

Can I use message mapping, or need to use Java mapping or other type?

Thanks

[santhosh_kumarv]

Use the FCC parameters,

Name.fieldSeparator = '0x09'

Name.endSeparator = 'nl'

Group.fieldSeparator = '0x09'

Group.endSeparator = 'nl'

Note u also need to use the keyFieldName and keyFieldValue to diff btw Name and Group in the FCC.

Regards

San

[Former Member]

Thanks Santosh.

[agasthuri_doss]

Hi,

you can use Message Mapping to acheive it

Regards

Agasthuri Doss

[Former Member]

How does the engine know to separate the [tab] character here?

[santhosh_kumarv]

Hi,

>>How does the engine know to separate the [tab] character here

You need to specify the field separator as [tab] in the FCC of the Sender file adapter...!

Also have a look into the Blog <a href="/people/shabarish.vijayakumar/blog/2005/08/17/nab-the-tab-file-adapter Delimited files</a> By Shabarish Vijayakumar

Regards

San

[Former Member]

sorry,your question is not clear,could you please explain a little bit more

Thanx

Aamir