extract numberic database from long string value depends upon index value

Dear experts

I have alphanumberic long string in cell and want to pull the numeric value from cell depend upon header Dead or killed and injured or wounded
whereas come along with text string in cell.

The 2001 HaSharon Mall suicide bombing in Netanya, Israel. 5 killed 100+ injured. pull like (5 killed) and (100+ Injured)
2002 Jaffa Street bombing. 1 dead,23 Wounded Pull like (1 dead) and (23 wounded)

find the attachmen

Hi johnlara,

Sad topic, but interesting techincal problem. See the attached file with complete code below. I approached the problem as follows:
a. A Data line was read and conveted to Upper Case.
b. Commas embedded in numbers were removed.
c. A space was added when a number was adjacent to a non-number.
d. All commas and periods were removed.
e. Certain IRRELEVANT KEYWORDS (e.g. People, Men, Women) were removed.
f. The remaining text in the line was parsed into tokens (i.e. words).
g. A match was found when one of your IMPORTANT KEYWORDS was preceded by a number. The Number was placed in the appropriate Column. More than one match is allowed for a category in a row.

As you get more experience, additional IRRELEVANT KEYWORDSmay have to be added.

In an ordinary Code Module such as Module1 or ModProcessTextStrings:

Please Login or Register  to view this content.

If you need help with Macros and or VBA:

To enable Macros and to Run Macros see the following:
http://office.microsoft.com/en-us/ex...010031071.aspx
http://office.microsoft.com/en-us/ex...010014113.aspx
If help is still needed do a google search for 'youtube excel enable macro' and/or 'youtube excel run macro'.

To access Visual Basic (VBA) see:
http://www.ablebits.com/office-addin...a-macro-excel/
a. Click on any cell in the Excel Spreadsheet (may not be needed).
b. ALT-F11 to get to VBA.
c. CTRL-R to get project explorer (if it isn't already showing).
d. Double Click on a 'Module Name' in 'Project Explorer' to see code for that module.

Lewis

Try

Please Login or Register  to view this content.

Thanks sir its works perfecly