Parse record, convert to session variables

[Brandon]

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_c ode"), 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 Howard]

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.V alue)

Next

- or are you asking how to split a single string??
"Brandon" <bdreilingATmac .com> wrote in message
news:%2******** ********@TK2MSF TNGP10.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_c ode"), 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 Anderson]

Alan Howard wrote:

For Each objField In objRS.Fields

Session (CStr(objField. Name)) = CStr(objField.V alue)

Next

CStr is unnecessary with [Name]...
http://msdn.microsoft.com/library/en.../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 Schupp]

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:%2******** ********@TK2MSF TNGP10.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_c ode"), 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 Howard]

> 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" <GT**********@s pammotel.com> wrote in message
news:Oh******** *****@TK2MSFTNG P12.phx.gbl... Alan Howard wrote:

For Each objField In objRS.Fields

Session (CStr(objField. Name)) = CStr(objField.V alue)

Next
CStr is unnecessary with [Name]...
http://msdn.microsoft.com/library/en.../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.

[Brandon]

Thanks, that did the trick!

Brandon
_______________ _______________ ___________

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

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