2 Replies Latest reply on Nov 30, 2016 9:42 PM by Mahfooj Khan

    String Extract from messy data

    rakhesh.nellikoppa

      Hi All,

       

      I have field which contains Numbers and String and my requirement is to extract only String. I tried RegEx but due limited knowledge and not global (g) support in tableau not able to get all the String fields.

       

       

       

      Can anyone help me to get this done.

       

      Example:

      1234 US FlORIDA RETAIL

      02345901 UK LONDON IT

      02 NZ FINANCE

      02345 MATCH

       

      in the above example I need only Text excluding numbers. Appreciate your help.

       

      REGEXP_EXTRACT([Text],

      '([A-Z]+)'

      )  -- Tried this code but I am able to extract only one word but required to extract all the words.

       

      Thank you.

       

      Regards,

      Rakesh