Trim Left Numbers

[jatienza]

Hi,

Need help in trimming the data below. Column "add1" should be trimmed left by the numbers specified in "add2" so the result should be the "output" column.

add1	add2	output
118118002	1	18118002
33320576640	33	320576640
27219794984	27	219794984
4542608240	45	42608240
2302020080	230	2020080

thanks,

Jaime

[DataNath · Accepted solution]

Hey @jatienza, here's one way you could go about doing this - using the ToString() functions to temporarily convert the fields into a string data type so you can use the right functions on them. I've provided 2 output fields here as you'll need to wrap the result in ToNumber() if you want the outcome to be numeric, like in the second expression:

[jatienza]

@DataNath thanks, it's working...