CreativePro Forum

Return to Member Forum

• Author
  Posts
• • March 6, 2014 at 12:01 pm #67467
    Kiley

    Member

    Did not catch it before copying & pasting into my indesign doc, but I just pasted all prices formatted as currency ($##,### or $###) in Excel, but I need them to be just digits (##### or ###). I fear that GREP may be needed. I have no clue where to start? Help!

  • March 6, 2014 at 12:03 pm #67468
    Kiley

    Member

    I should add that all of the text I want to change (& the only text I want it to look at) is in table cells.

  • March 6, 2014 at 12:19 pm #67469
    Kiley

    Member

    \$\d+\,\d\d\d finds the first type of price I’m looking for but I do not know how to replace it with the digits.

    • March 9, 2014 at 5:04 pm #67515
      Steve Jenks

      Member

      Hi Kiley

      I believe if you search for (\$)(\d+)\,(\d+) and replace with $2$3 that it will work.

      This searches for a ‘$’ followed by one or more digits, followed by a comma, followed by one or more digits and then replaces with just the found digits.

      I think this is what you are trying to achieve”

      Steve

    • March 11, 2014 at 10:54 am #67558
      Kiley

      Member

      Thank you, GREP genius! I’m so thankful. I’m hoping my Boss will get me a Lynda.com account soon so I can take some classes on GREP. I think it would really help things along.

  • March 11, 2014 at 3:32 pm #67560
    Anonymous

    Inactive

    You’re welcome Kiley.

    If you have the time, a good way to practice and learn GREP is to visit forums like this and read through the solutions, plus of course pitch in and try to work out a solution yourself if you can.

    The latest version of Indesign Magazine has some really good GREP articles in it that are really clear and easy to understand.

    Steve

• Author
  Posts