This module started out life as Splits and Merges, but has since emerged as a powerful data manipulation tool. If you want to combine or split any number of data-sets, undertake 1:N selects, create test cells, change strings or substrings, this is the utility you'll use.
Forget having to constantly run queries, import and export data or write special routines. Splerge's straightforward command system enables you to manipulate your data seamlessly and safely - it will even validate the syntax of your script before running it.
Data is rarely supplied as required. Splerge's field manipulation functionality enables you to:
Combine, populate, create and delete fields
use or move sub strings
undertake conditional processes within a field to create new fields
take sub strings, to transfer field content from one to another.
Undertake date manipulation and mathematical calculation
As a text based tool, with a comprehensive script library provided, the module is a powerful way of structuring fields within a job. You can create statements to revise the content of any string or sub string based on your specified criteria.
From date conversions to defining macros, this module is the tool. Splerge's manipulation functionality also enables basic match routines and check digit calculations, even bespoke DLL calls along with endless other processes.
