Remove Characters From User Input

[vanillapod]

Hi, can anyone give me a link / show me how to strip user input of symbols / certain characters in a function?

I'ver got a form (called form1) and a field called 'comments'. The user clicks a submit button and the page saves the input to a database, but I want to remove any ' & @ etc symbols.

Cheers

 

[newmediaguy]

Hi there are a few good posts about this already on here.

The simplest way is to:

str = 'hello@youdomain.com&?'
str = Replace(str,"@")
str = Replace(str,"&")
str = Replace(str,"?")

Although you could place this logic in to a function or even use the regExp object etc..

Hope this helps

Thanks

Glen
Conception | Execution

 

[vanillapod]

will give that a go... cheers for the response newmediaguy

 

[ChrisHirst]

Using a regular expression is the quickest way. Or you can chain replace() functions

function StripChars(strIn)
' function to remove characters from a string
' add chars into the pattern to add more
	dim objRE

	set objRE = New RegExp
	objRE.Pattern = "[&@]"
	objRE.Global = True
	StripChars = objRE.replace(strIn, "")
	set objRE = nothing
end function


Chris.

Indifference will be the downfall of mankind, but who cares?
[URL unfurl="true"]www.candsdesign.co.uk[/URL] A website that proves the cobblers kids adage.
[URL unfurl="true"]www.cram-system.com[/URL] Nightclub counting systems

So long, and thanks for all the fish.

 

[ChrisHirst]

must remember to use preview before submit

Chris.

Indifference will be the downfall of mankind, but who cares?

http://www.candsdesign.co.uk

A website that proves the cobblers kids adage.

http://www.cram-system.com

Nightclub counting systems

So long, and thanks for all the fish.

 

[newmediaguy]

lol

weve all done it



Glen
Conception | Execution

 

[vanillapod]

have gone for the function and it works a treat thanks for the replies...