corpus.blog
56,966 blogs · 4,417,066 posts Claim your blog
Record · corpus.blog/posts/01a0be08-044d-7354-bea4-bd7c57c999cf

What are regular expressions — and how to use them in Google Sheets to get data from text

onlinejournalismblog.com · published 22 June 2021

A record is what was published and who pointed at it. The text of the post is not held here: read it at the source, or at its Wayback capture.

Read the post at onlinejournalismblog.com Wayback capture
0blogs citing
First cited
—
Most recent
—
Rank this month
not ranked
Links from this post
40
Words captured
6,479

Cited by

No blog we hold has cited this post yet.

Links from this post

Link
Host
https://onlinejournalismblog.com/wp-content/uploads/2015/06/excel-for-journalists-book.png
onlinejournalismblog.com
https://leanpub.com/spreadsheetstories/
leanpub.com
https://www.bbc.co.uk/news/uk-england-38340015
bbc.co.uk
https://stackoverflow.com/questions/22542834/how-to-use-regular-expressions-regex-in-microsoft-excel-both-in-cell-and-loops
stackoverflow.com
https://support.microsoft.com/en-us/office/split-text-into-different-columns-with-the-convert-text-to-columns-wizard-30b14928-5550-41f5-97ca-7a3e9c363ed7
support.microsoft.com
https://support.google.com/docs/answer/3098244?hl=en-GB
support.google.com
https://support.google.com/docs/answer/3098292
support.google.com
https://support.google.com/docs/answer/3098245
support.google.com
https://onlinejournalismblog.com/wp-content/uploads/2021/06/regexrscreenshot.png
onlinejournalismblog.com
New helper added: RegExr – Learn, build, & test Regular Expressions. Read at the source ↗
regexr.com
https://twitter.com/bbcelection
twitter.com
https://onlinejournalismblog.com/wp-content/uploads/2021/06/bbcelectiontweets.png
onlinejournalismblog.com
https://docs.google.com/spreadsheets/d/e/2PACX-1vSGthRci_vLp_GoQDtV2PuvCIxgrgqwhuA1e5md-lrWAEkSWADxYxTPeWqbcxDdj8W5rxOkPGhwimcg/pub?gid=482820707&single=true&output=csv
docs.google.com
https://t.co/CkDxxFFbDa&
t.co
https://onlinejournalismblog.com/wp-content/uploads/2021/06/regexmatchscreenshot1.png
onlinejournalismblog.com
https://t.co/ewVXioRbVo&
t.co
https://t.co/onDZ6ff3K0&
t.co
https://en.wikipedia.org/wiki/Title_case
en.wikipedia.org
https://t.co/&
t.co
https://t.co&
t.co&
https://onlinejournalismblog.com/wp-content/uploads/2021/06/regexextractscreenshot1.png
onlinejournalismblog.com
https://onlinejournalismblog.com/wp-content/uploads/2021/06/regexextractscreenshot2.png
onlinejournalismblog.com
https://t.co/kFyHWZXvuJ&
t.co
https://exceljet.net/excel-functions/excel-trim-function
exceljet.net
https://onlinejournalismblog.com/wp-content/uploads/2021/06/regexextractscreenshot3.png
onlinejournalismblog.com
https://onlinejournalismblog.com/wp-content/uploads/2021/06/regexextractscreenshot4.png
onlinejournalismblog.com
https://onlinejournalismblog.com/wp-content/uploads/2021/06/regexextractscreenshot5.png
onlinejournalismblog.com
https://onlinejournalismblog.com/wp-content/uploads/2021/06/regexextractscreenshot6.png
onlinejournalismblog.com
https://onlinejournalismblog.com/wp-content/uploads/2021/06/regexextractscreenshot7.png
onlinejournalismblog.com
https://onlinejournalismblog.com/wp-content/uploads/2021/06/regexextractscreenshotwildcard.png
onlinejournalismblog.com
https://onlinejournalismblog.com/wp-content/uploads/2021/06/regexextractscreenshotwildcard2.png
onlinejournalismblog.com
https://onlinejournalismblog.com/wp-content/uploads/2021/06/regexextractscreenshotcaret.png
onlinejournalismblog.com
https://www.regular-expressions.info/characters.html
regular-expressions.info
https://leanpub.com/scrapingforjournalists
leanpub.com
https://docs.google.com/spreadsheets/d/e/2PACX-1vSGthRci_vLp_GoQDtV2PuvCIxgrgqwhuA1e5md-lrWAEkSWADxYxTPeWqbcxDdj8W5rxOkPGhwimcg/pub?output=xlsx
docs.google.com
https://t.co/tFoMAGcFsq
t.co
https://t.co/XhpPKd29Lq
t.co
https://t.co/WQ2Cp80wKX
t.co
https://t.co/qE0yxz5TWL
t.co
https://github.com/BBC-Data-Unit/art-uk
github.com