Hi there, when I run the following Mysql query
"
Update [Sheet1$]
Set url =replace(url,‘//www’,‘www’)
"
I get : Execute query : Undefined function ‘replace’ in expression.
Whats the correct syntax ?
I am using Microsoft.ACE.OLEDB.12.0.
Since Uipath is 32-bit, I am using 32bit Microsoft.ACE.OLEDB.12.0. from office 2007. I also have 64bit Winautomation installed on the same machine with 64 bit Microsoft.ACE.OLEDB.12.0 for office 2010 and it works fine with mysql replace function.
I think the problem is , that uipath sees replace as a VB function and not Mysql function.
Thanks