Import text File

Post your questions, bug reports and suggestions here for PlanMaker 2018 for Windows.

Moderator: SoftMaker Team

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

Import text File

Post by stuartc » Thu Sep 13, 2018 12:36 pm

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 14 times

sven-l
SoftMaker Team
SoftMaker Team
Posts: 8027
Joined: Wed Apr 09, 2008 8:26 am
Location: Nuremberg
Contact:

Re: Import text File

Post by sven-l » Fri Sep 14, 2018 2:35 pm

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: 8027
Joined: Wed Apr 09, 2008 8:26 am
Location: Nuremberg
Contact:

Re: Import text File

Post by sven-l » Fri Sep 14, 2018 2:47 pm

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: 8027
Joined: Wed Apr 09, 2008 8:26 am
Location: Nuremberg
Contact:

Re: Import text File

Post by sven-l » Mon Sep 17, 2018 8:09 am

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”