regex101: JavaScript Match Workspace

Pro

.*any character (except for line terminators), repeated any number of times

Negated Character Class[^a-z0-9]

a-zone character from a (97₁₀) to z (122₁₀) (case insensitive)

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

importthe literal text import (case insensitive)

Non-Capturing Group(?:xml|data|feed|html|range)

1st Alternativexml

xmlthe literal text xml (case insensitive)

2nd Alternativedata

datathe literal text data (case insensitive)

3rd Alternativefeed

feedthe literal text feed (case insensitive)

4th Alternativehtml

htmlthe literal text html (case insensitive)

5th Alternativerange

rangethe literal text range (case insensitive)

\(the literal ( (40₁₀ / 50₈ / 28₁₆)

.*any character (except for line terminators), repeated any number of times

Global pattern flags

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

i modifier: insensitive. Matches without distinguishing uppercase and lowercase letters

26 tokens

Regular Expression

.*[^a-z0-9]import(?:xml|data|feed|html|range)\(.*

New

=SUM(A4..B200)
=IMPORTXML("https://en.wikipedia.org/wiki/Moon_landing", "//a/@href")
=ImportData("http://www.census.gov/2010census/csv/pop_change.csv")
=importfeed("http://news.google.com/?output=atom", B2, FALSE, 10)
=(if(A1=2,IMPORTHTML("http://en.wikipedia.org/wiki/Demographics_of_India", "table", 4),"")
=importRange("abcd123abcd123", "sheet1!A1:C10")

Extraction

=SUM(A4..B200)
=IMPORTXML("https://en.wikipedia.org/wiki/Moon_landing", "//a/@href")
=ImportData("http://www.census.gov/2010census/csv/pop_change.csv")
=importfeed("http://news.google.com/?output=atom", B2, FALSE, 10)
=(if(A1=2,IMPORTHTML("http://en.wikipedia.org/wiki/Demographics_of_India", "table", 4),"")
=importRange("abcd123abcd123", "sheet1!A1:C10")