Read on Twitter
Quick @bubble tip:
Using Regex to display a full name as a 1st name, 2nd name and initials without database entries.
Keeps your database lean with only one name field needed and useful to manipulating any text field
Using Regex to display a full name as a 1st name, 2nd name and initials without database entries.
Keeps your database lean with only one name field needed and useful to manipulating any text field
To display the first name, pull the database Full Name and extract with Regex, using the Regex pattern: ([^\\s]+).
For 1st name, use the qualifier ‘first item’.
For 2nd name, use the qualifier ‘last item’.
![To display the first name, pull the database Full Name and extract with Regex, using the Regex pattern: ([^\\s]+). For 1st name, use the qualifier ‘first item’. For 2nd name, use the qualifier ‘last item’.](https://pbs.twimg.com/media/Esrn72DXYAI55lT.png "To display the first name, pull the database Full Name and extract with Regex, using the Regex pattern: ([^\\s]+). For 1st name, use the qualifier ‘first item’. For 2nd name, use the qualifier ‘last item’.")
For 1st name, use the qualifier ‘first item’.
For 2nd name, use the qualifier ‘last item’.
To convert either the first or last names into initials, add ‘truncated to:’ at the end of the expression and set 1 as the number of characters you want.
I’ve also manually added a full stop for style at the end of the expression.
I’ve also manually added a full stop for style at the end of the expression.
All courtesy of the @bubble forum 
