SQL Text Data converted to Excel

[DTHOMP]

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

[randreag]

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

[DTHOMP]

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….

[clmc9601]

Hi @DTHOMP,

Would this help?