reading text file based on line and col
I am trying to read a textt file and load the resulting data into a database. Most of the fields are static in tha first name and last name are always on lineX and colX. I would the loead the individual fields into a database, anyone done this before, how can i get started with this.
If there is a constant field separator present such as a tab, blank space, comma or something along those lines and each line is ended with a line break you should be able to read the field separator as columns and the line break as the rows.