This short Notion tutorial will teach you how to use the Slice function in regards to pulling and isolating valuable text from a string. The example I use here is isolating twitter handles from the "@" symbol. This can also be useful for extracting text form email names.
Let's begin with the Slice function:
SLICE → Extracts a substring from a string from the start index (inclusively) to the end index (optional and exclusively).
- Syntax →
slice(text, number, number)
Twitter Handles
Handle
Return Name
Let's take this one step further and generate twitter links with the handles.
These links are not clickable. However, if table is exported to CSV, links are clickable.
Twitter Handles → Links
Handle
Return Twitter Link