find numbers with 2 commas

Published on Tue Mar 01 2022

Additional matching regexes for
find numbers with 2 commas

Capture comma separated numbers

Capture comma separated numbers, no matter if there are spaces before or after the commas.

parsing CSV file

It correctly handles simple values, empty values, and quoted values with commas inside.

Match US Currency Amount

Group 1 has dollar amount with or without commas, Group 4 has optional cents.

Find missing or superfluous commas in "For å" constructions.

Finds missing commas in "For å ..." constructions according to officially ordained grammar-based comma rules.

Replace Commas Inside Quotes

Regex to remove commas within quotes. (Common situtaion in .csv files) Eg: data,"some ""embedded"" stuff,commas,inside,quotes",more Replace String would be something like this: \1&\2&\3&\4&\5\&\6&\7&\8&\9 which would replace the commas inside the quotes with '&'s Caveats: * embedded quotes ("") remain in the matches * limit of 9 terms within quotes Work in progress ...

Phone Number Validation

Only Numbers Allowed, Optional (+) for international numbers Min: 10 Max: 14 Optional: +

Swiss MWST

Swiss VAT Numbers

Positive Numbers greater than 0 with leading zeroes.

Accepts all positive numbers above 0. Accepts numbers with leading zeroes e.g.: 0123, 00123.

Portuguese phone numbers

Matches Portuguese phone numbers.

Currency amount validation with sign (cents optional)

Allows Number: Currency amount US (cents optional) Can use US-style 123,456.78 notation Optional thousands separators; optional two-digit fraction; commas; dollar sign