UDF: Parse a delimited list of paramters

Total article views: 69 | Views in the last 30 days: 3

 Rate this |   Join the discussion |  Briefcase

After replying to a post today I thought I'd share this with all.

This is a user defined function that I use to return a table of parameters passed in a parameter string.

Function Usage
Select * From dbo.fnParseParamString ([@ParamString='Delimited String of parmaters'],[@Delimeter='Delimiting Character'])

Lets say you are concatenating a list of form data from a web page where you take the user's First Name, Last Name and email address.

your concatenated string looks like this: John,Doe,jdoe@company.com

Once you've installed the userdefined function you can execute this:

select * from dbo.fnParseParamString('John,Doe,jdoe@company.com',',')

this returns

iRowId vcParameters
----------- --------------------
1 John
2 Doe
3 jdoe@company.com

(3 row(s) affected)

now, since you know Parameter 1 is the first name, and parameter 2 is the last name and parameter 3 is the email address you can do something like this:

select vcParameter from dbo.fnParseParamString('John,Doe,jdoe@company.com',',') where iRowId = 3

which returns the email address portion of the parameter string

vcParameters
--------------------
jdoe@company.com

(1 row(s) affected)

Total article views: 69 | Views in the last 30 days: 3