RE: How do we convert lowercase letters to uppercase in Pick basi c
OCONV(whatever,MCU) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 12:11 PM To: [EMAIL PROTECTED] Subject: How do we convert lowercase letters to uppercase in Pick basic Hi, Can some one tell me how to convert lower case letters to uppercaseand vise versa tx in advance for the help regards reddy -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: How do we convert lowercase letters to uppercase in Pick basi c
tx for the help regards reddy Jeff Schasny [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 04/22/2004 03:12 PM Please respond to U2 Users Discussion List [EMAIL PROTECTED] To U2 Users Discussion List [EMAIL PROTECTED] cc Subject RE: How do we convert lowercase letters to uppercase in Pick basi c OCONV(whatever,MCU) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 12:11 PM To: [EMAIL PROTECTED] Subject: How do we convert lowercase letters to uppercase in Pick basic Hi, Can some one tell me how to convert lower case letters to uppercaseand vise versa tx in advance for the help regards reddy -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: How do we convert lowercase letters to uppercase in Pick basi c
Another nice one is OCONV(Variable,MCT). If initial value of Variable is TEST, result will be Test. (First letter cap, subsequent letters lower case.) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gordon Glorfield Sent: Thursday, April 22, 2004 2:14 PM To: 'U2 Users Discussion List' Subject: RE: How do we convert lowercase letters to uppercase in Pick basi c UPCASE(Variable) or OCONV(Variable,'MCU') DOWNCASE(Variable) or OCONV(Variable,'MCL') Gordon J. Glorfield Sr. Applications Developer MAMSI (A UnitedHealth Company) 301-360-8839 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, April 22, 2004 3:11 PM To: [EMAIL PROTECTED] Subject: How do we convert lowercase letters to uppercase in Pick basic Hi, Can some one tell me how to convert lower case letters to uppercaseand vise versa tx in advance for the help regards reddy -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: How do we convert lowercase letters to uppercase in Pick basi c
Only downsides to these OCONV's is that McDonalds and O'Henry lose the 2nd capitalized letter. The only true way to manage would be to have a BEGIN CASE situation to look for MC or O' at the beginning and handle that way. Plus maintain a list of unprogrammable exceptions. I have a music database program that needs this, especially the exception list like LeAnn Rimes, DJ Freddie, USA etc. Also, the exception list could force certain words to not capitalize. The exception list's primary key is the Uppercase version of the word and 1 is the true form. mY 1 cEnT - Original Message - From: [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Thursday, April 22, 2004 3:17 PM Subject: RE: How do we convert lowercase letters to uppercase in Pick basi c tx for the help regards reddy Jeff Schasny [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 04/22/2004 03:12 PM Please respond to U2 Users Discussion List [EMAIL PROTECTED] To U2 Users Discussion List [EMAIL PROTECTED] cc Subject RE: How do we convert lowercase letters to uppercase in Pick basi c OCONV(whatever,MCU) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 12:11 PM To: [EMAIL PROTECTED] Subject: How do we convert lowercase letters to uppercase in Pick basic Hi, Can some one tell me how to convert lower case letters to uppercaseand vise versa tx in advance for the help regards reddy -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: How do we convert lowercase letters to uppercase in Pick basi c
Easier is: VAR='lowercase' VAR = upcase(VAR) CRT VAR LOWERCASE Reverse command: VAR='UPPERCASE' VAR = downcase(VAR) CRT VAR uppercase Karl On Thu, 2004-04-22 at 13:17, [EMAIL PROTECTED] wrote: tx for the help regards reddy Jeff Schasny [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 04/22/2004 03:12 PM Please respond to U2 Users Discussion List [EMAIL PROTECTED] To U2 Users Discussion List [EMAIL PROTECTED] cc Subject RE: How do we convert lowercase letters to uppercase in Pick basi c OCONV(whatever,MCU) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 12:11 PM To: [EMAIL PROTECTED] Subject: How do we convert lowercase letters to uppercase in Pick basic Hi, Can some one tell me how to convert lower case letters to uppercaseand vise versa tx in advance for the help regards reddy -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- Karl L. Pearson Director of IT, ATS Industrial Supply Direct: 801-978-4429 Toll-free: 888-972-3182 x29 Fax: 801-972-3888 http://www.atsindustrial.com [EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users