OK, so this is what I put together after yesterday's discussion:
// Populates the Lookup combo box
var vCheckcodeLookups as string
vCheckcodeLookups = @XListValues(@FN, "Customer!Checkcode")
vCheckcodeLookups = @SortstringArray(vCheckcodeLookups,0)
vCheckcodeLookups = @Replace(vCheckcodeLookups, "\", "\\")
vCheckcodeLookups = @Replace(vCheckcodeLookups, "&", "\&")
vCheckcodeLookups = @Replace(vCheckcodeLookups, "(", "\(")
vCheckcodeLookups = @Replace(vCheckcodeLookups, ")", "\)")
vCheckcodeLookups = @Replace(vCheckcodeLookups, "..", "\.\.")
vCheckcodeLookups = @Replace(vCheckcodeLookups, ";", "\;")
vCheckcodeLookups = @Replace(vCheckcodeLookups, "/", "\/")
vCheckcodeLookups = @Replace(vCheckcodeLookups, "=", "\=")
vCheckcodeLookups = @Replace(vCheckcodeLookups, ">", "\>")
vCheckcodeLookups = @Replace(vCheckcodeLookups, "<", "\<")
vCheckcodeLookups = @Replace(vCheckcodeLookups, "?", "\?")
vCheckcodeLookups = @Replace(vCheckcodeLookups, "~", "\~")
vCheckcodeLookups = @Replace(vCheckcodeLookups, "`", "\`")
vCheckcodeLookups = @Replace(vCheckcodeLookups, "[", "\[")
vCheckcodeLookups = @Replace(vCheckcodeLookups, "]", "\]")
PopulateListElement(Pickup_Lookup, vCheckcodeLookups)
This is working great for things like the parentheses and the ampersand. However, it is adding a backslash to the end of every redesigned search term. that is, it is making this:
Quote:R & M Freight ( 8562
into this:
Quote:R \& M Freight \( 8562\
Clearly the first @Replace is the culprit, but what's the best way to deal with it?
Thanks for your help.