Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

I've developed a procedure to expor

Status
Not open for further replies.

Phydos

Programmer
Oct 5, 2002
16
GB
I've developed a procedure to export our products (CDs/DVDs..) to html files using .writeline(recordset("Artist_Name"). However, I would like to optimise the html files by removing the 'new lines'

i.e. change:
BLINKIT<br>
BLISZ<br>
BLIT<br>
BLONDES<br>
BLONDIE<br>

to:
BLINKIT<br>BLISZ<br>BLIT<br>BLONDES<br>BLONDIE<br>

writeline always inserts the text (each product) on a new line; does anyone have any ideas if there is another command I can use to simply append the text without a new line?

There are several hundred thousand products on our database, so this should make quite a difference to file size.

Best regards,
Phydos music & media
phydos-music.gif

 
Thanks; I decided to write 50 artists at a time to an array, then use writeline to insert them (50 on each line) into the html file.

It works well now, and the files are optimised quite nicely - very small considering the amount of information in them.

We have hundreds of thousands of CDs, DVDs and MiniDiscs at Phydos, so I'm using writeline to generate the list of artists we stock (should help with the search engines & for customers) – see the result at
Best regards,
Phydos music & media
phydos-music.gif

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top