Who's On?

	Membership:
	Latest: Jeffin Joy
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 4988

	People Online:
	Visitors: 32
	Members: 0
	Total: 32

Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chris Martin	825

replacement in variables

2 Replies

0 Subscribed to this topic

53 Subscribed to this forum

Sort:

Author

Messages

TommyT

Veteran Member

Posts: 58

4/19/2011 4:22 PM

I need to strip a variable of certain characters (& / \ etc). I'm using the replace method like this

wname=qryPL.replace("&","")
wname=wname.replace("',"")
wname=wname.replace("/","")

The only replacement that works is whichever character I place in the first_ line. Once I'm acting on the variable wname it doesnt work. I can change the characters to be replaced around and only the one in the first line works.

Is there something different I need when acting on the vairiable?

John Henley

Posts: 3366

New Poster

Engaged Reader

Avid Reader

4/19/2011 4:50 PM

Did you try ?
wname=qryPL.replace("&","").replace("',"").replace("/","")

TommyT

Veteran Member

Posts: 58

4/19/2011 7:42 PM

Worked great. Thanks!