3 Replies Latest reply: Mar 26, 2015 9:02 AM by Raj Kumar RSS

    In the Edit Script how can create a new field, with an attribute from an existing

    Myles Holland

      Hello all,

       

      I would like to use an existing field called Project ID, in order to create a new field called Office ID.

       

      Each Project ID is made up of four key areas structured like.

       

      Project Type-ProjectYear-Project Office-ProjectCount

      The length of the characters between each "-" varies, but basically I'd like to create a new field that essentially grabs the Project Office. Is this possible using something like mid?

       

      LOAD [Project ID],

        replace(mid([Project ID], X, X), '-', '') as [ProjectOffice],

      Field

      Field

       

      Regards,

       

      Myles