9 Replies Latest reply on Jan 12, 2017 2:35 AM by winterm

    Easy Catalog regex

    Kevin19981

      I have a table with data in it. There is a column "prices" some data is 0 and I want to replace it with - But i also have 0,25 and that has to stay like it is.

      So:

      0 -> -
      0,25 -> 0,25
      01 -> 01
      000001 -> 000001

       

       

      I want to replace the single character 0 to - .

       

      What I tried:

       

      REGEX:^^0=-;

       

      This code replaces the first 0 of all the strings so:

       

      0 -> -

      0,25 -> -,25 (BUT I want this to stay)

       

      Any ideas?