keepchar and left load

[gino2780]

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.

[sunny_talwar · Accepted solution]

May be Like this:

LOAD A,

          Left(KeepChar(A, '0123456789'), 9) as [New A]

[gino2780]

That's it. Thanks again!