Skip to Content
0
Former Member
Nov 27, 2012 at 07:42 AM

Map help

15 Views

Hi Everyone,

I want some help with mapping requirement,

the easiest way to explain the requirement to provide examples. The simple explanation is to extract everything except the last five characters from source feild and map to target feild. See below.

if the source feild = 7TW7003-USP1, THEN i only want 7TW7003

if the feild = 7TW7005-USP1, THEN MAP 7TW7005

If the feild = S5079826-1-USP1, THEN MAP S5079826-1

Please help me with the above requirement.

Regards

Swetha