cancel
Showing results for 
Search instead for 
Did you mean: 

Need help in Graphical Mapping

former_member216353
Participant
0 Kudos


Dear all,

I've requirement to check if the first two characters of the input are equal to "XM" then remove the first two characters from the input string and only map the rest of the string to a target field.

Please note that the input string does not have a fixed length. So the standard substring is not feasible to be used here.

Let me know if there is a better way to handle it without going to a UDF.

regards,

Younus

Accepted Solutions (1)

Accepted Solutions (1)

Harish
Active Contributor
0 Kudos

Hi Younus,

you can achieve this using graphical mapping. you can check the string using text function start with.

check the below map.

The only assumption is you will get XM in first two places and no other places. If you expect XM in other place of string then you need to go with UDF.

Regards,

Harish

Answers (2)

Answers (2)

Bhavani_Baisani
Participant
0 Kudos

please refer below map

ambrish_mishra
Active Contributor
0 Kudos

You can check for the indexOf XM in the string and remove the value from the first index only.

Ambrish