Quote Originally Posted by rorya View Post
You can shorten somewhat by only translating the characters in each criterion - for example:

contains(translate(., 'AITU', 'aitu'),'auti')
rather than:

contains(translate(., 'ABCDEFGHIJKLMNOPQRSTUVWXYZ', 'abcdefghijklmnopqrstuvwxyz'),'auti')
Unfortunately XPath 1 doesn't allow things like matches()


Translation for each stub worked very good, but excel have there length limitation.
I think Xpath can help, but I dont know how