Regular expression to get all words in a string starting with xyz

Database
Enthusiast

Regular expression to get all words in a string starting with xyz

Hi All, 

 

Is there any regular expression  in teradata to get all words in a string starting with xyz and ending with space. 

 

Thanks

Abhishek

Tags (1)
1 REPLY
Enthusiast

Re: Regular expression to get all words in a string starting with xyz

Due to the general nature of this question and not knowing your data or purpose, I can only offer a general answer. Have you tried looking into the STRTOK function and/or the STRTOK_SPLIT_TO_TABLE function? Either of those may help you in accomplishing what you are trying to do.

 

STRTOK reference

STRTOK_SPLIT_TO_TABLE reference