Difference between revisions of "Template:AskPlus E.8.5.0"

From Vital Soft Wiki
Jump to: navigation, search
>Johno
>Johno
 
Line 7: Line 7:
 
::: If step is negative, the concatenation will happen in reverse order (and start s/b gt end)
 
::: If step is negative, the concatenation will happen in reverse order (and start s/b gt end)
 
::: By default, the concatenated values are trimmed.  Opt can be "notrim", "ltrim" or "rtrim"
 
::: By default, the concatenated values are trimmed.  Opt can be "notrim", "ltrim" or "rtrim"
 +
::* !strposrev(str1, str2) - Search for str2 in str1 looking for the last match (starting in reverse)
 +
  
 
:* New user exit examples:
 
:* New user exit examples:
Line 17: Line 19:
 
   newreg x:10I1 = !index(@)
 
   newreg x:10I1 = !index(@)
 
   !concat(x, "7,,-2|\|") returns "7|5|3|1"
 
   !concat(x, "7,,-2|\|") returns "7|5|3|1"
 +
 +
  !strpos("abcabcabc", "bc") will return 2 (first match)
 +
  !strposrev("abcabcabc", "bc") will return 8 (last match)
 +
 +
:* New System Variable (Special Object): $MILTIME
 +
::Display current time in 24 hour military time.
 +
 +
:* Enhancement to "Assign Macro" command to erase current content:
 +
  ASSIGN macrofile filename[, erase]
  
 
'''Fixes:'''
 
'''Fixes:'''
  
 +
:* Fix a bug in !getval when reading a tab delimited file and the first value was missing in the record (the first tab was incorrectly skipped).
 
:* Eliminate a possible overflow using !compress.
 
:* Eliminate a possible overflow using !compress.
 
:* Fix a bug using sub-item syntax that extends over an array.
 
:* Fix a bug using sub-item syntax that extends over an array.
 +
:* Fix a bug sorting on a variable length character expression.
 +
:* Fix a bug when a mask containing no 9 digits was considered as a Date edit mask.

Latest revision as of 23:27, 16 July 2019

Enhancements:

  • Add new user exits:
  •  !mod(x, y) - Returns the remainder when x is divided by y
  •  !countval(str [, delim]) - Returns the number of values in the string delimited by the delim parm (default delim is comma)
  •  !concat(array [,start,end,step|delim|opt]) - Returns a delimited string with concatenated array elements
If step is negative, the concatenation will happen in reverse order (and start s/b gt end)
By default, the concatenated values are trimmed. Opt can be "notrim", "ltrim" or "rtrim"
  •  !strposrev(str1, str2) - Search for str2 in str1 looking for the last match (starting in reverse)


  • New user exit examples:
 !mod(17, 3) returns 2
 !mod(15, 4) returns 3
 !countval("abc;def;ghi", ";") will return 3
 !countval("abc,def,ghi,jkl") will return 4
 newreg x:10I1 = !index(@)
 !concat(x, "7,,-2|\|") returns "7|5|3|1"
 !strpos("abcabcabc", "bc") will return 2 (first match)
 !strposrev("abcabcabc", "bc") will return 8 (last match)
  • New System Variable (Special Object): $MILTIME
Display current time in 24 hour military time.
  • Enhancement to "Assign Macro" command to erase current content:
 ASSIGN macrofile filename[, erase]

Fixes:

  • Fix a bug in !getval when reading a tab delimited file and the first value was missing in the record (the first tab was incorrectly skipped).
  • Eliminate a possible overflow using !compress.
  • Fix a bug using sub-item syntax that extends over an array.
  • Fix a bug sorting on a variable length character expression.
  • Fix a bug when a mask containing no 9 digits was considered as a Date edit mask.