.TEXT UPPER TO LOWER

This subroutine converts upper case to lower case in a text/alpha field.

Usage:

      PASS         <converted_text>           FIELD            SHARE? Y
      PASS         <original_text>            FIELD            SHARE? N
      PASS         <convert_flag>             FIELD            SHARE? N
      PASS         <len_original_text>        FIELD            SHARE? N
      GOSUB    --- .TEXT UPPER TO LOWER
      *        Check for errors
      IF       --- .TEXT UPPER TO LOWER       NE

Description:

This subroutine converts upper case to lower case in a text/alpha field. The first 2 parameters are required. If any required parameters are missing, the subroutine will CANCEL.

<converted_field> returns the converted <original_text> (Required). This must be PASSed with Share "Y" to return the value.

<original_text> is are the characters you want converted (Required).

<convert_flag> controls how the characters will be converted (Optional). If PASSed, it must be one of:

• All - convert every character to lower case.
• Firstword - leave the first character of the first word upper case, convert the rest.
• Allwords - leave the first character of the every word upper case, convert the rest.

<len_original_text> Optional - Release 6.0 + higher only. This is a optional performance enhancement to reduce the time required to perform the case conversion. You can PASS the maximum length you expect in <original_text>. For example, if your <original_text> field is 1M in size, but you know the data will never be longer than 22 characters, you can pass 22 in this field. If you PASS this field and your data is longer, it will be truncated to this length.

If you don't care about conserving the original data, you can pass the same field for both <converted_field> and <original_text>.

Also see .TEXT LOWER TO UPPER.

Note: This subroutine is designed to operate on Alpha, Text, and Token fields only. The returned results are undefined if you specify any other type of field.

Comments:

Read what other users have said about this page or add your own comments.

-- JeanNeron - 2012-02-09