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

Online Journalism Blog: What are regular expressions — and how to use them in Google Sheets to get data from text . “In an extract from a new chapter in the ebook Finding Stories in Spreadsheets, I explain what regular expressions are — and how they can be used to extract information from spreadsheets. The ebook version of this tutorial includes a dataset and exercise to employ these techniques.”

The Conversation: How to consume news while maintaining your sanity

The Conversation: How to consume news while maintaining your sanity. “The amount and variety of news produced today often tests people’s ability to determine its value and veracity. Such a torrent of information threatens to drown news consumers in a river of confusion…. But techniques exist for ferreting out what we can trust and what we should question, and there are steps we can take to help determine where the news comes from.”

Organizing the Books in Your Home, Part 1: How to Shelve Like a Librarian (Library Journal)

Library Journal: Organizing the Books in Your Home, Part 1: How to Shelve Like a Librarian . “The following is the first of a multipart weekly series designed to help readers make the most of their home collections. This week, we look at the traditional Dewey Decimal Classification system and how it might work for you. Future installments will tackle the pros and cons of ‘genrefying’ fiction (separating distinct genres like romance, horror, sf/fantasy, etc.); how to ‘weed’ your collection, including when to throw away or recycle outdated information; and how to best organize books for young children.”

Vogue: 8 Brilliant Queer Photographers To Follow On Instagram

Vogue: 8 Brilliant Queer Photographers To Follow On Instagram. “As we once again take to the streets (Covid-19 restrictions permitting) for this year’s Pride celebrations to honour our LGBTQIA+ siblings, eight queer photographers share their hopes for the future, from the funding of trans healthcare to the building of new physical safe spaces.” Some of the images in the article would probably be considered NSFW.

Data Horde: How to recover your Yahoo! Groups from the Internet Archive

Data Horde: How to recover your Yahoo! Groups from the Internet Archive. “Yahoo! Groups, once upon a time a hub to many online communities, was shut down in 2020. Yahoo! Groups used to host mailing lists going as far back as 1997, and perhaps you may have once been a part of it yourself. Users were offered a Get Your Data tool to download their messages and other data, prior to the shutdown, but many people were unable to respond on short notice. Thankfully, owing to the efforts of the Save Yahoo Groups Project and Archive Team the data of many groups has been preserved. If you missed out on the GYD tool, you might still be able to retrieve your groups’ data by following the steps below.”

Screen Rant: How To Create A Group Fundraiser On Instagram

Screen Rant: How To Create A Group Fundraiser On Instagram. “Instagram has introduced the functionality for groups of users to run Group Fundraisers together on its platform. It was already possible for an individual to run a fundraising campaign on Instagram, but the new feature will make it easier for friends and family members to raise money for a cause.”

MakeUseOf: How to Maximize Your Views on Instagram Reels

MakeUseOf: How to Maximize Your Views on Instagram Reels. “If you’d like to grow your Instagram account, creating and sharing Reels is a great way to connect with your audience. This feature offers short, digestible content that could build reach on the Explore page. Here are eight tips that you can use to improve the reach and performance of your Instagram Reels.”

Make Tech Easier: A Guide to Emulation with RetroPie

Make Tech Easier: A Guide to Emulation with RetroPie. “Emulating video game systems and computers is one of the things that the Raspberry Pi has always been good at, right from the start. You can do this with your own Raspberry Pi using RetroPie emulators. RetroPie is easily one of the best all-in-one plug-in-play retro gaming solutions. Even with systems that don’t work flawlessly, it’s not too difficult to tweak them to work right.”

MakeUseOf: How to Use Facebook’s Transparency Center to Understand the Social Network Better

MakeUseOf: How to Use Facebook’s Transparency Center to Understand the Social Network Better. “Facebook wants to be clearer about its policies to help you better understand the app, and has launched a new resource to help in this respect. Facebook’s Transparency Center is a one-stop shop for anyone looking to understand how the platform deals with all manners of things. This article will help you navigate the Transparency Center so you can understand the social media network better.”

ZDNet: This app teaches you how to make your iPhone secure

ZDNet: This app teaches you how to make your iPhone secure. “First and foremost, iVerify is a security scanner that makes sure you are making use of the basic security features such as Face/Touch ID, Screen Lock, and are running the latest iOS version. It also runs a device scan that looks for security anomalies and gives you a heads up if something seems out of place.” Not free, but the price is only $2.99.

Creative Bloq: How to use green screen on TikTok

Creative Bloq: How to use green screen on TikTok. “Want to know how to use green screen on TikTok? We’ve got it covered. Virtual backgrounds have become popular across social media and the micro-video platform TikTok is no exception. In this guide, we’ll walk you through how to add a virtual background to your micro-videos for all kinds of creative uses on the popular social media platform.”

Mashable: Want to skywatch for Starlink satellites? There’s a website that will help you.

Mashable: Want to skywatch for Starlink satellites? There’s a website that will help you.. “There isn’t a constellation quite like the image a line of Starlink satellites cuts across Earth’s skies. And now there’s an easy way to figure out when you can see them. The SpaceX-operated gear is meant to one day provide high speed, satellite-powered internet all around the world. It’s already semi-functional and open for live testing (at quite a cost), but the eventual orbital network, which is already approved by the FCC, will consist of 12,000 satellites in all.”