Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
for my data load i need script commands that loads a field in a certain format.
E.g.: Field A has strings in the format shown below (A). I'd like to get rid of the strings like "-" & "/" and cut the data on 9 numeric digits (New A).
A
00-000-0000/1
11-111-1111/2
22-222-2222/3
New A
000000000
111111111
222222222
Thanks in advance.
May be Like this:
LOAD A,
Left(KeepChar(A, '0123456789'), 9) as [New A]
May be Like this:
LOAD A,
Left(KeepChar(A, '0123456789'), 9) as [New A]
That's it. Thanks again!