Trim or Regex Functionality help

[Jhattarki]

I am trying to use the Regex to achive only the first part of the  name -Williuamsin, Reanie from the below string.

Williuamsin, Reanie;#1355;#Barrie, Kuerra

please can someone help me.

Thank you

[echuong1 · Accepted solution]

You can achieve this easily using the text to columns tool and a ";" as a delimiter. 

See attached.

[TSP]

If you'd like to use Regex, you could use Regex Parse with the following expression:

([^;]*)(.*)

This will give you two fields: 

1) Everything upto the first ; which is what you want

2) Everthing else. You can then drop this field in a select too.

Hope that helps.

[Jhattarki]

Awesome- this worked like charm-appriciate your help.

Thank you!!

[echuong1]

Great! If this resolved your issue, please mark this thread as solved so others can find answers more easily. Thanks!