Using Find and Replace to add comma separator

[samc4191295]

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!

[SJRiegel]

Find

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

change to

$1,$2$3

This will work up to six figures

[pixxxelschubser]

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

[pixxxelschubser]

samc4191295​,

do you need further assistance?

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