| Description |
Use the MID( ) function to extract a portion of a string. Using this function is similar to using a substring, except that it can be used directly with the return value of a function, variable or expression; e.g.,
->IF MID(MSE,22,1)>$00$ AND MID(MSE,22,1)<$FF$ THEN %WDX$="[WDX]" In addition, if the offset is negative, ProvideX uses it as an offset from the end of the string. For example, MID(X$,-1) is the last character of X$. If the length is negative, then ProvideX uses it as the number of characters preceding the offset. That is, MID("ABCD",-1,-1) returns C (the first character preceding the last character) and MID("abcde",-2,-4) yields abc.
By default, if this function is passed an invalid offset, it returns a null string. If passed an invalid length, then it returns the rest of the string.
|