SP String Functions

 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

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