Ben SmithBen Smith
Ben Smith/
Isolate Names
Isolate Names
Isolate Names

Isolate Names

For
RedditMoleo
From
Reddit
Status
Updating
Formulas
if
if
replace
replace
test
test
Share

First Name

replace(prop("Full Name"), " .*", "")

Last Name v1

Gets the name after the last space.
replace(prop("Full Name"), " .*", "")

Last Name v2

Gets all names after the first space.
replace(replace(prop("Full Name"), " \"(.*?)\"", ""), "^(.*?) ", "")

Nickname

if(test(prop("Full Name"), "[\"]|[\"]"), replace(replace(prop("Full Name"), "[^\"]*[\"]", ""), "[\"](.*)", ""), "")
 
By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!
By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!