Title
Loop Ending One Value Early
Post
Hi All,
I am at a loss:
My find and replace loop (see attached pdf) is ending one value early in the "replace" category so that all records found for search $AgencySearch[n] have the Source field replaced with blanks.
The problem persists even if I add 1 to the End If statement, and the number of values of the Find and Replace lists are equal (I know because the second to last pairing works fine).
The one workaround I have found is to double list the last entry of the $AgencyReplace list. i.e.:
- $AgencySearch: "one", "two", "three"
- $AgencyReplace: "1", "2", "3", "3"
works fine while
- $AgencySearch: "one", "two", "three"
- $AgencyReplace: "1", "2", "3"
results in all "three" records becoming empty.
Any thoughts?
Your exit loop expression should be $i > ValueCount (...