I'm trying to come up with a simple way create a variable in my load script to ignore the leading "1" in a number and return the first three numbers to the right of the "1". Example numbers are below.
May be this
Right(Left(Number, 4), 3) as Number
Thanks - I knew it was something simple, but couldn't sort it out.
Retrieving data ...