Regex tool Alteryx

[learn79]

Hi everyone, 

I am new to Alteryx so this is my first time using Regex. 

This is how my text looks like ex: VGONTA : Sti Finance Reporting.

I would like to remove the description and to only show me  this part "VGONTA"

Much appreciated in advance. 

[mpennington]

Assuming it is always followed by a space and semicolon, this should do the trick.  

REGEX_Replace([String], '(.*)\s\:.*', '$1')

[Qiu]

@learn79 
Another option is to use the Text to Column Tool.

[AkimasaKajitani]

Hui @learn79 

If you are not used to Alteryx or RegEx yet, I recommend to use RegEx tool because the RegEx tool will assist you.

In this case, you can achieve this by leaving the part that meets your requirements, and the RegEx tool will support you with the following interface.

[EN6924]

You can achieve that using Regex - Replace

[learn79]

Thanks a lot to you and everyone who helped. It worked. 

[learn79]

This one worked. Thank you so much