Participant

Question

Using Find and Replace to add comma separator

Hi Guys,

I'm working on a project and was wondering if a GREP find/replace would help me out with this change.

Currently in my layout, I have a square footage number followed by SQFT. (example: 2320 SQFT.)

Is there any way that I can get a comma to be added in to separate the thousands? I've tried endlessly but still haven't been able to figure it out.

Thanks!

This topic has been closed for replies.

Community Expert

do you need further assistance?

(You know - no feedback is the worst feedback.)

Community Expert

Try this

my settings:

Find:

(\d{1,3})(?=(\d{3})+ SQFT\.)

or simple (\d)(?=(\d{3})+ SQFT\.)

Replace with:

$1,

change format: character style: color red

Before

After

Have fun

Legend

Find

(\d)(\d\d\d)( SQFT.)

change to

$1,$2$3

This will work up to six figures

Sign up