How convert a matrix (nxn) into a single column?

[ksharma-2]

Hello,

How can we convert a matrix (nxn) into a single column (vector)?

Regards,

Keshab

[Fred_Kohlhepp · Accepted solution]

A simple program

[ksharma-2]

Sir

I have the ground motion data in txt file as follows: I want to escape the the text from the first 6 rows and text from the last row. Finally I need a vector escaping all text in this txt file.
Could you help me how can I do it?

Thank you very much.

[adar]

Keshab

Go to insert>component>import wizard and choose delimited text. then put the file name by browsing it. The wizard will

ask you for the row number. In your file the data begins at row 7. If you wish to give the range of columns you can. after you are done you will have to give a name to this data. If you send me the data file, I can send you a mathcad file for it.

all the best

[ksharma-2]

Amitabh

Here you can find data clicking the following link. As you know, I want to escape the text and a column vector (2nd column sould be below 1st column and so on).

Thank you for your great help.

http://nisee.berkeley.edu/data/strong_motion/a.k.chopra/index.html

Regards,

Keshab

[VladimirN]

If you work with Mathcad Prime 3.0 you can use Excel component:

• "Importing Data": http://learningexchange.ptc.com/tutorial/159/importing-data
• "Using the Excel Component": http://learningexchange.ptc.com/tutorial/948/using-the-excel-component

All Mathcad Prime video tutorials: http://learningexchange.ptc.com/tutorials/by_sub_product/ptc-mathcad-prime/sub_product_id:19?lang=en