>>>Hi everyone,
>>>
>>>I have this problem: my application returns a string which is form of where condition, e.g.
>>>
>>>"SiteMstr.ccode='01' and inslist(TranMstr.Lender,code1, code2) and etc."
>>>
>>>We're going to implement Data Warehouse algorithm, and therefore, I want to exclude all references to Table aliases from this string. The tables are limited to just three (may be four):
>>>SiteMstr
>>>TranMstr
>>>PropMstr
>>>
>>>My problem is that I don't know, how did I spell it, e.g. it could be:
>>>Sitemstr
>>>SITEMSTR
>>>SiteMStr
>>>etc.
>>>
>>>Of course, since it's my application, I can go through the form code, and use just one name convention everywhere, like "SiteMstr", but I'd like to know, perhaps there is more elegant solution.
>>>
>>>I guess, RegExp should help me here, but I don't know, how to use it in this case.
>>>
>
>

oRegExp = CREATEOBJ('VBScript.RegExp')
>oRegExp.Global = .t.                 && translate all occurances
>oRegExp.IgnoreCase = .t.             && case insensitive
>oRegExp.Pattern = '\b\w{4}MSTR\.(.)' && word boundary, followed by 4 word chars
>                                     && followed by MSTR., followed by any char
>                                     && other than a newline, remembered as $1
>cTranslate = oRegExp.Replace("SiteMstr.ccode='01' and inslist(TranMstr.Lender,code1, code2) and etc.",'$1')
>? cTranslate

>
>>>Thanks a lot in advance.
>>
>>Nadya,
>>What does case differ ? IOW how would you use it ? In something like atc() or find&replace ?
>>In a string operation you could combine atc() and stuff().
>>Cetin


Great. I hoped you'd help me. Thanks a million (Even if it turns to be not a problem) :)