VBScript to Parse Text File and Output to SQL
Posted on 2009-06-30
I am in need of a VBScript that will parse a text file and output the data into SQL query format.
Text file to parse will contain this data in this format:
What I am looking for is a script that will read the above text file line by line and output into a new text file that is structured in SQL format. The output would need to be the following:
('4', '5', '16', '17', '19', '20', '342', '343', '344', '346', '1768', '1769', '1770', '1772')
I can then take this data and copy it into a SQL query to update a table in the database
SET RawVolumeKey = 12
WHERE DiskFileKey IN ('4', '5', '16', '17', '19', '20', '342', '343', '344', '346', '1768', '1769', '1770', '1772')
Thanks in advance for any assistance!