Regular Expressions 101

Community Patterns

Community Library Entry

0

Regular Expression
PCRE2 (PHP >=7.3)

/
([0-9]+)(?:')
/
gm

Description

This only works in Google sheets. The test string is a sheets formula that converts feet inches in this<6' 6"> into the total number of inches.

Submitted by randywolf244 - 3 years ago