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.