Tags:
create new tag
view all tags

.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.
If not PASSed, the default value is All.

<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.

Comments:

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


-- JeanNeron - 2012-02-09

Edit | Attach | Watch | Print version | History: r3 < r2 < r1 | Backlinks | Raw View | Raw edit | More topic actions
Topic revision: r3 - 2018-01-03 - JeanNeron
 
This site is powered by the TWiki collaboration platform Powered by PerlCopyright © 2008-2019 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback