CreativePro Forum

Return to Member Forum

• Author
  Posts
• • June 15, 2016 at 5:18 am #85770
    Ayman Sayed

    Member

    i want to add “,” in numbers 3454342? 3,454,342

  • June 15, 2016 at 6:05 am #85771
    David Blatner

    Keymaster

    This was discussed on another thread here:

    Add comma to numbers

    The quick answer is there is no “generic” way to do this for thousands, millions, billions, and more… you need to run more than one find/change.

    Also, Peter Spier wrote on the Adobe forums: “First find \d(?=\d{6}\.\d) and change to $0, which will add the comma for the millions, then find \d(?=\d{3}\.\d) and change to $0, to add the comma for the thousands. These expressions work only if there is a decimal number”

    However, there is also a free script here: https://www.id-extras.com/script-to-format-long-numbers

  • June 15, 2016 at 8:32 am #85775
    Kai Rübsamen

    Member

    Hi Guys,

    the following GREP will change

    this:
    1000
    10000
    100000
    1000000
    10000000
    100000000
    1000000000

    to this:
    1,000
    10,000
    100,000
    1,000,000
    10,000,000
    100,000,000
    1,000,000,000

    Find what: \d(?=(\d{3})+)
    Change to: $0,
    

    best
    Kai

    • June 15, 2016 at 9:17 am #85778
      David Blatner

      Keymaster

      Oh my gosh, that’s great! I stand corrected. Thank you, Kai.

    • June 15, 2016 at 11:12 am #85788
      Matt Isaac

      Participant

      This doesn’t work for any number that goes past the thousands place followed by the end of a story

    • June 15, 2016 at 11:16 am #85789
      Kai Rübsamen

      Member

      That is true, because the end of the story is not a boundary. You can fix this temporarily, if you insert a space or a return at the end of the story and remove it later. Of course, this will not work for a grepstyle, but in this special case here, FC is needed.

      Kai

  • June 15, 2016 at 11:04 am #85786
    Kai Rübsamen

    Member

    In Germany we want to have sometimes 10,000 , but not 1000

    In this case you could write: (?<=\d)\d(?=\d{3})|\d(?=(\d{3}){2,})

    Separate telefonnumbers in pairs of two: \d(?=(\d{2})+)

    If there is a separator between the numbers, e.g. a “/”, sometimes this can be a solution: \d(?=(\d{2})+)|\d(?=/)|/

    Hope this is helpful too :)

    Kai

  • June 19, 2016 at 1:32 am #85878
    Ayman Sayed

    Member

    thanks all very much :)))))) amazing

  • June 22, 2016 at 2:28 am #85969
    Ayman Sayed

    Member

    hello guys
    this grep doesnt work into tables – what can i do?

  • June 22, 2016 at 2:32 am #85970
    Ayman Sayed

    Member

    https://postimg.org/image/ubf3eb7t1/
    https://postimg.org/image/a5blffc5h/

  • June 22, 2016 at 3:37 am #85972
    Kai Rübsamen

    Member

    Did you read the comments above?

    is a word boundary. To make clear, what is excactly a word, there is an article from Marc Autret: https://www.indiscripts.com/post/2011/09/what-exactly-is-a-word
    So the GREP will not work at the end of a story. Since every cell behaves like a story, the GREP will fail.

    Solution
    Do it with 3 steps!

    1. Insert something that could be a boundary
    Find what: \d\Z
    Change to $0~<

    2. The FC on the numbers
    Find what: \d(?=(\d{3})+)
    Change to: $0~<

    3. Remove the space at the end of the cell (the story)
    Find what: ~<\Z
    Change to: nothing

    If you work with a GREP-Style instead of FC, don’t do step 3!

    best
    Kai

• Author
  Posts