Group Char / String Functions
Alltrim()
Removing leading and trailing blank spaces from a character string.
Alltrim( <cString> ) --> cTrimmedString
At()
Determines first position of a substring within a character string.
At( <cSubString>, <cString> [,<nStartPos>] ) --> nPosition
HardCR()
Replaces soft returns in a character string with hard returns.
HardCR( <cString> ) --> cString
IsAlpha()
Tests whether a character string begins with a letter.
IsAlpha( <cString> ) --> lBoolean
IsDigit()
Tests whether a character string begins with a digit.
IsDigit( <cString> ) --> lDigit
IsLower()
Tests whether a character string begins with a lower case letter.
IsLower( <cString> ) --> lLowerCase
IsUpper()
Tests whether a character string begins with an upper case letter.
IsUpper( <cString> ) --> lUpperCase
Left()
Extracts part of a character string starting with the first character.
Left( <cString>, <nCount> ) --> cSubString
Len()
Determines the length of a character string or an array.
Len( <cString> | <aArray> ) --> nCount
Like()
Determines if a character expression matches another character expression.
Like( <cSkeletonExpr>, <cExpression> ) --> lMatch
Lower()
Converts upper case letters in a character string into lower case letters.
Lower( <cString> ) --> cLowerCase
LTrim()
Removes blank spaces at the beginning of a character string.
LTrim( <cString> ) --> cTrimString
Mem2Str()
Create a character string from a memory address.
Mem2Str( <nAddress> [, <nLen>] [, @<cMem>] ) --> cMem
MemoLine()
Extracts text lines from a character string or from a memo field.
MemoLine( <cString>, [<nLineLen>], [<nLine>], [<nTabSize>], [<lWrap>] ) --> cLine
MemoTran()
Replaces hard and soft returns in a character string or memo field.
MemoTran( <cString>, [<cNewHardCR>], [<cNewSoftCR>] ) --> cNewString
MlCount()
Determines the number of lines in a character string or memo field.
MlCount( <cString>, [<nLineLen>], [<nTabSize>], [<lWrap>] ) --> nLineCount
MlCtoPos()
Determines the position of a character in a formatted character string.
MlCtoPos( <cString>, <nLineLen>, <nRow>, <nCol>, [<nTabSize>], [<lWrap>] ) --> nPosition
MlPos()
Determines starting position of the specified line in a formatted character string.
MlPos( <cString>, <nLineLen>, <nRow>, [<nTabSize>], [<lWrap>] ) --> nPosition
MPostoLc()
Determines the row and column position from a character position.
MPostoLc( <cString>, <nLineLen>, <nPosition>, [<nTabSize>], [<lWrap>] ) --> aRowCol
PadC() | PadL() | PadR()
Pads a character string, date or numeric value with fill characters
PadL( <Expression>, <nLen>, [<cFillChr>] ) --> cString PadC( <Expression>, <nLen>, [<cFillChr>] ) --> cString PadR( <Expression>, <nLen>, [<cFillChr>] ) --> cString
RAt()
Determines the position of last occurrence of a substring within a character string.
RAt( <cSeek>, <cString>, [<nStartPos>] ) --> nPosition
Replicate()
Replicates a character string a specified number of times.
Replicate( <cString>, <nCount> )--> cReplicate
Right()
Extracts part of a character string starting from the end (right).
Right( <cString>, <nCount> ) --> cSubString
RTrim()
Deletes blank spaces at the end of a character string.
RTrim( <cString> ) --> cTrimString Trim( <cString> ) --> cTrimString
SetLexRule()
Defines or returns lexical rules for the comparison of one or more characters.
SetLexRule( <aLexRule> ) --> aOldRule or SetLexRule( [<aMultipleRules>] ) --> aCollationTable
Space()
Creates a character string consisting only of blank spaces.
Space( <nCount> ) --> cSpaces
StrTran()
Replaces characters in a character string or memo field.
StrTran( <cString>, <cSeek>, [<cReplace>], [<nStart>], [<nCount>] ) --> cNewString
StrZero()
Converts a numeric value to a character string with leading zeros.
StrZero( <nValue>, [<nLength>], [<nDecimals>] ) --> cString
Stuff()
Inserts and/or deletes characters in a character string.
Stuff(<cString>, <nStart>, <nDelete>, <cInsert>) --> cNewString
SubStr()
Extracts a string from a character string.
SubStr( <cString>, <nStart>, [<nCount>]) --> cSubString
Trim()
Deletes blank spaces at the end of a character string.
Trim( <cString> ) --> cTrimString RTrim( <cString> ) --> cTrimString
Upper()
Converts lower case letters in a character string to upper case.
Upper( <cString> ) --> cUpperCase
Val()
Converts a number in the form of a character string to a numeric value.
Val( <cNumber> ) --> nNumber