I once did a similar task where I had to convert a comma-delimited DVD
subtitling file to a FAB subtitle file.

I made extensive use of the find-replace function in Word, so I made a macro
to do it automatically on the files (700+ titles per movie).

The sequence I'm figuring out for you...

replace all , followed by linebrakes by </td></tr><tr><td>
then replace all remaining commas with <td></td>

Now paste some predefined header cell sequence in your word document,
together with table start and end.

Copy and paste the complete document in notepad.  Now you have clean source
code to just copy and paste in between the header and footer of your
standard HTML page...

Nice huh?


- Kayjey -


-----Oorspronkelijk bericht-----
Van: owner-hwg-techniques(at)hwg.org
[mailto:owner-hwg-techniques(at)hwg.org]Namens Regan Pride
Verzonden: woensdag 30 mei 2001 4:11
Aan: hwg-techniques(at)hwg.org
Onderwerp: Import Spreadsheet to Web page


I folks,

This is my first post to the list, so please be gentle <gr>.
I have a client who wants to put his inventory list on his web site on a
daily basis. He currently maintains the list in an MS Works spreadsheet. I
can figure out a simple way to do this from Excel (just save to html) but
Works doesn't have this function. Is there a way to populate a
table/template from a comma-delimited text file? note: my cgi skills are
limited and my java & xml skills are non-existent.

Regan
ICANTOO Enterprises
Lisbon, NH

• Web Designer Courses
• Off the Shelf Training Courses

HWG hwg-techniques mailing list archives, maintained by Webmasters @ IWA