Import text File

[stuartc]

I have discovered a problem opening fixed field width text files. The files look fine in Notepad and I have checked them with a hex editor.

In certain cases it takes a digit off the front of a column and adds it into the previous column but with space(s) between it and the previous column.

I have attached an example. The rows affected are 254 Col1 Ref A375 and 280 Col1 Ref G203. This occurs in both 2016 and 2018 versions

Thank you

Stuart

[sven-l]

I opened your file with MS Excel 2016 and PlanMaker 2018 and the file looks identically. Could you give a sample which cell exactly is incorrectly shown?

[sven-l]

Ok, we can now reproduce that issue here and will report it to the developers.

[sven-l]

Our developers are working on a solution for this problem. As a workaround:
- Edit the file with a text editor
- In the first line replace the blanks with an underscore, leave only one blank between the columns. Put the underscores after the label for left-aligned columns, before the label for right aligned columns. The first line should then look like this:
"CCode SalesArea_ Items Value Average Items Value ___Average"

Then import the file as fixed width and all looks good.