Mastering Crystal Reports 9 [Electronic resources] نسخه متنی

اینجــــا یک کتابخانه دیجیتالی است

با بیش از 100000 منبع الکترونیکی رایگان به زبان فارسی ، عربی و انگلیسی

Mastering Crystal Reports 9 [Electronic resources] - نسخه متنی

Cate McCoyand, Gord Maric

| نمايش فراداده ، افزودن یک نقد و بررسی
افزودن به کتابخانه شخصی
ارسال به دوستان
جستجو در متن کتاب
بیشتر
تنظیمات قلم

فونت

اندازه قلم

+ - پیش فرض

حالت نمایش

روز نیمروز شب
جستجو در لغت نامه
بیشتر
لیست موضوعات
توضیحات
افزودن یادداشت جدید






String Functions

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.

/ 217