Hi,
I have many text files with SQL Script that I would like to get into an excel spreadsheet. I was thinking if I removed the line returns and added a "|", giving me the ability to parse the data where needed. It is isn't working, does anyone have any Idea or is this is even possible?
The attached excel is I would like to see from the txt file
Thank you
Hi @DTHOMP
I attached an example of how you can deal with the first fields, you need to do some fixes but I think could work
I hope it helps
Thanks, this isn't giving what I was looking for. I'd like column 1 to be all of the code for "Update" column 2 for "Set" etc. I was just reading about the XML_Parse think this might but I can't figure out how to break the records
Field_1
1 <Root>
<1child>
<UPDATE>UPDATE CBD</UPDATE>
SET <SETa> SF = 25</SETa>
WHERE <Billing ID>BillingID = @BILLID</Billing ID>
AND <Billing Type>BillingType = 0</Billing Type>
</1child>
<UPDATE>UPDATE CBD</UPDATE...
2 NUMERIC) + ( NumParcels - 2 ) * 5
END
WHERE BillingID = @BILLID
AND BillingType = 0
AND currentls = 88
AND LId IN (SELECT LP.l_id
FROM LP
INNER JOIN County
ON LP.County_Id = County….