3 Replies Latest reply: May 15, 2014 9:55 AM by Lynette _ RSS

    Floating templates

    Lynette _

      Hi,

       

      I need to extract the alpha charcs from a string of data. I use Pro 7.

      e.g.

      763037ANCDEF646

      840618999ABCEFG

       

      The output should read as

      ANCDEF

      ABCEFG

      Kindly assist.

        • Floating templates
          Lynette _

          Thanks Todd

          • Floating templates
            Grant Perkins

            Another option would be to use the V7 STRIP function on an extracted field.

             

            If the 'field' is always in the same place in the report format but the position or length of the alpha string changes, the field can be extracted complete and then a calculated field can be used to STRIP all the numeric characters, leaving just the alpha text.

             

            STRIP(string,"1234567890")

             

            should do it, where 'string' is a field name or expression whose content needs to be modified.

             

            Grant

             

             

            Originally posted by Lynette:

            Hi,

             

            I need to extract the alpha charcs from a string of data. I use Pro 7.

            e.g.

            763037ANCDEF646

            840618999ABCEFG

             

            The output should read as

            ANCDEF

            ABCEFG

            Kindly assist. /b[/quote]

            • Floating templates
              Lynette _

              Hi Grant,

               

              That is smart..thanks   smile.gif[/img]