Hello,
I have some data in a text file I want to process and insert into a database. It's in the format of several columns that are separated by whitespace. Some columns do not have any values. This is where my problem is. I can't figure out how to parse the data so I can insert the values from the columns that do have values into the corresponding columns in the database. Below is a link to the file I want to parse. Can someone please give me some advice on how to do something like this? Thanks!