Free Trial

Alteryx Designer Desktop Discussions

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

Trimming fields

HannahSwain7
7 - Meteor

Hi,

 

I need to format some fields to remove everything before and including the “> “. Can anyone please advise? 

example below:

illness > GB sickness

company > MY - Unpaid personal leave

paid > paid other leave

family > IE - parents leave

 

many thanks 

1 REPLY 1
DataNath
17 - Castor
17 - Castor

Hey @HannahSwain7, I'd use RegEx in this case, how does something like this look? It just parses out everything after '> '

 

>\s(.+)

 

DataNath_0-1660144368004.png

Labels
Top Solution Authors