String Functions

book list add book to my bookshelf create a bookmark purchase this book online

mastering crystal reports 9
Appendix E - Crystal Reports Built-in Functions
Mastering Crystal Reports 9
by Cate McCoy and Gord Maric
Sybex 2003

String data is character or textual data. It is common to parse or manipulate text values for presentation purposes in a report. The built-in string functions provide many formatting options.

Asc Returns the ASCII code for the first character in a given string.

AscW Returns the Unicode value for the first character in a given string.

Chr Returns a character given an ASCII code.

ChrW Returns a Unicode character given an ASCII code.

Filter Searches an array for a given value.

InStr Searches a string for a given value.

InStrRev Searches a string for a given value by starting at the last character in the string and searching down to the first.

Join Converts a list of multiple elements to a single string containing all the element values.

Left Returns the leftmost characters in a given string for the number of characters specified.

Length When Basic Syntax is used, Len(x) is also acceptable usage.

LowerCase Converts a value to lowercase.

Mid Extracts part of a string based on a starting position in the string and a given number of characters to extract.

NumericText Returns True if the content of a text string is a valid number.

ProperCase (string) Returns a string with initial capitalization on each word.

Replace Returns a string that has had values replaced based on a pattern passed to this function.

ReplicateString Make a specified number of copies of a text string.

Right Returns the rightmost characters in a given string for the number of characters specified.

Roman Returns a Roman numeral corresponding to an integer value.

Space Returns a specified number of blank spaces.

Split Converts the words in a string into a list of multiple elements.

StrCmp Compares two strings to one another.

StrReverse Reverses the characters in a string.

ToNumber Converts a given value to a double value.

ToText Converts a given value to a text string; the following example truncates a number to 0 decimals and then converts it to a text string:

ToText({Table.Field},00,"")

ToWords Converts a number to a text string with an opportunity to handle decimal conversion.

Trim Removes leading and trailing blanks from a string.

TrimLeft Removes blanks at the beginning of a string (leading) from the string.

TrimRight Removes blanks at the end of a string (trailing) from the string.

UpperCase Converts a value to uppercase.

Val Extracts a numeric value from the text string in which it is embedded.

Use of content on this site is expressly subject to the restrictions set forth in the Membership Agreement
 
Conello © 2000-2003     Feedback


Mastering Crystal Reports 9
Mastering Crystal Reports 9
ISBN: 0782141730
EAN: 2147483647
Year: 2005
Pages: 217

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net