SOLVED
Regex Expression
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Bryth
8 - Asteroid
‎05-16-2023
01:53 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello Team,
I want a regex Expression that will take only the first name in this attached text and the initial ( First letter to the second name) of the name in the text. Can you help me with this please
Solved! Go to Solution.
Labels:
4 REPLIES 4
binuacs
21 - Polaris
‎05-16-2023
01:59 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
flying008
15 - Aurora
‎05-16-2023
05:12 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
apathetichell
19 - Altair
‎05-16-2023
06:46 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
do you want them in the same field - if so - use something similar to @binuacs suggestion like:
regex_replace([Trainee],"^(\w+\s\w).*","$1")
RobertOdera
13 - Pulsar
‎05-17-2023
12:15 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi, @Bryth
Yes, to REGEX, but also you can do the below.
I hope that you find it helpful - Cheers!
1. Add a Formula Tool
2. First part is given by the formula GetWord(TRIM([Field]),0)
3. Second part is given by the formula LEFT(GetWord(TRIM([Field]),1),1)
![](/skins/images/28E38E9B5983E0F349B9ACC30B823311/responsive_peak/images/icon_anonymous_message.png)