Login     Register

        Contact Us     Search

XLeratorDB/strings Package

  XLeratorDB lets you realize the full power of SQL Server with in-database processing. Invoke dozens of advanced 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. SQL Server can hold more than a terabyte of critical data; XLeratorDB/strings gives you a new level of power and accuracy to measure the returns and manage the risks.

XLeratorDB/strings includes over 40 SQL Server functions for:

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


XLeratorDB / string - Documentation

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

“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

"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

"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

Copyright 2008-2013 WestClinTech LLC         Privacy Policy        Terms of Service