Read txt file and exclude string line..

1 view (last 30 days)
Ahmed Anas
Ahmed Anas on 5 Mar 2020
Commented: Ahmed Anas on 5 Mar 2020
I have attached a file openable in text . The data of the file is as follows:
Note: Joint label, Equation numbers for U1, U2, U3, R1, R2, R3. (See .TXA file)
2 1 0 0 0 2
0
3 0 0 0 0 0
0
4 3 0 4 0 5
0
What i want is to make a matrix from the file by reading the file. The matrix should have three rows and 7 columns. The string line should be excluded.
The first row contains : 2 1 0 0 0 2 0
means the first numeric row in the file and the single numeric entity in the next row should be stored in the 1st row of the matrix made.
and same is for the 2nd and 3rd row of the matrix.
The final matrix is as follows:
2 1 0 0 0 2 0
3 0 0 0 0 0 0
4 3 0 4 0 5 0
Thanks in advance,
  6 Comments
Guillaume
Guillaume on 5 Mar 2020
@Ahmed, I don't know what software you're using that produces the file in this question and your previous one but if it's possible at all you should consider outputting the data in a different format. One that doesn't use a mix of tab and spaces to separate the numbers and one that keeps a row to one line instead of splitting it arbitrarily onto multiple lines.
While it's possible to read any kind of file in matlab, the amount of effort increases if the format is as badly designed as in the present file.
Ahmed Anas
Ahmed Anas on 5 Mar 2020
@Guillaume , Am structure engineering doing my research project on matlab in desktop application development. This file is generated by Sap 2000, a civil engineers software.. Yeah i know this is so badly formated but this data is very helpful for me in my research..

Sign in to comment.

Answers (0)

Categories

Find more on Data Import and Export in Help Center and File Exchange

Tags

Products

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!