Alteryx Designer Discussions

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

Trimming fields

HannahSwain7
6 - Meteoroid

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
16 - Nebula

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