Wednesday, March 10, 2010 Register
Home

XLeratorDB/strings

Use XLeratorDB/strings for a wide variety of string manipulations. The feature-rich XLeratorDB strings function library lets you include text manipulations in any T-SQL statement including SELECT, INSERT, UPDATE, DELETE, CREATE VIEW as well as in CTEs, stored procedures, user-defined functions, and computed columns.

XLeratorDB/strings requires Microsoft  SQL Server®  2005 or later (which must be purchased separately). XLeratorDB/strings installs in minutes and can be used immediately after installation. Anyone familiar with the functions in Microsoft Excel® will immediately feel comfortable with XLeratorDB/strings.

Function Reference - Excel String Functions
CLEAN clean non-printable characters text
CONCAT concatenate two text strings with an optional joiner
DOLLAR converts a number to text with a currency format
EXACT returns whether two strings are equal
FIND finds one text value within another
FIXED formats a number as text with a fixed number of decimals
PROPER capitalizes the first letter of each word in a text string
SUBSTITUTE replaces specified instances of text in a text string
TEXT formats a number according to excel format styles
TRIM trims leading and trailing spaces from a text string
VALUE converts text to a number (float)

 

Function Reference - Additional String Functions
CONTAINSSTR returns whether a text string contains another text string
COUNTSTRING returns the number of occurences of one string within another
CRLF returns the ascii carriage return-line feed
DEC2FRAC returns a text representation of a decimal converted to a fraction
ENDSWITH returns whether a text string ends with another text string
FORMATDATE formats a date according to Microsoft DOTNET formatting standards
FORMATNUM formats a number according to Microsoft DOTNET formatting standards
FRAC2DEC inverse of DEC2FRAC, converts a text representation of a fraction to a decimal number
IIFSTR returns one of two strings depending on a boolean condition
INDENT indents a text string to a specified number of levels with a specified indentation character. works with multi-line text.
INSTR returns the first character position of one text string within another
INSTRREV returns the character position of the last instance of one text string within another.
ISALPHA returns whether a text string contains only alphabetic characters
ISNUMERIC returns whether a text string represents a number
JOINSTR returns the concatenation of columnar data from a table or view
JOINSTR_q returns the concatenation of columnar data from a query
NUMWORDS returns the number of items delimeted by one or more separators
PADLEFT pads text to a specified width using a padding cahracter to the left of the original text
PADRIGHT pads text to a specified width using a padding cahracter to the right of the original text
PARSE returns the requested instance of an item delimited by one or more separators
PCT2FRAC converts a given percentage value to a text representation of a fraction.
QUOTED returns text surrounded with a double quote character
QUOTES returns text surrounded with a single quote character
STARTSWITH returns whether a text string starts with another text string
STRIP strips all punctuation from the beginning and end of a text string

 

Function Reference - Version Information
XLDB_STRINGS_VERSION Function Version Information

Gettysburg Address


 |  View Topic History  |
Privacy StatementTerms Of UseCopyright 2010 WestClinTech LLC

BorderBoxedGrayBoxedGreenBlue Small width layoutMedium width layoutMaximum width layoutMaximum textMedium textSmall textBack Top!