2 Replies Latest reply: Jun 11, 2014 10:42 AM by F. Arabak RSS

    FDMEE Jython Script Help

    F. Arabak

      My data load imports have been thrown a curve ball. I used to have a 1 or 2 digit number to map. If it was one digit I simply added a zero to the beginning (i.e., FillL to convert 1 to 01). But now I have a leading 4 digits and a hyphen. So instead of "1" I have 2500-1, and instead of "12" I now have 2500-12. I need to strip off what is to the right of the hyphen and then add a leading zero if it is not already 2 digits. Does anyone know the script that would accomplish this?

       

      Your help is much appreciated.

       

      FA