Performing numeric comparison after matching a string of text

Try this;

Formula:

Please Login or Register  to view this content.

That should return the string you want, the original strings are in a similar format. Does this answer all your questions?

Thanks for the very quick response!!

There are a couple of things at play here which make the above solutions not quite sufficent .


First, the actual ouput of the tool looks similar to the sample below. As you can see, the text that will be examined is *not fixed length* -- furthermore the numeric could be 3 or 4 characters in length (i.e., 500, 1000, 8000).

Second, I actually need to *compare* the number (only) after the matching string is found:

Process:

a) detect the string Topping=Mushroom,Extras=Soda
b) compare the next characters using a less than symbol (i.e.: (500) or (1000) or (8000)
c) report back findings of one (or more -- doesnt matter) hits - preferably in the format of: Extras=Soda(526), Extras=Soda(8234), etc. but True/False is fine too!


I hope this makes sense, and please let me know if you need more clarification.

Please Login or Register  to view this content.

This should give you the number irregardless of length:

Formula:

Please Login or Register  to view this content.

But perhaps you need to share a sample worksheet.

Maybe I'm not understanding ... will the text "Topping=Mushroom,Extras=Soda" appear more than once in each string (cell)?

Yes -- it appears multiple times in a single cell.

Also, it is safe to say that the number you're looking for is always between the first two parentheses in the string?

Yes, it will always appear between the first two parenthesis.


Soren, thank you very much - I see now I can append '> 1000' to the end of the formula you provided to perform the math.

I have to apologize for not showing the true-true layout of what is exported -- it is as follows -- new additions in underline. As you can see, this: All Findings (>= 8000 total structures) is causing the formula to return #VALUE! When it is removed, it works PERFECTLY!! We are very close -- thanks so much!

And again, there are MULTIPLE occurences in each cell -- I somehow need to pull the HIGHEST number out and use that to compare with 1000. Can this be done?


Furthermore, the string must be matched first because only occurences of 'Topping=Mushroom,Extras=Soda' should be found. If 'Topping=MoreCheese,Extras=Soda' was detected, the finding should *not* be evaluated.

Summary:

Enemeration of Food and Sports

Details:

This tool exports the desired attributes you selected.


Suggestion:

n/a

Matches:

All Findings (>= 8000 total structures)

Food,Pizza=Cheese,Topping=Mushroom,Extras=Soda(12),Breadsticks=TooFat
Sports,Baseball=Fun,Basketball=Soso,Soccer=Footy(1500),Badminton=lolseriously

Legend :

{Activity}
Pizza={pza}
Topping={tp}
Extras={ext}
Breadsticks={brs}
{understood_questionmark}

Something like this:

Formula:

Please Login or Register  to view this content.

(>= 8000 total structures)

You could write a crazy long formula to convert the above to an =IF() statement, but, as mentioned, it'll be crazy long! What you can do, if the logic is always ">=", is to use a similar approach as in post #8 to grab the number; 8000 in this case, and then connect the stuff in an =IF() statement. Otherwise you need vba which is not my strong suit.

If you find that you need vba, then I suggest that you mark this thread as solved, and start a new one which is dedicated to that issue.

I'm pretty confused at this point... I think you'll need to upload a sample workbook also containing your desired results.