Re: How to load data files with mixed str & numerical data with headers "*.txt.gz" or "*.xml.tgz"

[Shoumei]

http://octave.1599824.n4.nabble.com/file/n4642993/GSE1-2.txt GSE1-2.txt 
The extracted data files are txt files suffixed with ".soft' .  I need to
extract from the files the data matrixices of usually repeated 44Kxn
tables/matrices with a start line ' !series_matrix_table_begin' and end with
' !series_matrix_table_end'. The string data are 44Kx1 and the numerical
data are 44x(n-1). I could possibly ignore the other ! comments. I knew the
exact matrix size for each repeated matrixices.
The example file attached included data of two samples (GSM1&GSM2), each
with a 2x2 matrix .
The complete txt file could not be loaded in excel or word. 
The other tables in the sample file between"!platform_table_begin" and
"!platform_table_end"  are info related to each ID/string-This info I could
process from other files so are ignored for the time being.
When I dealt with small txt files I usually opened with excel and save the
string (ID) as csv files and the numerical data as txt files. I had trouble
comparing the strings with other string files if I save the whole file as
csv and used "csv2cell' to load the data.
I was not able to use"xlsread' with mixed string and numerical xls data
initially so I did not persist in using it.
Thanks
Shoumei



--
View this message in context: 
http://octave.1599824.n4.nabble.com/How-to-load-data-files-with-mixed-str-numerical-data-with-headers-txt-gz-or-xml-tgz-tp4642969p4642993.html
Sent from the Octave - General mailing list archive at Nabble.com.