I'd like to create a macro that would edit a text file like:
into a string like:
I've used UE for years to insert the left-hand ", trim the trailing spaces, and paste the " + to the end of the line. But I'm pretty sure it should be able to create a macro to do this.
I've tried recording, but the process gets all bollixed up. If someone could post a start, I'd appreciate it.
Hint: one of my key problems is finding the end of a line to paste the " + to, and then moving to the next line.
Any suggestions are appreciated. This is a great tool, I've used it for years (since 3.5 or so) and I wouldn't be without it.
Thanks.
Code: Select all
SELECT C.CompanyName, O.OrderDate, O.OrderID, OD.UnitPrice, OD.Quantity
FROM Customers AS C INNER JOIN
Orders AS O ON C.CustomerID = O.CustomerID INNER JOIN
[Order Details] AS OD ON O.OrderID = OD.OrderID
WHERE (C.CompanyName = N'Smith')
Code: Select all
"SELECT C.CompanyName, O.OrderDate, O.OrderID, OD.UnitPrice, OD.Quantity " +
"FROM Customers AS C INNER JOIN " +
" Orders AS O ON C.CustomerID = O.CustomerID INNER JOIN " +
" [Order Details] AS OD ON O.OrderID = OD.OrderID " +
"WHERE (C.CompanyName = N'Smith') ";
I've tried recording, but the process gets all bollixed up. If someone could post a start, I'd appreciate it.
Hint: one of my key problems is finding the end of a line to paste the " + to, and then moving to the next line.
Any suggestions are appreciated. This is a great tool, I've used it for years (since 3.5 or so) and I wouldn't be without it.
Thanks.