Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Programming
"=" in text file formatting messes with my code loop- more elegant (and faster) solution?
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="ker_01, post: 6329770"] Tim- Thanks for the reply. The problem is that the rest of the data file needs to be general format (not forced to string, as the source file is something like (simplified): ================== Title1 Title2 Title3 Title4 ================== 13 19 4 17 15 0 0 14 12 16 7 28 ================== 18 17 5 19 7 11 9 11 etc. so I need to ignore the rows with the equals, and keep the rest as numbers wherever possible (although the titles will default to text). In considering my reply and how to explain the format, I've updated my code to check the first character when loading each line (earlier in my code), so now my extra calculations are down to one per row, rather than one per parsed value... a 30x improvement, although it still feels like an inelegant approach :) Thanks again, Keith [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Programming
"=" in text file formatting messes with my code loop- more elegant (and faster) solution?
Top