Numeric values from text

For some years, I have played with extracting numeric values from text. The following is an image of the report of the findings.
NumbersFromText.png

Column B shows the number of number groups the code has identified. Colmns C and D report on the value of the 1st and 2nd number groups respectively.

You will note that the yellow highlighted cells contain superscript values. However these have not been identified, accordingly the number group values in column B are imcorrect.

The primary numeric extraction is below.

Please Login or Register  to view this content.

I would be grateful for advice on how to identify Superscript and Subscript indices and code for them. Are there any other numeric related printing elements that I should also take into account?

Not entirely sure how you would incorporate this into your code, but this tests strings for characters that have strikethrough and/or, subscript or superscript.

Please Login or Register  to view this content.

PHP Code: 

Debug Output
t             str: False    sub: False    sup: False
e             str: False    sub: False    sup: False
x             str: False    sub: False    sup: False
t             str: False    sub: False    sup: False
              str: False    sub: False    sup: False
b             str: True     sub: False    sup: False
e             str: False    sub: False    sup: False
f             str: False    sub: False    sup: True
o             str: False    sub: False    sup: False
r             str: False    sub: True     sup: False
e             str: False    sub: False    sup: False
              str: False    sub: False    sup: False
1             str: False    sub: False    sup: False
2             str: False    sub: False    sup: False
3             str: True     sub: False    sup: False
4             str: False    sub: False    sup: False
5             str: False    sub: False    sup: True
6             str: False    sub: False    sup: False
7             str: False    sub: True     sup: False
8             str: False    sub: False    sup: False
9             str: True     sub: False    sup: True
              str: False    sub: False    sup: False
t             str: False    sub: False    sup: False
e             str: False    sub: False    sup: False
x             str: False    sub: False    sup: False
t             str: False    sub: False    sup: False
              str: False    sub: False    sup: False
a             str: True     sub: False    sup: True
f             str: False    sub: False    sup: False
t             str: False    sub: False    sup: False
e             str: True     sub: True     sup: False
r             str: False    sub: False    sup: False 


Thank you, Trevor.

I agree that Strikethrough, Superscript and Subscript are the most obvious candidates.

I had hoped to include "overline" for 0.333 ... recurring etc. So far, I have been unsuccessful.

The longer term aim is to identify the script value with a number. For example Normal = 0, Strikethrough = 1, Superscript = 2.
But what about Subscript, should it be 3 or 4? The latter would allow a combination of strikethrough and superscript as 1 + 2 = 3. Thus leaving Subscript as 4,
We could slso a combination Strikethourgh and Subscript as 1 + 4 = 5. Curiously, that would leave a combination of Superscript and Subscript as 2 + 4 = 6. But that does not make practical sense.

I attach a workbook where I have been exploring these issues.

Originally Posted by jindon

swaatacba, try

Thank you. I have tried your code but it does not deliver the results I need.

Also, I confess, that I do not understand the code fully. That would normally prejudice me against using it.

It must be Normal=0, Strikethrough=1, Subscript=2, and Superscript=4. They are all formatting. I would guess that overline would be a separate character set.

See updated example.

Thank you, that was useful. I also noted an error in my original code, which is also helpful.

You're welcome. Thanks for the rep.



If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.