2 Replies Latest reply: Jan 19, 2017 1:42 PM by Wallo Atkinson RSS

    Right function

    Mike Sawyer

      Hi,

       

      I use a script that loads the field "PS #", which is 9 characters.  But, I only want to load the 7 characters on the far right of the string (each record is preceded by a "E.", and I don't want to included those 2 characters in the script).

       

      I tried this and it is not correct:

       

      LOAD

      "PS #" Right(TRIM(),7) AS "PS #",

       

      What is the correct syntax/statment to load these records?

       

      Thanks very much for any help!