Regular Expressions 101

Community Patterns

Community Library Entry

0

Regular Expression
ECMAScript (JavaScript)

/
\+?\d{1,4}?[-.\s]?\(?\d{1}?\)?[-.\s]?\d{1,3}[-.\s]?\d{1,3}[-.\s]?\d{1,3}
/
g

Description

This is data from many years and my boss want me to extract all the number in spreadsheet, it's about 14,000 records

Submitted by Le Nam Son - a year ago