In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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

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

2 REPLIES 2
Felipe_Ribeir0
16 - Nebula

Hi @jatienza 

 

One way of doing this

 

Felipe_Ribeir0_0-1671485795593.png

 

jatienza
8 - Asteroid

Hi @Felipe_Ribeir0

 

Awesome! Thank you for your help.

Labels
Top Solution Authors