DataMagic

Data processing and conversion tools

Functions and Features

Basic Features

Matching function

By using multiple files related to the input file by key values, you can combine records from the input file with records from the matching file and output them as a single data.

Matching conditions Product number = Product number *If the setting does not match, "Not registered" will be output for the product name

Merge Function

You can aggregate two or more pieces of data into one piece of data. You can choose whether to delete duplicate rows or not depending on the settings.

Output destination allocation function

You can sort the output files according to the extraction conditions.

Numeric item calculation function

The result of the calculation can be output as the value of the output item.

Data extraction function

You can extract only data that meets the specified conditions from the input data.

Item swap function

You can rearrange the input data items to create a different format.

Item combination/split function

You can split a single item into multiple items, or combine multiple items into a single item and output them.

Other Features

  • Full-width/Half-width function
  • Output format specification function
  • Input sorting function
  • Attribute conversion function
  • Date field calculation function
  • Function Features
  • Mapping Function
  • Dynamic specification function
  • User Exit Conversion Function
  • Data insertion function
  • Specification output
  • tutorial
  • Custom Errors
  • Step execution

Code conversion function

It fully supports user-defined external characters, conversion to EBCDIC, and Windows-specific characters (~?-￠￡￢) that cause problems when converting to Unicode. It also supports standard formats such as Zengin and CII using CSV, XML, and hierarchical formats. In previous versions, characters not defined in JIS Level 1 or Level 2 required registration of external character tables. Starting with the latest version, "DataMagic Ver.3," when converting between SHIFT-JIS, IBM Kanji, UTF-8, and UTF-16, you can choose whether to convert characters not defined in JIS Level 1 or Level 2. It also supports IVS (variant character selector) for UTF-8 and UTF-16.

  • User-defined external characters can be converted to EBCDIC code.
  • Supports external character conversion for the same Kanji code type
  • Supports half-width to full-width conversion (kana/alphabet/numbers/symbols)
  • Full support for Windows-specific characters (~∥－￠￡￢) *As of the end of January 2011
  • Compatible with Windows Vista, the template for registering external characters (2,642 characters) is included as standard in both SJIS and UTF-8 fonts.
Convertible code types: < kanji character code > SJIS, EUC, JEF, KEIS, IBM, NEC Kanji, UTF-16, UTF-8, JIS <Single-byte code> ASCII, ASPEN, Kana characters, English lowercase, NEC Kana characters, IBM English lowercase, IBM English extended Supported data formats Input file: Fixed format, multi-format, CSV, XML, hierarchical format, DB table, Excel file, text file → Data conversion → Output file: Fixed format, multi-format, CSV, XML, hierarchical format, DB table, Excel file, text file
  • DataMagic Desktop does not have code conversion functionality.