Skip to main content
I
ifomenko1-Visitor
1-Visitor
October 26, 2017
Solved

MC15 READFILE bug?

  • October 26, 2017
  • 2 replies
  • 1726 views

I created delimited text file (XYData.dat) by means of python sentence '\t'.join(seq)+'\n'

I`m trying to read delimited text file by means of READFILE command without success.

 

I can`t understand why tab symbols have different length (I discover this in Notepad+), may be this is the reason.

And I can`t understand why MC separate commas in my strings (x,y,z becomes x y z).

Data import wizard works good!

Here attached two files for reference.

Thanks in Advanced

Best answer by terryhendicott

Hi, 

It is not a bug.  Delimeter according to help must be consistent.  You have a mix of commas and tabs.

Also the headings has twelve columns but the data has 36 columns this fools the import.

 

Seperate the headings and data into two files.  Use a text editor to replace tabs by commas so delimiter is constant and then read the files

Capture.JPG

2 replies

T
21-Topaz II
terryhendicott21-Topaz IIAnswer
21-Topaz II
October 26, 2017

Hi, 

It is not a bug.  Delimeter according to help must be consistent.  You have a mix of commas and tabs.

Also the headings has twelve columns but the data has 36 columns this fools the import.

 

Seperate the headings and data into two files.  Use a text editor to replace tabs by commas so delimiter is constant and then read the files

Capture.JPG

    I
    ifomenko1-VisitorAuthor
    1-Visitor
    October 26, 2017

    Thank you vary much for very clear explanation (better then in MC help). At this time I don`t need to use readfile in program block, so I can use data import wizard which works good. Fortunately MC prime has argument for delimeter.

    W
    Werner_E25-Diamond I
    25-Diamond I
    October 26, 2017

    Unfortunately there is no way to tell Mathcads READFILE which character should be considered the delimiter and so its gets confused by spaces, tabs and commas. Looks like Mathcad decided that the comma shoul be the delimiter.

     

    One way to deal with the problem is to create a different data file which is more consistent concerning delimiters or postedit the created file and split it even in two files as Terry suggested.

    If you don't need the Header information in Mathcad, you could simply use READPRN with the file you already have.

    Bild.png

    P.S.: The effect has nothing to do with the different sized tabulator "arrows" you see in Notepad+. Notepad+ is simply drawing an arrow to the nex tab stop, which, if you haven't changed the default values, is every 4 characters.

     

      Terms & ConditionsCookie settingsAccessibility statement