Donate

<aside> 📘 If you are importing a large file into Notion, there may be a scenario where bulk removal of certain characters is necessary.

</aside>

Remove test

Extract All Number Sequences

• Media

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

Extract All Text Sequences

• Media

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

Extract All Characters After A Special Character

• Media

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

Extract All Characters Before A Special Character

• Media

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

Extract Last Word In A String

• Media

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

Extract First Word In A String