Home » Solutions » Data Transformation » Substrings
Substrings 
CoSort Supports Regular Expressions for Pattern Matching and String Manipulation

Challenges:
String-level expression logic is used to search and manipulate data according to certain patterns. This functionality is often associated with text editors and shell commands, but is rarely integrated into high volume data processing operations.

In other words, string parsing, pattern matching, and other low level manipulations must usually occur in a separate tools and I/O steps, increasing coding and processing overhead.


Solutions:
The CoSort package's SortCL tool now directly integrates Perl Compatible Regular Expression (PCRE) logic for pattern matching, as well as find and replace and other substring-level data manipulation. This in addition to field padding and alignment, character validation and field re-mapping.

More importantly, this intricate data manipulation can occur in the same job script and and I/O pass with all the other simultaneous functionality available to SortCL users; i.e.

• Data Transformation (sort, join, aggregate, filter, remap, etc.)
• Data Conversion (of data types and file formats)
• Data Protection (field level encryption, de-ID, masking, etc.)
• Data Reporting (batch, delta, detail and summary BI)

See Next Steps for more information and to inquire with IRI about your specific requirements.


See also:
Cross-Calculate
Re-map/Reformat
Products > CoSort > SortCL
make text smaller make text larger print this pageemail this page
» Resources
» Next Steps
1-800-333-SORT
1-321-777-8889
Did you find what you were looking for on this page?
YesNoUnsure

What you were looking for:

Include your email address if you would like a response.