Back

If your email is not recognized and you believe it should be, please contact us.

  • You must be logged in to reply to this topic.Login

Delete everything before a character

Return to Member Forum

  • Author
    Posts
    • March 24, 2020 at 10:54 am #1234965
      Marco Machado
      Member

      Hello,

      I am making a catalogue and it has a lot os prices in it, I want to make a version without prices also but the only way is to delete the prices one by one because they are inside individual boxes.

      Is there a way to delete everything that is before the symbol “€” using Find/Change tool? For exemple it’s “1.329,00 €” I want it to be “€” because the symbol is easy to remove after with Find/Change. The prices are all different.

      Thank you

    • March 25, 2020 at 2:03 pm #1235174
      Gopa Campbell
      Participant

      There may be a more elegant way of doing this with a grep style, but short of that, I would do it with variable in two or three stages:
      First I would do a find/change with 4 of the number variable (^9), a decimal point/period then 2 numbers, a space and the Euro sign (^9^9^9^9. ^9^9 €) in the find box, and just the Euro sign in the change box.
      If some of your prices have only 1, 2 or 3 numbers before the decimal point, you can do a second search after you have completed the first one. This time you do ^9^9^9. ^9^9 €) in the find box, and just the Euro sign in the change box, and so on.

    • March 27, 2020 at 10:02 am #1235394
      Peter Kahrel
      Participant

      Gopa’s solution works, and at the same time it’s a nice illustration of how useful GREP is. To delete amounts before the Euro symbol, do this:

      Find what: \d[\d.\x20]*?(?=€)
      Change to:

      In normal mortals’s words: ‘find a digit followed by any string of digits, dots and spaces, only if it/they is/are followed by the Euro symbol’.

      P.

    • March 30, 2020 at 10:20 am #1235555
      Masood Ahmad
      Participant

      Well…if you really want to remove the number and the Euro currency symbol altogether, then this would suffice.

      GREP Find/Change:
      Find What: \d[\d.,]*\x20€
      Change to:

    • March 31, 2020 at 1:34 am #1235855
      Aksh Patil
      Member

      Develop your business by purchasing google surveys and google place audits to build your reach on google look.
      purchase google reviews

  • Author
    Posts
Viewing 4 reply threads
  • The forum ‘General InDesign Topics (CLOSED)’ is closed to new topics and replies.
Forum Ads