Case Sensitive Replace()

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
ub3rl337ch3ch Members Profile Find Members Posts Senior Member Joined: 16 February 2005 Location: Australia Status: Offline Points: 341	Post Options Post Reply Quote ub3rl337ch3ch Report Post Thanks(0) Quote Reply Topic: Case Sensitive Replace() Posted: 10 July 2005 at 11:59pm
	Is the replace function case sensitive? will this work? replace("the dOg","dog","cat") or will it only work if it is exact?

Gullanian Members Profile Find Members Posts Senior Member Joined: 04 January 2002 Location: England Status: Offline Points: 4373	Post Options Post Reply Quote Gullanian Report Post Thanks(0) Quote Reply Posted: 11 July 2005 at 2:32am
	I think it's not case sensitive, and theres an extra optional parameter that can be added on to change this. Best way to see is to test it!

dpyers Members Profile Find Members Posts Senior Member Joined: 12 May 2003 Status: Offline Points: 3937	Post Options Post Reply Quote dpyers Report Post Thanks(0) Quote Reply Posted: 11 July 2005 at 11:10am
	It is case sensitive. Try using either regular expressions or perhaps something like replace(Lcase("the dOg"), "dog", "cat")
	Lead me not into temptation... I know the short cut, follow me.

ub3rl337ch3ch Members Profile Find Members Posts Senior Member Joined: 16 February 2005 Location: Australia Status: Offline Points: 341	Post Options Post Reply Quote ub3rl337ch3ch Report Post Thanks(0) Quote Reply Posted: 17 July 2005 at 7:10pm
	i worked it out... one of the optional parameters determines either binary compare of textual compare. One of them makes it case sensitive the other doesn't...

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.