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

    String Extract from messy data


      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.



      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.




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


      Thank you.