Hi, How do parse P1000 into 1000? It will always start with "P" and following with 4 digits.
Solved! Go to Solution.
@wenyg ,
if the string is always P followed by 4 digits, the data cleanse and Regex are expensive overkill.
right([field1],4) is the easiest way.
cheers,
mark