How do you parse a time variable from database?

parse a text file into an excel database

• I need someone to parse the data in this list to an excel database: http://www.massbio.org/members/detail.php?mode=multi Thanks!

• Answer:

  Thanks...I'm glad that worked for you. Make sure to save the file to your local system, as the link I gave is not permanent. As for how I did it, that's hard to explain. I've collected a number of text handling/management software programs over the years with various odds n' end capabilities. I was able to copy the text into a text editor, and use some 'clean up' functions to remove blank lines. Then I followed with a number of search-and-replace operations to put commas in at strategic places in the text, so I could treat it as comma-delimited file. Then, I imported it into Excel, and did some further work with a series of text-based add-ins from a program called ASAP. If I had it to do over again, I wouldn't use the comma-delimited step, and there were too many other commas in the text, and that's what led to some problems. Live and learn, eth? Have a good holiday, paf