Parse record, convert to session variables

Greetings,

I have a database with records that contain data like the following:

"vendor" - "phone number" - "city", "state" "problem."

For example:
xyzcompany - 800-123-4567 - new york, ny tp.

The line above is one record, the company names will differ (but are
limited to a dozen), the format of the number will always be with a dash
seperating the area code and number, the city and state will be in
place, and the problem will be a two letter code followed by a period.

I need to be able to parse that record into seperate session variables
such as Session("vendor"), Session("area_code"), Session("number"), and
on with the city, state, and problem.

What is the best method to use in VBScript/ASP to break this record down
into pieces?

I appreciate any help you can give.

Thanks,
Brandon


*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

Alan
Tue Jun 08 20:44:28 CDT 2004

You say the data below is a record - assuming that you are still able to
address the individual fields, use something like:

For Each objField In objRS.Fields

Session (CStr(objField.Name)) = CStr(objField.Value)

Next

- or are you asking how to split a single string??


"Brandon" <bdreilingATmac.com> wrote in message
news:%23038rsbTEHA.2324@TK2MSFTNGP10.phx.gbl...
> Greetings,
>
> I have a database with records that contain data like the following:
>
> "vendor" - "phone number" - "city", "state" "problem."
>
> For example:
> xyzcompany - 800-123-4567 - new york, ny tp.
>
> The line above is one record, the company names will differ (but are
> limited to a dozen), the format of the number will always be with a dash
> seperating the area code and number, the city and state will be in
> place, and the problem will be a two letter code followed by a period.
>
> I need to be able to parse that record into seperate session variables
> such as Session("vendor"), Session("area_code"), Session("number"), and
> on with the city, state, and problem.
>
> What is the best method to use in VBScript/ASP to break this record down
> into pieces?
>
> I appreciate any help you can give.
>
> Thanks,
> Brandon
>
>
> *** Sent via Devdex http://www.devdex.com ***
> Don't just participate in USENET...get rewarded for it!

Dave
Wed Jun 09 10:02:21 CDT 2004

Alan Howard wrote:
>
> For Each objField In objRS.Fields
>
> Session (CStr(objField.Name)) = CStr(objField.Value)
>
> Next

CStr is unnecessary with [Name]...
http://msdn.microsoft.com/library/en-us/ado270/htm/mdproname.asp


...and possibly unwanted with [Value], depending on the data type.



--
Dave Anderson

Unsolicited commercial email will be read at a cost of $500 per message. Use
of this email address implies consent to these terms. Please do not contact
me directly or ask me to contact you directly for assistance. If your
question is worth asking, it's worth posting.

Mark
Wed Jun 09 12:12:13 CDT 2004

If your format and delimiters are fixed (unchanging) then

a1 = split( strRecord, ",")
a2 = split( a1(0), "-")
a3 = split( a1(1), " ")

vendor = a2(0)
areacode = a2(1)
phonenum = a2(2) & "-" a2(3)
city = a2(4)
state = a3(0)
prob = a3(1)


--
Mark Schupp
Head of Development
Integrity eLearning
www.ielearning.com


"Brandon" <bdreilingATmac.com> wrote in message
news:%23038rsbTEHA.2324@TK2MSFTNGP10.phx.gbl...
> Greetings,
>
> I have a database with records that contain data like the following:
>
> "vendor" - "phone number" - "city", "state" "problem."
>
> For example:
> xyzcompany - 800-123-4567 - new york, ny tp.
>
> The line above is one record, the company names will differ (but are
> limited to a dozen), the format of the number will always be with a dash
> seperating the area code and number, the city and state will be in
> place, and the problem will be a two letter code followed by a period.
>
> I need to be able to parse that record into seperate session variables
> such as Session("vendor"), Session("area_code"), Session("number"), and
> on with the city, state, and problem.
>
> What is the best method to use in VBScript/ASP to break this record down
> into pieces?
>
> I appreciate any help you can give.
>
> Thanks,
> Brandon
>
>
> *** Sent via Devdex http://www.devdex.com ***
> Don't just participate in USENET...get rewarded for it!

Alan
Wed Jun 09 14:52:46 CDT 2004

> CStr is unnecessary with [Name]...
> ...and possibly unwanted with [Value], depending on the data type.

Habit - easier than second-guessing variant sub-types.

Alan

"Dave Anderson" <GTSPXOESSGOQ@spammotel.com> wrote in message
news:OhC8JLjTEHA.904@TK2MSFTNGP12.phx.gbl...
> Alan Howard wrote:
> >
> > For Each objField In objRS.Fields
> >
> > Session (CStr(objField.Name)) = CStr(objField.Value)
> >
> > Next
>
> CStr is unnecessary with [Name]...
> http://msdn.microsoft.com/library/en-us/ado270/htm/mdproname.asp
>
>
> ...and possibly unwanted with [Value], depending on the data type.
>
>
>
> --
> Dave Anderson
>
> Unsolicited commercial email will be read at a cost of $500 per message.
Use
> of this email address implies consent to these terms. Please do not
contact
> me directly or ask me to contact you directly for assistance. If your
> question is worth asking, it's worth posting.
>
>