regex101: PCRE (Legacy) Match Workspace

^start of line

\$?optionally matches the literal $ (36₁₀ / 44₈ / 24₁₆)

Character Class[0-9]{1,3}

{1,3}matches between 1 and 3 characters from the set below:

0-9one character from 0 (48₁₀) to 9 (57₁₀)

Non-Capturing Group(?:,[0-9]{3})*

*repeats the group contents below any number of times:

,the literal , (44₁₀ / 54₈ / 2C₁₆)

Character Class[0-9]{3}

{3}matches exactly 3 characters from the set below:

0-9one character from 0 (48₁₀) to 9 (57₁₀)

Non-Capturing Group(?:\.[0-9]+)?

?repeats the group contents below at most once:

\.the literal . (46₁₀ / 56₈ / 2E₁₆)

Character Class[0-9]+

+matches at least one character from the set below:

0-9one character from 0 (48₁₀) to 9 (57₁₀)

$end of line

Global pattern flags

g modifier: global. Finds all matches instead of stopping after the first

m modifier: multiline. Causes ^ and $ to match the start and end of each line, not only the start and end of the string

Search reference

Regular Expression

^\$?[0-9]{1,3}(?:,[0-9]{3})*(?:\.[0-9]+)?$

Test String
New

Here are some test cases that it needs to match

76,249.25
131,588.00
7.09
21.27
420.42
54.77
32.848
3,056.12
0.009
0.01
32.85
2,948.59
$99,249.25
$9.0000
$1,800.0000
$1,000,000
Here are some test cases that it should not target

666-257-6443
F1A 5G9
Bolt, Locating, M8 x 1.25 x 30 L
Precision Washer, 304 SS, 0.63 OD x 0.31
Flat Washer 300 Series SS; Pack of 50
U-SSFAN 0.63-L6.00-F0.75-B0.64-T0.38-SC5.62
U-CLBUM 0.63-D0.88-L0.875
U-WSSS 0.38-D0.88-T0.125
U-BGHK 6002ZZ - H1.50
U-SSCS 0.38-B0.38
6412K42
Std Dowel, 3/8" x 1-1/2" Lg, Steel
2019.07.05
2092-002.0180
SHCMG 0.25-L1.00
280160717

Regular Expressions 101

Regular Expression

Test String
New

Extraction
Processing...

Regular Expression

Test StringNew

ExtractionProcessing...

Test String
New

Extraction
Processing...