Login     Register

        Contact Us     Search

XLeratorDB/strings Online Documentation

Home


XLeratorDB/strings

Use XLeratorDB/strings for a wide variety of string processing and text manipulations. The feature-rich XLeratorDB function library lets you include calculations 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 - STRING FUNCTIONS
FORMATTING
CLEAN Clean non-printable characters text
CONCAT Concatenate two text strings with an optional joiner
CRLF Returns the ascii carriage return-line feed
DEC2FRAC Returns a text representation of a decimal converted to a fraction
DOLLAR Converts a number to text with a currency format
FIXED Formats a number as text with a fixed number of decimals
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
INDENT Indents a text string (incl. multi-line) to a specified number of levels with a specified indentation character
JOINSTR Returns the concatenation of columnar data from a table or view
JOINSTR_q Returns the concatenation of columnar data from a query
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.
PROPER Capitalizes the first letter of each word in a text string
QUOTED Returns text surrounded with a double quote character
QUOTES Returns text surrounded with a single quote character
SPLIT Splits a string into one or more rows by a single or multi-character delimeter
STRIP Strips all punctuation from the beginning and end of 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)
   
INSPECTION
CONTAINSSTR Returns whether a text string contains another text string
COUNTSTRING Returns the number of occurences of one string within another
ENDSWITH Returns whether a text string ends with another text string
EXACT Returns whether two strings are equal
FIND Finds one text value within another
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
NUMWORDS Returns the number of items delimeted by one or more separators
STARTSWITH Returns whether a text string starts with another text string
   
CALENDAR
NETWORKDAYS Returns the number of working days (non weekend or holiday) between two dates
NETWORKDAYS_q Returns the number of working days (non weekend or holiday) between two dates
WORKDAY Calculates a work day (non weekend or holiday) from a start date and offset
WORKDAY_q Calculates a work day (non weekend or holiday) from a start date and offset
   
LOGIC
IIFSTR Returns one of two strings depending on a boolean condition
   
   
VERSION INFORMATION / MISC
XLDB_STRINGS_VERSION Function Version Information
   
Gettysburg Address Sample data


 |  View Topic History  |
Copyright 2008-2013 WestClinTech LLC         Privacy Policy        Terms of Service