>>
>>I'd like the analogue of strtran but with case insentitive. Anyway, I've just checked the form code and found, that I always use the same convention: SiteMstr, PropMstr, TranMstr, so this is not a problem.
>
>With strtran() this would work :
>lcString = strtran(upper(lcString), 'SITEMSTR', 'SiteMstr')
>Cetin
Cetin,
Don't understand, why do you suggest me this?
Let's describe the problem again (which turns to be not a problem, since I use the same name convention in the form, but anyway): I have a string. I want to remove something from the string (table aliases), but preserve the original string (not make it upper or low). IOW, I'd like to remove [SiteMstr.] from the string, [TranMstr.] from the string and [PropMstr.] from the string. Suppose, I don't follow the same rule in my code, so [SiteMstr] could be spelled differently:
[SITEMSTR], {Sitemstr] [sitemstr], etc. All possible variations...
I guess, only RegExp can help me here. Unfortunately, George and ED's article is still "Coming soon", and since it turns to be not a problem, I'd better wait for this article to come (Yes, I'm a lazy person]...
If it's not broken, fix it until it is.
My Blog