• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part: V Appendices > Text Functions

Text Functions

These functions operate on text (text expressions, fields containing text, or text literal strings). See the following section, “Text Formatting Functions,” for functions that change the appearance of text (text styles).

Table B.10. Text Functions
FunctionResult
Exact (originalText; comparisonText)Number. 1 if the strings are identical except for styling such as font); 0 otherwise.
Filter (textToFilter; filterText)Text. Characters in filterText are retained in textToFilter. Case matters; style does not. Use to easily drop spaces, -, or () from phone numbers.
FilterValues (textToFilter; filterValues)Similar to Filter, but filterValues contains text strings separated by carriage returns rather than individual characters to filter.
GetAsCSS (text)Text. The text returned is the Cascading Style Sheet description of the font an style.
GetAsDate (text)Date
GetAsNumber (text)Number
GetAsSVG (text)Text. The text returned is the Scalable Vector Graphics description of the font and style.
GetAsText (data)Text. If the parameter is a container field, the text may be the path to the file.
GetAsTime (text)Time
GetAsTimestamp (text)Timestamp
Left (text; numberOfCharacters)Text
LeftValues (text; numberOfValues)Text. Values are separated by carriage returns.
LeftWords (text, numberOfWords)Text. Words are separated by spaces, &, or -.
Length (field)Number
Lower (text)Text
Middle (text; start; numberOfCharacters)Text
MiddleValues (text, startingValue; numberOfValues)Text. Values are separated by carriage returns.
MiddleWords (text, startingWord; numberOfWords)Text. Words are separated by spaces, &, or -.
PatternCount (text; searchString)Number
Position (text; searchString; start; occurrence)Number
Proper (text)Text
Replace (text; start; numberOfCharacters; replacementText)Text
Right (text; numberOfCharacters)Text
RightValues (text; numberOfValues)Text. Values are separated by carriage returns.
RightWords (text; numberOfWords)Text. Words are separated by spaces, &, or -.
SerialIncrement (text; incrementBy)Text
Substitute (text; searchString replaceString)Text
Trim (text)Text
TrimAll (text, trimSpaces; trimType)Text. Use for removing spaces in text that mixes Roman and non-Roman characters.
Upper (text)Text
ValueCount (text)Number. Values are separated by carriage returns.
WordCount (text)Number. Words are separated by spaces, &, or -.
Hiragana (text)Text
KanaHankaku (text)Text
KanaZenkaku (text)Text
KanjiNumeral (text)Text
Katakana (text)Text
NumToJText (number; separator characterType)Text
RomanHankaku (text)Text
RomanZenkaku (text)Text



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint