In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Extract Job Title Only

jatienza
8 - Asteroid
‎12-19-2022 01:31 PM

Hi Team,

 

Need help in extracting job title only. Sample data are shown below:

 

Senior Software Engineer | kburston@shoe.com

Business Consultant at market.com

Chief Executive Officer/CEO, Tunnels Co

Director Business Marketing Development at Housing Inc, www.housing.com

Technical Software Officer (www.technician.com)

 

Output should be as shown below:

Senior Software Engineer

Business Consultant

Chief Executive Officer/CEO

Director Business Marketing Development

Technical Software Officer

 

Thanks,

Jaime

Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

2 REPLIES 2
Felipe_Ribeir0
16 - Nebula
‎12-19-2022 01:36 PM

Hi @jatienza 

 

One way of doing this

 

Felipe_Ribeir0_0-1671485795593.png

 

Extract Job Title Only.yxmd
Reply
jatienza
8 - Asteroid
‎12-19-2022 01:42 PM

Hi @Felipe_Ribeir0

 

Awesome! Thank you for your help.

Reply
Alteryx One Admin Experience
Labels
Top Solution Authors
View All