Loading data from document and isolating numbers.
3 views (last 30 days)
Show older comments
Hi, I have to add to creating program a complicated database from other file with united numbers sometimes with no space between them. Which formula should I use to load from random line in data document, and isolate them to other calculations.
Example 1.543 345.1200 1.32399.0099.00 1.3399.00
Thank you.
4 Comments
Thorsten
on 9 Jan 2013
Unless you have some further information about the values of the numbers (e.g., always > 10) or the format (e.g., number of significant digits) you cannot retrieve the original numbers, because you can cut a chunk of digits at any positions other than those just before and after a . that would leave you with this single '.', which is not a number.
Accepted Answer
Walter Roberson
on 9 Jan 2013
NumericLine = str2double( regexp( regexprep(TheLine, '99\.0', ' &'), '\s+', 'split') );
2 Comments
Walter Roberson
on 10 Jan 2013
You would need to have scanned the line as a string, so you might as well fgetl() instead of fscanf()
More Answers (0)
See Also
Categories
Find more on Logical in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!