avoid replacing numbers with nans when importing data from dat file

2 views (last 30 days)
I have a dat file that is mixed up with text and numbers. However, I only need the numbers from certian row to certian row (all the text and other numbers are not needed)
I have tried to use readtable function, but all the numbers I want to read are appearing as NaN. Moreover, when I convert the whole file to excel and deleted everything except my numbers then readed the file as xlsx it works but some variables appear in the following format ('123') thus matlab assume these are cells and an error appear saying that var1 and variablr 22 are double and array.
Therefore, how can I read directly from the dat file and avoid the issue of NaNs then avoid the cells and read the numbers or better to change the cell to regular double data that can be assigned to variables without errors.
  6 Comments
Ameer Hamza
Ameer Hamza on 21 Oct 2020
Edited: Ameer Hamza on 21 Oct 2020
When I import the file in R2020b, all columns are read correctly except column 22. You can read it as string
opts = detectImportOptions('data.csv');
opts.VariableTypes{22} = 'string';
T = readtable('data.csv', opts)
Abdulkarim Almukdad
Abdulkarim Almukdad on 21 Oct 2020
it worked maybe because I have deleted the text, I have attached a new file that includes some of the text in the data

Sign in to comment.

Answers (0)

Tags

Community Treasure Hunt

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

Start Hunting!