Login     Register

        Contact Us     Search

XLeratorDB/strings

  XLeratorDB lets you realize the full power of SQL Server with in-database processing. Invoke dozens of standard string formatting and text manipulation functions within the database – without having to export data to another application, without having to use Reporting Services, and without having to write complicated T-SQL statements or stored procedures.

If you know T-SQL and have used Excel, you will find these familiar functions so easy to use that you could be getting results within minutes after installing them. Simplify your SQL Server reporting requirements and improve the speed of complex file processing with the powerful new functions found in XLeratorDB/strings .

XLeratorDB/strings Documentation

XLeratorDB/strings includes over 40 SQL CLR functions for:

  • Formatting – CONCAT, PARSE, TEXT, SPLIT, etc.
  • Information – COUNTSTRING, FIND, ISALPHA, etc.
  • Calendarizations – NETWORKDAYS, WORKDAYS,etc.
  • Conditional formatting - IIFSTR

XLeratorDB/strings adds many new tools (that are precisely matched to Excel) to the 23 native functions built into SQL Server. Plus, there are dozens of new functions for the kind of demanding database operations that are simply beyond the scope/scale of a spreadsheet application.

Now you can use easy and familiar text handling funtions similar to those found both in Excel and the Microsoft .NET framework directly in your T-SQL. XLeratorDB strings offers powerful and fast text manipulation functions - PARSE specific elements out of text strings, CONCATenate many rows of text data into a single line, SPLIT data by delimiters into rows quickly and efficiently. 

XLeratorDB/strings also offers a rich set of formatting functions that are much more flexible and easier to use than the built in SQL Server functions.  Format numbers, dates, times, currencies, etc. with easy and familiar patterns such as 'mm/dd/yyyy' and '###,###.00' instead of memorizing cryptic numeric codes.

On top of this, there are also functions for inspecting text strings, such as ISNUMERIC, NUMWORDS, STARTSWITH, CONTAINSSTR and more - PLUS - calendar functions for calculating working days.

XLeratorDB gives you the familiarity and flexibility of Excel with the power and reliability of in-database analytics – without the headaches of cut-and-paste errors. And in many instances eliminating exports and imports to Excel can mean up to a 99% reduction in processing times as well.

 

Testimonials

"This is a very data processing intensive system that would not be possible without the use of XLeratorDB and SQL Server. XLeratorDB has made us a 15X return and it offers 500 times the processing that Excel is capable of."

Kenneth Jones
Founder and Managing Partner
Fusion Ventures

"Any company currently using the Excel kernel within its applications to handle complex calculations will find XLeratorDB most beneficial, It’s an overall great product – flexible, yet reliable."

Chet Cotter
Director of Financial Systems
Newland Communities, LLC

"We’ve saved as much as 20-30 percent of total development time thanks to XLeratorDB, With XLeratorDB, we can give our clients the means to automate many of their underwriting decisions, lowering their costs and reducing errors."

Jason Daniels
Chief Operating Officer
Verde International

“Before XLeratorDB, there was no easy-to-use, built in solution for XIRR calculation in SQL Server, XLeratorDB is the first product to bridge that gap and streamlines the process for us.

Munish Kumar
Investment Analyst
The Sentient Group

Copyright 2008-2013 WestClinTech LLC         Privacy Policy        Terms of Service