Regex Help NeedeD?

[FaNIX]

Hi, I need some help with a regular expression.

I have a CSV file with a column that holds the Contact Person Name & Tellephone Number (in one Column). I need to split these into two seperate values. The Field String can be in 2 formats ex: "ContactPersonName (000) 123 4567" or "ContactPersonName 0001234567".

Can someone please help me with a Regex to split this string into 2? it should split on the first occurance of "(" or the first occurange of a number.

Thanks