Template:AskPlus E.8.5.0

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.