3 Replies Latest reply on Jun 10, 2015 4:28 AM by Obi-wan Kenobi

    How can I get uniform appearance of prices with GREP?

    AlexaKarenFauth

      Hello everybody,

       

      this is what I have:

      Apples 1,99 €

      Bananas Euro 2,85

      Mango € 6,45

      Cherry 11,99 Euro

      Tomato 2,50 €

      Cucumber 1,49 Euro

      Lettuce 0,99 Eur

      Pear Eur 3

       

       

      This is what I want:

      Apples 1,99 EUR

      Bananas 2,85 EUR

      Mango  6,45 EUR

      Cherry 11,99 EUR

      Tomato 2,50 EUR

      Cucumber 1,49 EUR

      Lettuce 0,99 EUR

      Pear Eur 3,00 EUR

       

      This is what I tried:

      search: [Euro|Eur|€?]\s(\d+)[.,]?(\d+)( ?[Euro|Eur|€?])

       

      replace: $1,$2 EUR

       

      It's obviously not working...

       

      Could someone help please?

       

      Thanks a lot.

       

      Alexa