CreativePro Forum

Return to Member Forum

• Author
  Posts
• • June 22, 2015 at 4:09 am #76111
    Ayman Sayed

    Member

    i want to change this format 26.213.950 to 26,213,950
    i want change . to , how can i select . between numbers

  • June 22, 2015 at 5:22 am #76112
    Justin Sligh

    Member

    Ayman,

    I try to use the simplest solution for the text you are using it on.

    (?<=\d)\.(?=\d{3})

    This using a positive lookbehind for a digit, a period, a positive lookahead for at least 3 digits. This will find the periods in your numbers, with the exception periods before a decimal place.

    Keep in mind that if you apply this to an entire document, it could find other numbers. For example, phone numbers separated by periods, and decimals (e.g., 1234.5678)

  • June 22, 2015 at 6:04 am #76113
    Masood Ahmad

    Participant

    or it could be something like:

    Find what: (\d)(\.)(\d)
    Change to: $1,$3

    This will search a period (dot) . between two digits and replaces it with a comma ,

    Hope this is okay for you.

  • June 22, 2015 at 6:25 am #76116
    Ayman Sayed

    Member

    thanks :)
    i try to use this (?<=\d)[.](?=\d)
    but i have a problem :D my function catch 3629 ,
    and your function catch 3232
    ohhhhh i cant believe

  • June 22, 2015 at 7:26 am #76118
    Anonymous

    Inactive

    This is quite precise

    Find
    (\d{2})\.(\d{3})\.(\d{3})

    Change to
    $1,$2,$3

• Author
  Posts