While using the Excel as a Database how we can achieve the String manipulation in SQL Query (Run command/Run Query)
Hey @hrishikesh_mali ,
Welcome to community.
You can use normal sql queries to do string manupulation.
SELECT CONCAT(first_name, ' ', last_name) AS full_name FROM Employee.
“Update [Sheetname$] set [column name]=Replace([Columnname],‘string1’,‘string2’)”
this is giving the result as excepted.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.