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: ALLBUT()
SP_ALLBUT
ALLBUT() Short: ------ ALLBUT() Returns all but last x characters Returns: -------- <cAllBut> => All but last n characters Syntax: ------- ALLBUT(cInString,nAllBut) Description: ------------ Returns all but the rightmost <nAllbutt> letters of <cInString> Examples: --------- string := "SUPERFUNCTION" string := ALLBUT(string,8) // => returns "SUPER" Notes: ------- Useful when you don't know the length of a string in order to take left(x) characters. Source: ------- S_ALLBUT.PRG