Found it. Thank you BWS for the Help file! :)
F("V1") = Text("[D(3)]" & "<TD>@USPS - ZIP Code Lookup - Find a ZIP + 4
Code By Address Results") 'Using the "[ & ]" around D(3) makes
it a "like" statement. As long as it's close, it's good to go.
Brian Bennett
Affinity Health Systems
Systems Analyst
PBS\Clinic Billing
(920)628-9055
[EMAIL PROTECTED]
_____
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Brian Stevenson
Sent: Tuesday, August 05, 2008 7:37 AM
To: [email protected]
Subject: RE: [Talk] Web Interaction
Would using a timer be somewhat beneficial to you? I suppose you could
start the timer and if say a min. or so later nothing has happened then
you could initiate your own code to stop what you are doing and move on
to another search....
Brian Stevenson | Systems Administrator
<http://www.universityhealthsystem.com/> University Health System |
Business Information Services
355-2 Spencer Lane | San Antonio, TX 78229
Office | (210) 358 - 9282
Pager | (210) 756 - 0582
_____
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bennett, Brian
Sent: Tuesday, August 05, 2008 7:27 AM
To: '[email protected]'
Subject: [Talk] Web Interaction
Being a glutton for punishment (or not know when to say N.O.) I've
stated that I can update our location dictionary with correct address
information. This means connecting to the usps.gov website and
"attempting" to interact with it. Everything was going so smoothly,
until I went to the next record. If I could avoid D.Next_ so many
problems would be self resolving. :)
Here's the problem the TEXT location that I need to view changes for
each record.
I.e. TEXT ("123 my Street*<TD>@USPS - ZIP Code Lookup - Find a ZIP + 4
Code By Address Results") and then
TEXT("456 yours Ave*<TD>@USPS - ZIP Code Lookup - Find a ZIP + 4
Code By Address Results")
Leaving off the street address renders the F("V?") = TEXT (whatever)
useless. I thought I had it figured out by using
F("V?")= TEXT(D("3") & "*<TD>@USPS - ZIP Code Lookup - Find a ZIP + 4
Code By Address Results") 'Since D("3") is my street address
But NOOOOO, Human nature (being what it is) causes me many headaches.
Misspell a word, or leave something as little as a W,E,S or N off the
street name and the script sits there for ever and a day.
Is there a wildcard that could be used in place of D("3")? Or if anyone
is bored, perhaps you can help me figure out what would work? I've
pretty much viewed every element on the page. As far as I can tell,
with out the street address it does not view the text.
So in the end it would look like:
F("V?") = TEXT( ANYTEXT & "*<TD>@USPS - ZIP Code Lookup - Find a ZIP + 4
Code By Address Results") 'Since the results would be the same.
Thanks
p.s. F("V?") = TEXT("*<TD>@USPS - ZIP Code Lookup - Find a ZIP + 4 Code
By Address Results") ' Reads no text off the page.
Brian Bennett
Affinity Health Systems
Systems Analyst
PBS\Clinic Billing
(920)628-9055
[EMAIL PROTECTED]
