I have an idea... Haven't tested it; just thinking... If you know all of the field names that have other field names which are part of them, temporarily change the larger ones, do the STRTRAN, then change them back.
Like if you have fields name and firstname. Change firstname to foo, then change name to alias.name, then change foo to alias.firstname.
It's a little klunky, but seems like it should work.
Michelle
>Hi everyone,
>
>I have some expression, which is either filter() or for() or combination of both. I'd like to insert Alias Lnd1 before each field, which may be in this expression. Example:
>
lcStr=where CODE#PARENTCODE.OR.PCOFLAG="P"
>
>I need to convert it to 'where lnd1.code#lnd1.parentcode OR lnd1.PCOFLAG="P"'
>
>I was thinking about checking this string against each field and do simple strtran, but it would not work, since I have fieldnames, which are part of other field names.
>
>Could you please help me?
>
>Thanks in advance.