posted on Tuesday, February 15, 2005 1:46 PM by amachanic

New UDF - Pattern-based split string

I just posted a new UDF in the library. This one is a modification of the split string UDF previously posted, but takes a pattern for the delimiter instead of a single character. This was written to handle requests such as, "how do I find all the distinct words in a text column?"

The UDF can be found here.

Comments

# re: New UDF - Pattern-based split string @ Thursday, August 25, 2005 1:02 PM

Hi
I would want the code asap for a procedure which takes a string as an argument and returns or is split into array and each element of the array will store value like
a(1)=Bill
a(2)=+
a(3)=Mill
a(4)=-
and so on
simlar to pattern matching if you have it email me at bprakash_9999@yahoo.com
I require it immediately

Thanks
Bhanu Prakash

Bhanu Prakash