SUBPLUS() Returns multiple substrings STRPULL() Extract text between 2 characters TAKEOUT() Extract a portion of a string between delimiters at nth occurrance CRUNCH() Moves spaces in a string to end of string ADDSPACE() Pads right of string with spaces ARRANGE() Rearranges text in a string CENTR() Centers a string in x spaces _WILDCARD() Wild Card String Compare ALLBUT() Returns all but last x characters STRETCH() Imbeds characters in a string LJUST() Left justifies a string STARTSW() Determines if a string starts with another string VAR2CHAR() Converts any type variable to character type RJUST() Right justifies a string PROPER() Capitalizes first letters of string, lowers rest
Tag Archives: VAR2CHAR()
SP_VARLEN
VARLEN() Short: ------ VARLEN() Returns length of a variable of any type Returns: -------- <nLength> => Length of variable Syntax: ------- Varlength(expX) Description: ------------ Converts expX to character with VAR2CHAR() and then returns its length Examples: --------- VARLEN(123.45) //returns 6 VARLEN(.F.) //returns 3 VARLEN(DATE()) //returns 8 Source: ------- S_VARLEN.PRG
SP_VAR2CHAR
VAR2CHAR() Short: ------ VAR2CHAR() Converts any type variable to character type Returns: -------- <cCharVal> => value as character Syntax: ------- Var2char(expX) Description: ------------ Converts variable in <expX> to type character Examples: --------- dtype := ctod("01/01/80") ntype := 128.45 ltype := .t. VAR2CHAR(dtype) // returns "01/01/80" VAR2CHAR(ntype) // returns "128.45" VAR2CHAR(ltype) //returns ".t." Warnings: ---------- Numerics will be returned with a length of 10 minimum You may wish to trim this. Notes: ------- Returns memo types as "" PREVIOUSLY ACCEPTED THE 'NAME' OF THE VARIABLE. NOW THE VALUE IS PASSED IN DIRECTLY. Source: ------- S_VAR2.PRG