Page 1 of 1

Import to Sheet

PostPosted: Fri Dec 05, 2014 10:34 am
by JohnG139
I need to import data from a text file exported from another program to a spreadsheet.
The text file needs to be parsed for date, last name, first name, for two players, and for a score for each record.
The Sheet has column A as 'Last', column B as 'first' and columns I through DD representing the dates into which the participants score will be entered.
Unfortunately, the program from which the data is exported cannot also export a key field for each person, necessitating parsing each data line for two participants, and scanning the sheet rows for each participant and determine the offset for the score entry.
I cannot seem to be able to paste screen shots of the text file or sheet to this post, but if you are interested in quoting for this project please email me (see my forum profile) and I can provide you with these.