2 Replies Latest reply: Jul 13, 2017 12:51 PM by Sunny Talwar RSS

    parsing out data identifiers

    Monica Labrador

      Hi, I have a field in one table structured like this (text is variable length-could be longer characters) :

       

      123-text

      2134-text

      567-text

       

      but I need the result to look like this:

       

      TEXT_123

      TEXT_2134

      TEXT_567

       

      So, the text is 1. capitalized, and that the 2. separator is an underscore and not a dash and also that the 3. text comes before the number portion. The identifier will always be a dash in the field that needs manipulation.

       

      Thanks for your help,

      M