Search All of the Math Forum:

Views expressed in these public forums are not endorsed by NCTM or The Math Forum.

Notice: We are no longer accepting new posts, but the forums will continue to be readable.

Topic: Extract numbers from table containing text and numbers
Replies: 29   Last Post: Feb 7, 2013 5:59 PM

 Messages: [ Previous | Next ]
 dpb Posts: 9,850 Registered: 6/7/07
Re: Extract numbers from table containing text and numbers
Posted: Feb 2, 2013 1:40 PM

On 2/2/2013 8:29 AM, dpb wrote:
> On 2/1/2013 8:19 PM, Stan wrote:
>> dpb <none@non.net> wrote in message <keh2cd\$6al\$1@speranza.aioe.org>...
>>> On 1/31/2013 8:40 PM, Stan wrote:
>>> I cut'n pasted a sample line into a cell string and at the command
>>> line get...
>>>

>>> >> textscan(d{1},'Q (upper-edge -%f AmP )= %f+- %f %*s')
>>> ans =
>>> [-1.2500e-04] [0.0099] [2.8300e-04]

>>> >>
>>>
>>> Salt to suit...
>>>
>>> --

>>
>> I did this:

>>>> d = {' Q (upper-edge ........'};
>>>> textscan(d{1},'Q (upper-edge -%f AmP )= %f+- %f %*s')

>>
>> ans =
>>
>> [-1.2500e-04] [0 X 1 double] [0 X 1 double]
>>
>> ------------------------------------X------------------------------------
>>
>> How did you define the cell string? Did you use something different?

>
> Nope...just cut'n paste from your prior post...
>

...

And, just to check I copied and pasted your textscan() call above into
command window here and it works just as expected...

>> textscan(d{1},'Q (upper-edge -%f AmP )= %f+- %f %*s')
ans =
[-1.2500e-04] [0.0099] [2.8300e-04]
>> d={' Q (upper-edge --0.1250E-03 AmP )= 0.98880E-02+- 0.28300E-03
units/alpha/round';'Q (upper-edge --0.2500E-03 AmP )= 0.19648E-01+-
0.39412E-03 units/alpha/round'};
>> textscan(d{1},'Q (upper-edge -%f AmP )= %f+- %f %*s')
ans =
[-1.2500e-04] [0.0099] [2.8300e-04]
>>

One does now have to begin to question that there may have been a bug
fix in textscan() between the 12a and 12b releases.

If you have official support, might send this one in as real support
question to TMW...unless you can uncover something internal in the
string there that doesn't show up from the posting text...

--

Date Subject Author
1/31/13 Stan
1/31/13 Stan
2/1/13 Stan
2/1/13 dpb
2/1/13 Stan
2/2/13 dpb
2/2/13 dpb
2/2/13 Stan
2/2/13 dpb
2/2/13 Stan
2/2/13 dpb
2/3/13 dpb
2/3/13 dpb
2/3/13 Bruno Luong
2/3/13 dpb
2/3/13 Bruno Luong
2/3/13 dpb
2/3/13 dpb
2/4/13 Bruno Luong
2/4/13 dpb
2/4/13 dpb
2/5/13 Bruno Luong
2/5/13 dpb
2/5/13 Bruno Luong
2/5/13 dpb
2/5/13 dpb
2/3/13 Stan
2/3/13 Bruno Luong
2/7/13 Stan