SOLCASE TIPS - FEBRUARY 2007

Upper case lower case and sentence case

Converting from Upper to Lower case does not always work - why? You can convert a temporary field into Upper Case by using the modifier CAPS. eg [&Assign TF01=TF01:CAPS] or to lower case by using LC eg [&Assign TF01=TF01:LC]. However it DOES NOT WORK on your user-defined or system fields so the command [&Assign ABC01=ABC01:CAPS] is ineffective. (Of course you can force the contents of a field to always be Uppercase using the tick box in the field definition - recommended for items like postcode fields). The reason it does not work on user-defined fields is that Solcase is not case sensitive and therefore does not think the field has changed so ignores the amendment. The work round is to add a character, make the assignment and remove it again (see below).

If you import new matters from data supplied by introducers you may sometimes, annoying, get all the data in capital letters (uppercase). Fortunately, converting names and addresses from uppercase is now quite simple using the char and word modifiers (see below)

SAMPLE CODE

To convert a use- definable field called ABC01 to upper case (for lowercase substitute LC for CAPS) :

[&Assign TF01=ABC01]
[&Assign TF01=" " + TF01:CAPS]
[&Assign ABC01=TF01]
[&Assign ABC01==ABC01:LTRIM(" ")]
[&Assign TF01=""]

You could also use L-REMOVE in place of LTRIM and/or use a character like @ instead of a space.

 

To convert a UPPER CASE Name or Address (ABC01) to words with Initial capitals use:

[&Assign TF01=0]
[&Assign TF02=ABC01]
[&Assign TF03=""]
[&Assign TF04=""]
[&Assign TF05=""]
[&Assign TF06=""]
[&Dowhile TF02 <> ""]
   [&Assign TF01 = TF01 + 1]
   [&Assign TF03= TF02:word(first=1,number=1):LC]
   [&Assign TF04= TF03:char(first=1,number=1):CAPS]
   [&Assign TF05 = TF03:char(first=2,number=500)]
   [&Assign TF02 = TF02:word(first=2,number=500)]
   [&Assign TF06 = TF06 + TF04 + TF05 + " "]
[&Enddowhile]
[&Assign ABC01=" " + TF06]
[&Assign ABC01=ABC01:LTRIM(" ")]