Text File Parsing Into SQL
Posted on 2006-10-27
This is fairly basic. Simply, I have a few text files, databases from an old legacy system, and I need to parse through the information in these files with hundreds to thousands of lines. Each line is delimited by a certain ammount of characters until it hits the next category.
MISCF TEXT 103 0.00 0.00 0 0
ES20678XXX TEXT 125 0.00 42.95 1 0
Each field is a set ammount of characters (19, 53, 3, 10, 10, 4, 7).
My question, is how would I go about reading through the entire file, line by line and parsing each "field", as set by a certain ammount of characters per line, and then storing each field into a sql database, where each field is its own in its own record in a new table.
All help is greatly appreciated.