What is fixed width data and how to map it?

Fixed Width text file is widely used in legacy/mainframe or AS/400 systems where the data fields are defined by specific width for each field value. Each field value is restricted to a specific bytes of data. For example here is a sample fixed width data:

PDRV 1011413 150223197532 F45000 8998 1 M 898809 ME3799090 0612199523 1 5 G NY2 0 ENGINEER 

PCMN 1011415 15040155D5W6904106 2026 SA1011411 1201200501052007365 2 12 SP78912 12 1202200512252006I D5W6904106 

Above there are two record types that are identified by the first four bytes, PDRV and PCMN. Each record type is further defined by the related fields that make up that record. There are starting and ending positions for each field. Rules related to left or right alignment, padding of leading or trailing zeroes in case of numbers or decimals, signs to depict a positive or negative numbers etc. There would also be unique mapping rules for each of these fields for data conversion.

Each record type also has relationships with other record types within the file. SAP IDoc is one example of a fixed width data file. Each industry has different data standards that are typically based on fixed width schemas.

In Adeptia you can easily define the fixed width schema and map the fields. Refer to the Fixed Width documentation here:

Fixed Width handling

Video on how to handle fixed width data

Also refer to the videos on how to map data using Adeptia's graphical data mapper interface.

 

You can graphically map Fixed Width file to any format such as:

- Fixed Width file to XML

- Database to Fixed Width data file

- CSV flat file to Fixed Width data file

- EDI to Fixed Width file

- XML to Fixed Width file

- Excel to Fixed Width file

Here is a link to the Data Mapper videos.

https://support.adeptia.com/categories/search?utf8=%E2%9C%93&query=demo+videos+mapping&for_search=1&commit=Search 

Have more questions? Submit a request

0 Comments

Article is closed for comments.