I'm not sure I completely understand your problem, but I'll take a stab at
Assuming you have a field containing GUYTEST.ZIP, and nothing else, you can
use breakapart() to break the string defined as GUYTEST.ZIP apart at the
period and store the results in an array which, in this case will have two
elements: array will be GUYTEST and array will be ZIP. Now just use
string concatenation to rewrite the array elements into a string variable
(strvar=ar+ar+".") and then define the field as the new string. Use a
scan loop to perform this on all the records in your table. Just be careful
if this is a key field Read the online help about scan loops and string
variables (and toss in a little reading about arrays <G>).
The problem is a little tougher if the field contains sentences or
paragraphs with multiple occurrences of GUYTEST.ZIP. One technique would be
to use tcursor.locate("fieldname","GUYTEST.ZIP") combined with a while loop
to get to all records containing GUYTEST.ZIP.
strvar.breakapart(array,"GUYTEST.ZIP") ; breaks it at GUYTEST.ZIP
for x from 1 to array.size() step 2
The usual disclaimer <g>: This is untested, off-the-top-of-my-head code.
You may have to tinker with it to get it to work. Hopefully, you will go to
the relevant sections of the online help and maybe come up with a better
way to do this. If you do, I'd be very interested in seeing it.
Hope this helps