Easy Morph moves end of row

I have a file coming from COBOL Mainframe with EBCDIC encoding, which has exactly 2000 characters per row. I tried to import this file with all formats (Fixed width text, plain text), but Easy Morph puts the end of rows in different positions depending on what’s on each row, later affecting the structure of the information that I need to retrieve.

My question is, how can I command Easy Morph to stick to the 2000 characters per row?

Here is a similar file as an example, the first row appears to be bigger, so it moves everything after that.

image

Hi Julian and welcome to the Community!

Try selecting the correct codepage for EBCDIC encoding. See below:

Hi Dmitry, thank you very much!

What I failed to mention in the initial query is that i´m importing a binary file and we already have selected IBM 500. I´ve also tried multiple of the EBCDIC codepages but none of them seem to work, they might change the interpretation of some rows but still not getting the 2000 characters per row by far.

Here it is a screenshot (in Spanish) of another software (IDEA Caseware) which imports the data correctly. This software has the option EBCDIC with fixed length:

After this step, IDEA allows me to specify manually the amount of characters per row. My question now would be, Is there any way to replicate this in EasyMorph?

Also I attach one of the binary files i´m working with for testing purposes

Prueba.txt (56.8 KB)

You can try using the “Import fixed width text” action and then unpivot columns into rows.

1 Like