When you get data in sentences: how to use a spreadsheet to extract numbers from phrases (Online Journalism Blog)

Online Journalism Blog: When you get data in sentences: how to use a spreadsheet to extract numbers from phrases. “We needed to be able to take a collection of words such as ’11 years and 5 months’ imprisonment’ and convert that into something that could be used in spreadsheet calculations (specifically, comparing the lengths of time represented by two different phrases). It’s a problem you come across every so often as a journalist — especially with FOI requests — so in this post — taken from the book Finding Stories in Spreadsheets — I’ll explain how to do that.”

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.