Trim Left Numbers

Question

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.

add1add2output118118002118118002333205766403332057664027219794984272197949844542608240454260824023020200802302020080

thanks,

Jaime

DataNath · Accepted Answer

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: