8 Replies Latest reply on Nov 15, 2018 11:27 AM by Anjali Sn

    Split a column on multiple delimiters

    Anjali Sn

      I have a column in my table in the following format: "=1.00", ">=23.00", "<11.00" . I want to split its values on these delimiters: "=", ">=", "<" into separate columns. So that now the two new columns are as follows: Column1 : "=", ">=", "<". Column2 : "1.00", "23.00", "11.00"

      I'm trying to write regex for it but it's not working:

       

      REGEXP_EXTRACT([GOAL],'[^=><]')