5 Replies Latest reply: Mar 24, 2014 9:36 AM by Dag Mikal Kjensbekk RSS

    Modify data from a table

      Hi,

       

      I am loading data from a table and would like to remove the two last characters of the field PRV_CODE. (#0)

      These characters is allways in the end of the value, but the length of the PRV_CODE can vary.

      Any idea?

       

      PRV_RENTITYPRV_PROPERTYPRV_CODEPRV_NVALUE
      PMCFESTTIMER83#05.000000

       

      Best regards
      Dag