>>Do you think that the strtran function can be used with wildcards?
>
>Nope.
>
>You could probably walk through it character by character to figure out what to take out. Don't be surprised if Ed Rauh gives you a solution with RegExpr.
Mike,
Thanks to everyone for their thoughts and input. This is what I finally came up with to replace the unwanted information in each field:
***replace unwanted data
use ahorse order name
locate
scan
mlen = len(alltrim(name))
for i = 1 to mlen
if substr(name,i,1) = "("
mreplace = substr(name,1,i-1)
replace name with mreplace
endif
endfor
endscan
use
return
***end of prg