I am scraping some data off of a web page and storing it into a string. That part is working great. Now I want to "navigate" the string (using Lotus Script) and pull out specific pieces of data. I planned to use functions such as strRight and Left$ to do this however it's a lot more cumbersome than I expected. Before I continue down this road further, I thought I'd ask more seasoned developers if they could suggest a better way.
For example, for each company listed, I am trying to grab the NAIC #, the Underwriting Limitation amount and licensed states from the sample data below. I'm able to jump to the NAIC number using StrRight and grab the data to the right of it but that is where everything gets messy. I'm not sure how to continue on from that point and get the next bit of information (underwriting limitation).
I may be way off in my approach, so any suggestions would be greatly appreciated. Thanks!
<p><strong>ACCREDITED SURETY AND CASUALTY COMPANY, INC. (NAIC #26379)</strong><br>
BUSINESS ADDRESS: PO Box 140855, Orlando, FL 32814 - 0855. PHONE: (407) 629-2131. UNDERWRITING LIMITATION b/: $1,641,000. SURETY LICENSES c,f/: AL, AK, AZ, AR, CA, CO, CT, DE, DC, FL, GA, HI, ID, IL, IN, IA, KS, KY, LA, ME, MD, MA, MI, MN, MS, MO, MT, NE, NV, NH, NJ, NM, NY, NC, ND, OH, OK, OR, PA, RI, SC, SD, TN, TX, UT, VT, VA, WA, WV, WI, WY. INCORPORATED IN: Florida.</p>
<p><strong>ACSTAR INSURANCE COMPANY (NAIC #22950)</strong><br>
BUSINESS ADDRESS: P.O. BOX 2350, NEW BRITAIN, CT 06050 - 2350. PHONE: (860) 224-2000. UNDERWRITING LIMITATION b/: $2,848,000. SURETY LICENSES c,f/: AL, AK, AZ, AR, CA, CO, CT, DE, DC, FL, GA, HI, ID, IL, IN, IA, KS, KY, LA, ME, MD, MA, MI, MN, MS, MO, MT, NE, NV, NH, NJ, NM, NY, NC, ND, OH, OK, OR, PA, PR, RI, SC, SD, TN, TX, UT, VT, VA, WA, WV, WI, WY. INCORPORATED IN: Illinois.</p>
<p><strong>Aegis Security Insurance Company (NAIC #33898)</strong><br>
BUSINESS ADDRESS: P.O. Box 3153, Harrisburg, PA 17105. PHONE: (717) 657-9671. UNDERWRITING LIMITATION b/: $4,353,000. SURETY LICENSES c,f/: AL, AK, AZ, AR, CA, CO, CT, DE, DC, FL, GA, HI, ID, IL, IN, IA, KS, KY, LA, ME, MD, MA, MI, MN, MS, MO, MT, NE, NV, NH, NJ, NM, NY, NC, ND, OH, OK, OR, PA, RI, SC, SD, TN, TX, UT, VT, VA, WA, WV, WI, WY. INCORPORATED IN: Pennsylvania.</p>
<p><strong>ALL AMERICA INSURANCE COMPANY (NAIC #20222)</strong><br>
BUSINESS ADDRESS: P.O. BOX 351, VAN WERT, OH 45891 - 0351. PHONE: (419) 238-1010. UNDERWRITING LIMITATION b/: $10,726,000. SURETY LICENSES c,f/: AZ, CA, CT, GA, IL, IN, IA, KY, MA, MI, NV, NJ, NY, NC, OH, OK, TN, TX, VA. INCORPORATED IN: Ohio.</p>
<p><strong>Allegheny Casualty Company (NAIC #13285)</strong><br>
BUSINESS ADDRESS: One Newark Center, 20th Floor, Newark, NJ 07102. PHONE: (800) 333-4167 x-269. UNDERWRITING LIMITATION b/: $1,851,000. SURETY LICENSES c,f/: AL, AK, AS, AZ, AR, CA, CO, CT, DE, DC, FL, GA, HI, ID, IL, IN, IA, KS, KY, LA, ME, MD, MA, MI, MN, MS, MO, MT, NE, NV, NH, NJ, NM, NY, NC, ND, OH, OK, OR, PA, PR, RI, SC, SD, TN, TX, UT, VT, VA, WA, WV, WI, WY. INCORPORATED IN: Pennsylvania.</p>
 
Feedback number WEBB8W5RW8 created by Christopher J LaCasse on 07/12/2012
Status: Open
Comments:
 Best Way to Search a String? (Christopher J L... 12.Jul.12)
 . . This is how I would do it... (Karl-Henry Mart... 19.Jul.12)
. . Here's one way (Wayne Gibbons 12.Jul.12)
. . . . Sounds good (Christopher J L... 13.Jul.12) |
Return to top
Printer-friendly
