Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

need help on message mapping

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
Former Member replied

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

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question