topic Mapping a string in Application Development and Automation Discussions

Mapping a string

Former Member — Wed, 30 Apr 2008 06:35:38 GMT

Hi,

I have to mapp a variable matnr = 123-456-789 to matnr = 123456789

what I am suppose to do?

Thanks for your help

Former Member — Wed, 30 Apr 2008 06:39:49 GMT

data : matnr type matnr .

data : a(3) , b(3), c(3).

matnr = '123-456-789' .

split matnr at '-' into a b c .

clear matnr .

concatenate a b c into matnr.

write : matnr.

reward if helpful

Former Member — Wed, 30 Apr 2008 06:41:01 GMT

Write as ...

replace all occurrences of '-' in matnr with ''.

condense matnr.

Former Member — Wed, 30 Apr 2008 06:42:32 GMT

Hi,

Split the string at any special characters found and concatenate the rest of characters into another string.

Once the final string is prepared, move it into a numeric field .

Hope it helps.

Disha

former_member784222 — Wed, 30 Apr 2008 06:42:35 GMT

Hi,

If '-' occurs inside the variable, then you can use

REPLACE ALL OCCURANCES OF '-' WITH SPACE INTO <VARIABLE>.

This will remove '-'. Then you can use CONDENSE <VARIABLE> to remove the spaces.

You need to use convert_exit function module to pad 0 to the variable.

After this you may check the variable againt material master.

Thanks and regards,

S. Chandramouli.