need help on message mapping
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.
Nilesh Kshirsagar replied
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.