You could do something like this:
StringVar parcel := '';
NumberVar atParcel;
at := InStr({table.comments}, '; Parcel');
if at > 0 then
parcel := lTrim(Mid({table.comments}, at + 7, length({table.comments}));
parcel
This will give you everything after the word "Parcel" if it is preceded by "; ". So, it should filter out any situations where the word Parcel is included in the address etc.
-Dell
IP Logged
