.png?table=block&id=62487db0-e07f-4ecb-ae75-49d8c492d53e&cache=v2)
Donate
DonateExtract All Number SequencesExtract All Text SequencesExtract All Characters After A Special CharacterExtract All Characters Before A Special CharacterExtract Last Word In A StringExtract First Word In A StringExtract All Text Between Two Characters
If you are importing a large file into Notion, there may be a scenario where bulk removal of certain characters is necessary.
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
Media
replaceAll(prop("Name"), "[^A-z].+", "")
Extract All Text Between Two Characters
Media
replaceAll(replace(prop("Name"), "[^(]*[(]", ""), "[)][^)]*$", "")