XI mapping problem

[Former Member]

Hi,

i am new to XI can any body tell me how to do mapping when we have file with details....

name age gender ......

xxxxx 99 M ....

i have requirement that i need to convert the name into two parts like first name and last name....

please give me the solution it is urgent....

Regards,

Adarsh

[Former Member · Accepted solution]

Hi,

if the two names have a fix length you can use the substring function.

Otherwise you will have to write a user-defined-function.

What is the separator for the two names?

Regards

Patrick

[Former Member]

thanks all, solved the problem....

[former_member187563]

hi,

the url for normal message mapping is:

http://help.sap.com/saphelp_nw04/helpdata/en/4f/ef761a5ecfb1418b79896e10fe4c57/frameset.htm

if you want separate the names in two part then you use substring function,that is a text kind of function.

reward points if helpful

regards,

ujjwal kumar

[vijay_b4]

Hi Adarsh,

you have to write an UDF to split the name into first and last names.

for udf use space as delimitor and you can write the code.

eg: name should be given in this format "xxx yyy".so use space as delimitor and write the code.

Reward points if this helps....

Regards

Vani.

[pradeep_nellore]

Hi,

Use substring function.

Thanks

--Pradeep