[RBASE-L] - RE: Formatting in a report

[Javier Valencia]

You can also use LUC which will convert the entire string to upper case. SET VAR vtxt = (ULC(‘john doe”)) Will result in “JOHN DOE” regardless of length.   Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln., Suite #14 Olathe, KS  66062-4571 (913)829-0888 (913)649-2904 FAX   -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jim Van Dillen Sent: Wednesday, February 12, 2003 7:43 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Formatting in a report   Thanks Javier.   You're on the right track.  I need change a whole field on the report to CAPS, regardless of length and regardless of whether the field is a column or a variable.   JIM VAN DILLEN   -------Original Message-------   From: [EMAIL PROTECTED] Date: Wednesday, February 12, 2003 18:40:31 To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Formatting in a report   On your report use the functions ICAP1 and ICAP2 to create variables   ICAP1 changes the fist letter to upper case: SET VAR vtxt = (ICAP1(‘john doe’) Will result in “John doe”   ICAP2 changes the fist letter of each word to upper case SET VAR vtxt = (ICAP2(‘john doe’) Will result in “John Doe”   I hope this is what you are looking for… Javier,   Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln., Suite #14 Olathe, KS  66062-4571 (913)829-0888 (913)649-2904 FAX   -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jim Van Dillen Sent: Wednesday, February 12, 2003 6:26 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Formatting in a report   I have been developing forms to create court documents which extract data from a table.  The suggestions of members of this group have been most helpful.   I have the reports basically running and producing usable documents at this time but I need to apply some custom formatting to "Plaintiffs" name and "Defendants'" name in the forms.  I need to capitalize the names in the memos.  I know how to do this in a form but have been unsuccessful in doing same in a report.   The Plaintiff's name field in the report is an actual column in the associated table.  The Defendant's name field is a variable.   Part of the problem is that the Format command speaks of making the "____" the same number of characters as the text in the field.  Obviously, with a number of different Plaintiffs and a great many different Defendants, there is no way I would know this length ahead of time.   I know this has to be fairly simple but I have been unable to get this work in the report to this point.  Any help would be greatly appreciated.   Thanks,     JIM VAN DILLEN Attorney at Law 1505 S. Big Bend Blvd. St. Louis, MO. 63117 (314) 645-8008; Fax (314) 645-8016 [EMAIL PROTECTED]