extraction from notepad
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
Hi everyone, I have data in a notepad in the format of:
SLV|41|T|10|05:29:49:887|01/08/2011|f2=38.8504
GLD|41|R|10|05:29:51:674|01/08/2011|f98=158.6
GLD|41|T|10|05:29:51:674|01/08/2011|f2=158.3659
SLV|41|R|10|05:30:05:254|01/08/2011|f98=39.1628
SLV|41|T|10|05:30:05:254|01/08/2011|f2=38.8504
GLD|41|R|10|05:30:06:994|01/08/2011|f98=158.6
I want to extract 4 things from the notepad and bring it in to matlab:
GLD f2 values, GLD f98 values
SLV f2 values and SLV f98 values.
Look forward to a reply soon.
Thank you
1 comentario
Oleg Komarov
el 15 de Abr. de 2012
Are the vertical bars really there?
Since this question is related to your next one I'll tell you that you canimport SLV, GLD and just the numbers after f2 = ... dorectly. This will save you time.
Respuestas (2)
bobby
el 15 de Abr. de 2012
Well import in matlab in shape of an array and then remove all the other columns except the F-values. Or first open the notepad file in excel, so that it is converted in row/column format, and then import xls file in Matlab using xlsread('file.xls')
3 comentarios
bobby
el 15 de Abr. de 2012
http://www.mathworks.com/help/techdoc/ref/importdata.html
I think this function can help you.
Oleg Komarov
el 15 de Abr. de 2012
Soluion with textscan:
fid = fopen('C:\Users\Oleg\Desktop\test.txt');
out = textscan(fid,'%3s%*[^=]%f','Delimiter','=');
fid = fclose(fid);
0 comentarios
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!