Extract Data Until a Specific String

[insomned]

Hello, I have a column of data in which I need to extract everything until either "." or ",". For instance,

Name 

Tony Hotels, Resort

Mada Hotels - Apartments

For this I would need 

Name Extract

Tony Hotels,

Mada Hotels 

as the end goal.

Could anyone help?

Thanks a million!

[ShankerV]

Hi @insomned 

One way of doing this.

[insomned]

Thanks!

[insomned]

Apologies, what if I needed the data until the very first punctuation mark? Mainly "," or "-". Thanks!

[ShankerV]

Hi @insomned 

Please find the expected, 

Many thanks

Shanker V

[binu_acs]

@insomned One way of doing this with the Regex Tokenize method