Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
13137306792 |
12813582416 |
12069220880 |
13153391459 |
15198425434 |
12675882895 |
May be this
Right(Left(Number, 4), 3) as Number
Thanks - I knew it was something simple, but couldn't sort it out.