Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

Using Find and Replace to add comma separator

New Here ,
Jul 09, 2018 Jul 09, 2018

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!

1.7K
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Jul 09, 2018 Jul 09, 2018

Find

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

change to

$1,$2$3

This will work up to six figures

Screenshot 2018-07-09 13.04.34.png Screenshot 2018-07-09 13.06.44.png

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Jul 09, 2018 Jul 09, 2018

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

Tausendertrennung_Komma00.png

After

Tausendertrennung_Komma01.png

Have fun

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Jul 15, 2018 Jul 15, 2018
LATEST

samc4191295​,

do you need further assistance?

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

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines