Tech Specs
Supported Platforms
Microsoft Windows Versions NT, 2000, XP, 2003 Server, and Vista.
|
Supported Data Formats
- Character(s) Delimited
- Fixed Length
- Miodata
- MQ
- Size Prefixed
- CSV
- IMS*
- ODBC
- Regex Delimited
- XML
Supported Data Encodings
All supported for both viewing and exporting
- ASCII Latin-1
- ASCII IBM CP 850
- EBCDIC
- EBCDIC CP 273 (German)
- MacRoman
- Unicode UCS-2
- Over 80 Other Encodings Supported*
Supported Export Formats
- Source Records
- Delimited: CR, LF, CR/LF
- CSV
- Miodata
- MQ
- ODBC
Supported Export Options
- Source Records
- Converted Records
- Eliminate Consecutive and Keyed-Alike
- Change start and end record number
- Join multiple files
- Cross Product
- Save export options in format file
|
Single Column Transformations
- Trim White Space
- Add Space Padding
- Search & Replace (Normal, Collapse, Regex)
- Substring Transformer
- Table Lookup
- Encode / Decode Web Character Entities
- Case Conversion (Upper, Lower, Invert)
- Capitalize Words (Normal, With Concatenation)
- Split at Capitals
- Fixed Length Field Transpose
- Ascending/Descending Value Cleanser
- Bad/Good Value Cleanser
- Maximum/Minimum Length
- Repeating Value Cleanser
- Configurable Date Converter
- Binary Conversion (Binary to Decimal,
Binary to Hex,
Hex to Decimal, Packed to Decimal)
- Encode/Decode Base64
Multi-Column Transformations
- Computation
- Repetition Concatenator, Filter
- Rule Table
- String Substitution
- Switch
Configurable Parser
- Pattern-based Transformations
- Support for Subpatterns
- Multiple Rule Category Types:
Equality, Regex, Internal/External List
- Pattern, Rule, and Parser Level Cardinality
- Configurable Tokenizer
- Repetition Support
|
* IMS supported from data obtained through the FABHURG1 unload utility.