Hi - I have a data source with a column that has some IDs with leading zeros and some without. I'd like to clean up that column to remove leading zeros if they do exist.
Example Data
Customer ID:
0011192977
10023511
11067502
0001308243
Expected Result
Customer ID:
11192977
10023511
11067502
11308243
Solved! Go to Solution.
Hi @nmitch
Two options:
1) Use the function TrimLeft([Customer ID:],'0')
2) Change the datatype of the field to numeric with the select tool
Hi @Felipe_Ribeir0 I used your first option and that did the trick - thank you!