Skip navigation
Stancaines
Stancaines Calculating status...
Currently Being Moderated

Help me remove Zeroes and add Decimal point using GREP Expression

Apr 19, 2012 7:09 AM

Tags: #cs5 #mac #indesign_cs5 #grep

Hello, I have some numbers. . . A few thousands to be exact that I need to drop some zeroes and add a dollar sign and decimal point representing the cents, how do I do that using GREP Expression. An example of the number would be: 000000000396465 or 000000000044813, it will always be 15 characters I would like that to be converted to this:

$3964.65

$448.13

 

Thank you

Am using Adobe CS5 On Mac

611 Views   6 Replies   Latest reply: Stancaines, May 9, 2012 8:40 AM
 
Replies
  • Marijan Tompa
    Currently Being Moderated
    1. Marijan Tompa,
    Apr 19, 2012 7:20 AM   in reply to Stancaines
    Report

    This will do the job:

     

    Find what: \<([0]+(?=[1-9]))(\d+)(\d{2})\>

     

    Change to: $$2.$3

     

    HTH

     

    --

    Marijan (tomaxxi)

    http://tomaxxi.com

     
    |
    Mark as:
  • Stancaines
    Currently Being Moderated
    2. Stancaines,
    Apr 19, 2012 7:30 AM   in reply to Marijan Tompa
    Report

    YOU ROCK!! Am doing it as we speak, Still Doing Some other Formatting But IT WORKS.

    Thank You My Frind.

     
    |
    Mark as:
  • Marijan Tompa
    Currently Being Moderated
    3. Marijan Tompa,
    Apr 19, 2012 7:33 AM   in reply to Stancaines
    Report

    You are welcome!

     

    --

    Marijan

     
    |
    Mark as:
  • Stancaines
    Currently Being Moderated
    4. Stancaines,
    May 9, 2012 7:02 AM   in reply to Marijan Tompa
    Report

    Have one more question, I have some records like the following

     

    41000000701 01010401060COMPANY NAME INC$10924.1

    The numbers change but there are basically the same amount of characters, How do i ad a space between the company name (COMPANY NAME) and company number (01010401060) with a GREP expression, There are about 50,000 records.

     

    Thanks in advance

     

    Message was edited by: Stancaines

     
    |
    Mark as:
  • Peter Spier
    Currently Being Moderated
    5. Peter Spier,
    May 9, 2012 7:41 AM   in reply to Stancaines
    Report

    Try:

     

    Find (?<=\d)\u   (presuming company names all start with uppercase)

     

    Change <spacebar>$0

     
    |
    Mark as:
  • Stancaines
    Currently Being Moderated
    6. Stancaines,
    May 9, 2012 8:40 AM   in reply to Peter Spier
    Report

    Great, it worked! You Just saved me several weeks of work.

    Thank You,

     
    |
    Mark as:
Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points