Import text File

Post Reply
stuartc
Posts: 2
Joined: Fri Oct 23, 2009 8:03 pm

Import text File

Post by 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
Attachments
file.txt
Plain Text File
(27.53 KiB) Downloaded 184 times
sven-l
SoftMaker Team
SoftMaker Team
Posts: 6251
Joined: Wed Apr 09, 2008 8:26 am
Location: Nuremberg
Contact:

Re: Import text File

Post by 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 Leßmann
SoftMaker Software GmbH
sven-l
SoftMaker Team
SoftMaker Team
Posts: 6251
Joined: Wed Apr 09, 2008 8:26 am
Location: Nuremberg
Contact:

Re: Import text File

Post by sven-l »

Ok, we can now reproduce that issue here and will report it to the developers.
Sven Leßmann
SoftMaker Software GmbH
sven-l
SoftMaker Team
SoftMaker Team
Posts: 6251
Joined: Wed Apr 09, 2008 8:26 am
Location: Nuremberg
Contact:

Re: Import text File

Post by 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.
Sven Leßmann
SoftMaker Software GmbH
Post Reply

Return to “PlanMaker 2018 for Windows”