Program Functions, Database

Notion Guide: How To Extract Characters From A Title

Sarah Brennan ·

Screen Shot 2021-01-18 at 2.51.31 PM.png

🪓 Extract Characters

If you are importing a large file into Notion, there may be a scenario where bulk extraction of certain characters is necessary. The following list of are different ways to modify a title using regular expressions in a Notion formula. The function used primarily is replaceAll.

What You Need In Your Notion Database:

  • A title property filled out (labeled “Name”)

  • A formula property to plug in one of these formulas

Extract All Number Sequences

Screen Shot 2021-01-18 at 1.43.18 PM.png

replaceAll(prop("Name"), "([^0-9]+)([^0-9]+)", "")

Extract All Text Sequences

Screen Shot 2021-01-18 at 1.47.00 PM.png

replaceAll(prop("Name"), "([^A-z]+)([^A-z]+)", "")

Extract All Characters After A Special Character

Screen Shot 2021-01-18 at 12.22.09 PM.png

replaceAll(prop("Name"), ".*[:] ", "")

Extract All Characters Before A Special Character

Screen Shot 2021-01-18 at 2.17.37 PM.png

replaceAll(prop("Name"), "[:].+", "")

Extract Last Word In A String

Screen Shot 2021-01-18 at 1.00.46 PM.png

replaceAll(prop("Name"), ".*[^A-z]", "")

Extract First Word In A String

Screen Shot 2021-01-18 at 1.20.01 PM.png

replaceAll(prop("Name"), "[^A-z].+", "")

Extract All Characters Between Two Characters

Screen Shot 2021-01-18 at 2.41.50 PM.png

replaceAll(replace(prop("Name"), "[^(]*[(]", ""), "[)][^)]*$", "")

Extra: How To Replace Title With Formula Column

Copy + Paste the formula column into the Title by clicking any cell and clicking away from the formula popup window. Then click from the top cell and drag down to the bottom.

Untitled_Artwork 40.png

This is a set of basic formulas that may help you import complicated data into Notion easily. All the best with your workspace endeavours.

 

Further Reading

Featured
Free Notion Template: One-Click Recurring Checklists

How to create a one-click checklist using Notion. This includes a free template that can be used for personal or professional tasks. The recurring checklist is designed to simplify the process of adding checklists and completing projects, allowing you to focus on what needs to be done rather than spending time recreating repetitive to-do lists.

11 Ways to Generate Clickable Links with Notion Formulas

Notion formulas can now be used to create clickable links that make constructing and navigating URL links a breeze. Creating clickable links in Notion formulas only requires inputting the correct code that results in a url syntax (https://www.website.com/…). Below are instructions on how to generate clickable links in Notion formulas for maps, social media searches, Twitter profiles, Wikipedia, Goodreads, and Amazon.

Notion For Note-Taking: Where To Start

There are many reasons why Notion is a great note-taking app. For starters, it's extremely user-friendly and easy to use. The interface is clean and simple, making it quick and easy to find what you're looking for. There are also tons of features and customization options available, so you can tailor the app to your specific needs. Here is how you can get started.

How To Connect Zotero To Notion With Notero

Utilize the immensely useful Notero integration with Notion to save and organize citations and web clippings from the Zotero browser extension and app. In this short tutorial, I show you how to get started with Notero in 2022, and where to add integrations in Notion. Here’s how it works.