Reading numeric values from complex text files
2 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Ben Holmes
el 7 de Oct. de 2015
Comentada: Ben Holmes
el 8 de Oct. de 2015
I know this question has been asked too many times before, but I'm attempting to read numeric values from a text file that has the following format:
2.00000000000000e+001 (-2.58645139980833e+001dB,-3.39749468897168e+001°)
(This format comes from LTspiceIV AC analysis, edit: see attached .txt for example file). I have tried using different functions to read this (dlmread, fscanf, textscan) but with no success. The method I tried was to use multiple delimiters e.g.
{'\t','dB','°','(',')',','}
textscan(filename,'%f %f %f','HeaderLines',1,'Delimiter',{'\t','\n','dB','°','(',')',','});
and also grouped e.g.
textscan(filename,'%f %f %f','HeaderLines',1,'Delimiter',{'\t(','dB,','°)'});
and also with a format specifier including the whole line make-up in fscanf e.g.
'%f\t(%fdB,%f°)'
I also need to skip 1 header row. Where am I going wrong?
1 comentario
Stephen23
el 7 de Oct. de 2015
Editada: Stephen23
el 7 de Oct. de 2015
Can you please upload the complete file. Without this it is difficult to know how the lines are arranged, how the values repeat, the format of the lines, and other information that we need to know how the file should be parsed.
Your title describes them, as being "complex text files", but we do no have any information on their format.
You can upload a file by clicking on the paperclip button and then both the Choose file and Attach file buttons.
Respuesta aceptada
Jeremy Hughes
el 8 de Oct. de 2015
Editada: Jeremy Hughes
el 8 de Oct. de 2015
Hi Ben,
I found this worked. (of course I used a string and not a file id, but it works the same)
textscan(fid,'%f(%fdB%f°)','Delimiter',{'\t',','},'HeaderLines',1)
Good Luck,
Jeremy
Más respuestas (1)
Thorsten
el 7 de Oct. de 2015
You can process individual lines using
s = fgets(fid);
data(i,:) = sscanf(s, '%f (%fdB, %f)');
Ver también
Categorías
Más información sobre Logical en Help Center y File Exchange.
Productos
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!