String Manipulation Before Posting to a Database

[Steve G]

Hi All:

I am having difficulty with manipulating data coming from a form which is
then posted to a database. The from contains a mixture of check boxes, and a
text box for "other" with a default value of NA, all of which have the same
name value of specialty.

When I complete the form, and send it to a page to post to the database, a
response.write for the form field delivers a comma delimited list of
"items", which is what I expected, such as:
Allergy and Immunology, Anesthesiology, NA

If the text box is filled in then I would get:
Allergy and Immunology, Anesthesiology, Test

When the text field is NA, I want to eliminate it from the text string, so I
end up with:
Allergy and Immunology, Anesthesiology
Before splitting on the comma, and posting to the database.

I can get rid of the NA doing this:
strTemp = request.form("specialty")
strTemp1 = replace(strTemp,"NA"," ")

This yields:
Allergy and Immunology, Anesthesiology,

Note the trailing comma..if I leave it in, I get an extra blank record in
the database...but I cannot figure out how to get rid of it.

Any help would be greatly appreciated.

Steve G

[Bob Barrows]

Steve G wrote:

> Hi All:
>
> I am having difficulty with manipulating data coming from a form
> which is then posted to a database. The from contains a mixture of
> check boxes, and a text box for "other" with a default value of NA,
> all of which have the same name value of specialty.
>
> When I complete the form, and send it to a page to post to the
> database, a response.write for the form field delivers a comma
> delimited list of "items", which is what I expected, such as:
> Allergy and Immunology, Anesthesiology, NA
>
> If the text box is filled in then I would get:
> Allergy and Immunology, Anesthesiology, Test
>
> When the text field is NA, I want to eliminate it from the text
> string, so I end up with:
> Allergy and Immunology, Anesthesiology
> Before splitting on the comma, and posting to the database.
>
> I can get rid of the NA doing this:
> strTemp = request.form("specialty")
> strTemp1 = replace(strTemp,"NA"," ")
>
> This yields:
> Allergy and Immunology, Anesthesiology,
>
> Note the trailing comma..if I leave it in, I get an extra blank
> record in the database...but I cannot figure out how to get rid of it.

How about:
strTemp1 = replace(strTemp,", NA","")

Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Steve G]

Great <S>
Thanks Bob...I must have tried 20 variations on that theme, but just could
not get it right.

Steve G

"Bob Barrows" <reb01501@NOyahoo.SPAMcom> wrote in message
news:O2Md3x62DHA.1672@TK2MSFTNGP12.phx.gbl...

> Steve G wrote:

> > Hi All:
> >
> > I am having difficulty with manipulating data coming from a form
> > which is then posted to a database. The from contains a mixture of
> > check boxes, and a text box for "other" with a default value of NA,
> > all of which have the same name value of specialty.
> >
> > When I complete the form, and send it to a page to post to the
> > database, a response.write for the form field delivers a comma
> > delimited list of "items", which is what I expected, such as:
> > Allergy and Immunology, Anesthesiology, NA
> >
> > If the text box is filled in then I would get:
> > Allergy and Immunology, Anesthesiology, Test
> >
> > When the text field is NA, I want to eliminate it from the text
> > string, so I end up with:
> > Allergy and Immunology, Anesthesiology
> > Before splitting on the comma, and posting to the database.
> >
> > I can get rid of the NA doing this:
> > strTemp = request.form("specialty")
> > strTemp1 = replace(strTemp,"NA"," ")
> >
> > This yields:
> > Allergy and Immunology, Anesthesiology,
> >
> > Note the trailing comma..if I leave it in, I get an extra blank
> > record in the database...but I cannot figure out how to get rid of it.

>
> How about:
> strTemp1 = replace(strTemp,", NA","")
>
> Bob Barrows
> --
> Microsoft MVP -- ASP/ASP.NET
> Please reply to the newsgroup. The email account listed in my From
> header is my spam trap, so I don't check it very often. You will get a
> quicker response by posting to the newsgroup.
>
>