2 Replies Latest reply: Aug 15, 2016 11:32 AM by Giacinto Abbruzzese RSS

    keepchar and left load

    Giacinto Abbruzzese

      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.