need help on message mapping

[Former Member]

Hi All,

I have a requirement to split the source field into two fields to pass two fields as a target eg., source field1 = '1000 PQ' target shld be field2 = '100' and field3 = 'PQ'

and another requirement is source field is '1000.00 USD' target field shloud be '1000.00'

Please let me know is there any standard function to aceive this or how can i get this. Thanks.

Kalpana

[Former Member · Accepted solution]

Kalpana,

Is this length of input data is fixed? I mean first 4 characters would be always number and last two character? if so then you can used substring where you can specify starting position and length.

If not then in your source value between two values i.e. 1000 and PQ there is space so than you can write an UDF to check space and take first n characters and last n characters base on space position using java.

You will find lot of java code online for this purpose...

Let us know if you do not find anything.

Hope this will help.

Nilesh

[Former Member]

Hi

you can use the following functions in the graphical mapping

source field>substring(length 14)-->target field1

source field>substring(67)-->target field2

and for second yo can use the formatNum function in the graphical mapping.

Thanks

Rinku

[Former Member]

use substring or UDF function in the message mapping.