Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Community Discussions (All other subjects)
 Software to turn capital letters into lowercase?		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

MarkJH
Senior Member

United Kingdom
1722 Posts
Posted - 29 January 2004 :  18:13:24  Show Profile  Visit MarkJH's Homepage
I need some software which will convert all capital letters in a document into lowercase. Does anybody know if something like this is available?
Bandlink.net - http://www.bandlink.net/
Bandlink Music Forums - http://www.bandlink.net/forum/

MarkJH
Senior Member

United Kingdom
1722 Posts
Posted - 29 January 2004 :  18:20:47  Show Profile  Visit MarkJH's Homepage
Typical. As soon as I ask for help, I find the answer. ZHeCK's Case Converter seems to do the trick beautifully.
Bandlink.net - http://www.bandlink.net/
Bandlink Music Forums - http://www.bandlink.net/forum/
Go to Top of Page

dayve
Forum Moderator

USA
5820 Posts
Posted - 29 January 2004 :  18:28:47  Show Profile  Visit dayve's Homepage
Most word processors can do this. It can also be easily accomplished in JavaScript and VBScript.
Go to Top of Page

dayve
Forum Moderator

USA
5820 Posts
Posted - 29 January 2004 :  18:34:35  Show Profile  Visit dayve's Homepage
I knew I did this before for someone:

http://www.burningsoulsforum.com/topic.asp?TOPIC_ID=7432

and here is the code:


<html>
<body>
<form>
<textarea name="convertText" cols="70" rows="12"></textarea>
<br>
<input type="button" value="UPPERCASE" onclick="this.form.convertedText.value = this.form.convertText.value.toUpperCase()">
<input type="button" value="lowercase" onclick="this.form.convertedText.value = this.form.convertText.value.toLowerCase()">
<input type="button" value="Original"  onclick="this.form.convertedText.value = this.form.convertText.value">
<br>
<textarea name="convertedText" cols="70" rows="12"></textarea>
</form>
</body>
</html>
Go to Top of Page

MarkJH
Senior Member

United Kingdom
1722 Posts
Posted - 29 January 2004 :  19:03:46  Show Profile  Visit MarkJH's Homepage
Didn't realise that MS Word did that...

The software mentioned above does the job perfectly and it means that I can use Notepad, which is absolutely ideal for the (offline) project I'm undertaking.

Very handy piece of code, though. Thanks.
Bandlink.net - http://www.bandlink.net/
Bandlink Music Forums - http://www.bandlink.net/forum/
Go to Top of Page

laser
Advanced Member

Australia
3859 Posts
Posted - 30 January 2004 :  02:11:38  Show Profile
MarkJH, if you think Notepad is good, have a look at UltraEdit - you'll NEVER use Notepad again
Go to Top of Page

MarkJH
Senior Member

United Kingdom
1722 Posts
Posted - 03 February 2004 :  18:09:30  Show Profile  Visit MarkJH's Homepage
Just curious...

Is there a SQL query way of doing this for MS Access?
Bandlink.net - http://www.bandlink.net/
Bandlink Music Forums - http://www.bandlink.net/forum/
Go to Top of Page

dayve
Forum Moderator

USA
5820 Posts
Posted - 05 February 2004 :  10:22:31  Show Profile  Visit dayve's Homepage
quote:
Originally posted by MarkJH

Just curious...

Is there a SQL query way of doing this for MS Access?


Yes, you can do this in MS Access:

SELECT lcase(fldName1), lcase(fldName2) from tblName
Go to Top of Page

MarkJH
Senior Member

United Kingdom
1722 Posts
Posted - 05 February 2004 :  13:11:08  Show Profile  Visit MarkJH's Homepage
Dayve, THANKYOU!
Bandlink.net - http://www.bandlink.net/
Bandlink Music Forums - http://www.bandlink.net/forum/
Go to Top of Page

dayve
Forum Moderator

USA
5820 Posts
Posted - 06 February 2004 :  10:20:13  Show Profile  Visit dayve's Homepage
quote:
Originally posted by MarkJH

Dayve, THANKYOU!

no problem, but do keep in mind that this is an unconventional SQL statement. It may not work with other database types.
Go to Top of Page

MarkJH
Senior Member

United Kingdom
1722 Posts
Posted - 06 February 2004 :  11:30:38  Show Profile  Visit MarkJH's Homepage
quote:
It may not work with other database types.
Not a problem. The database is offline and only used to create a datafeed, so I won't be upgrading it.
Bandlink.net - http://www.bandlink.net/
Bandlink Music Forums - http://www.bandlink.net/forum/
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.4 seconds. Powered By: Snitz Forums 2000 Version 3.4.07