Ok,
Real World Explain:
I have searched and searched for a solution. I am dealing with a string of mineral ownership of land output as text from proprietary system. Sections in a township and range are approx 640 acres. The acres that make up a lease are to the direct left of the approx 640 acres, as is the % ownership. I want the acres to the left of the largest value.
Pseudo Code:
Search alphanumeric text field for the largest number (usually around 640), return the value, decimal and all to the left of the slash of the largest value (usually around 640).
Examples:
Fields can vary a lot. And values can be twice 640, cuz maybe you are dealing with two sections, so 1,280 acres.
1/2 x 151.1112/643.9502 x 3/16 answer is 151.1112
1/2 x 5.0033/643.9502 x 1/4 answer is 5.0033
1/2 x 40/100 x 1/2 x 3/640.5661 x 1/4 answer is 3
1/2 x 72.091/1,276.1256 x 1/4 answer is 72.091 (rarely happens, but it does)
First post ever, apologies if I didn't follow any forum rules correctly.
Thank you
Bookmarks