Hello,
I am new to Access....migrating from FoxPro. I am trying to replicate a function I use to parse a comment field to determine that the comment meets certain requirements. The existing code loops through the table and examines each comment for a series of words or phrases. Currently I am searching the comment field with 32 distinct words or phrases. The segment of code I am trying to replicate looks like this:
.............
If At("MAILED", Upper(comments.alc_commen)) >0
Replace comments.EXCLUDE With comments.EXCLUDE+1
Endif
If At("FAXED", Upper(comments.alc_commen)) >0
Replace comments.EXCLUDE With comments.EXCLUDE+1
Endif
If At("RETURNED", Upper(comments.alc_commen)) >0
Replace comments.EXCLUDE With comments.EXCLUDE+1
Endif
If At("VOIDED", Upper(comments.alc_commen)) >0
Replace comments.EXCLUDE With comments.EXCLUDE+1
Endif
If At("ISSUED", Upper(comments.alc_commen)) >0
Replace comments.EXCLUDE With comments.EXCLUDE+1
Endif
............
In VFP the command AT(TextString, TextSearched) returns the character position of the occurrence of the TextString, zero if not found.
Upon completion of the existing VFP code, records with 0 are deleted, the remaining comments are compared by date to determine response time.
I can replicate this with multiple queries, but assume there is a programmatic method. Please help!
Thank you in advance.