Skip to main content
태
태장_011-Visitor
1-Visitor
February 28, 2016
Question

import data with dat file and string

  • February 28, 2016
  • 3 replies
  • 3630 views

Hi

I am trying to import the data which has both the string and numbers from testing result in mathcad prime 3.0 version but in mathcad 15 version, I can sort the data with rows and columns as enclosed file but no idea to sort the columns as 15version did. someone help me? thanks in advance!

3 replies

W
Werner_E25-Diamond I
25-Diamond I
February 28, 2016

The file you try to read is NOT comma separated which means that the values are not separated by a "," sign.

You can tell Prime that it should use another separator (which seems to be simply a space here ore better: we have fixed widths) and also to replace empty values not by NaN's but by a zero (which seems to be the case in the picture of Mathcad 15 you provided).

Unfortunately the Prime help, as so often, is not of any help here, so we have to resort to Mathcad 15 help

If we apply this information to your data we get

which seems to be close to what your Mathcad 15 pic is showing.

When I use the same command in Mathcad 15 I get this result

As you can see MC15s result is different but still not correct either.

You may consider reading the file beginning with line 8 (the actual data) and reading in the parameters of the first few lines in an extra step.

You may also consider playing around with READFILE (not sure about that) or READBIN,

Or you are able to preprocess the data file making it better suited for Primes Read commands.

Only when If I look at your data file using a simple editor I see what the data actually should be:

W
Werner_E25-Diamond I
25-Diamond I
February 28, 2016

Here is a way to get the actual data beginning from row 8 in a neat way

There are 8 values per row and the data seems to be formatted taking up 5 columns (the first one only 4) per value (including preceding spaces). Therefore the 8 x 1 vector consisting of mostly 5's.

WE

W
Werner_E25-Diamond I
25-Diamond I
February 28, 2016

OK, here is the rest:

WE

    태
    태장_011-VisitorAuthor
    1-Visitor
    March 2, 2016

    Dear Werner Exinger

    Thank you very much for your help! It is helpful for me to advance to next step and I informed to PTC about this trouble in mathcad prime.

    Have a nice day!

    with best regard,

    T.K,Jang

    W
    Werner_E25-Diamond I
    25-Diamond I
    March 2, 2016

    While its interesting an a bit irritating that Mathcad and Prime give different results when using READCSV, both have to fail.

    But don't blame Mathcad and even not Prime - the Problem is not Mathcad or Prime but simply the fact, that the data file is not a CSV (comma separated values) file.

    Nevertheless, after finding out what the file format is, I showed you how to correctly read in the parameters and data - both in Mathcad and Prime.

    So there is nothing wrong here an nothing buggy.

    Terms & ConditionsAccessibility statement