CreativePro Forum

Return to Member Forum

• Author
  Posts
• • March 12, 2015 at 7:23 am #73909
    Cindy Kelley

    Participant

    HI,

    I need to format long dollar numbers such at $1234567 to $1,234,567 and am a bit confused about how to write the Grep Find/Change. Can someone brilliant help me out?

    Also, can I do this with Grep Styles or does it have to be Find/Change?

    Thanks for your help and knowledge.

    Cindy

  • March 12, 2015 at 7:49 am #73910
    Anonymous

    Inactive

    Hi,

    What about
    FIND : (\$\d+)(\d{3})(\d{3})
    REP : $1,$2,$3

    ?

    HTH,

    Loïc

    Accueil

  • March 12, 2015 at 8:27 am #73912
    Cindy Kelley

    Participant

    Thanks Loic!

    That worked with dollar amounts with 7 digits but I also need it for numbers as small as just 4 digits, i.e. $1,234 or $12,345. Is that possible?

  • March 12, 2015 at 1:26 pm #73917
    Anonymous

    Inactive

    I don’t see a good way to make this generic without making two (or more) passes. Change the FIND to (\$\d+)(\d{3}) and run the grep search/replace again. You can do this with just two clicks of the mouse (change all) assuming there are no numbers you don’t want changed in the selection/story/document. Otherwise you will have to manually approve each change (but you are doing that now if this is the case).

    Either that or you resort to a simple script.

    Jake

  • March 13, 2015 at 5:43 am #73924
    Cindy Kelley

    Participant

    Thanks everyone. I ended up making three find/change queries. Since I use the awesome Multi Find/Change app, it’s a one-click solution. Although it would be nice to have a script. My saved Find/Change list is getting a big long. :)

• Author
  Posts