Trying to obtain data from .SQL file
古いコメントを表示
Hello all. I am trying obtain a range of data from an sql file starting from the row after which contains:
/*!40000 ALTER TABLE `CAR_PKT_EXC` DISABLE KEYS */;
and ending in the row before which conatins:
/*!40000 ALTER TABLE `CAR_PKT_EXC` ENABLE KEYS */;
I can't just convert to xlsx and use range of A294:A325 because each data file has them stored in diferent places. I.E. some start at line 294, 280, or 229, etc. I then want it delimited by comma so that I can make it a 77 column by whatever row table. The issue is, after it is delimited the table is asymmetrical containing some blank elements at the end of some rows with the dimensions being 36x6094.. So reshaping doesn't work for me. I've started this code from scratch many times and just looking for some help. How can I just have the code search for those two lines and read the data between them and then for every 77th element in the table for it to start a new row? If I need to convert the sql file to txt, csv, or xlsx that's fine too. I converted it to excel and found it to be easier, but if there is a way I can just use the source file I'd rather do that.
I attached a image of my data since I couldn't attach it here (File was too large).
I appreciate any help at all. Thank you!
回答 (0 件)
カテゴリ
ヘルプ センター および File Exchange で Cell Arrays についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!