Any utilities to remove the ALL the Microsoft formatting tags?

  • Thread starter Thread starter Shiperton Henethe
  • Start date Start date
Shiperton said:
Sounds promising but - Gad streuth!! - I cant understand
what the heck I'm looking at...

I downloaded something called tidy.exe, and when I ran
it all I got was a big black box. With a flashing cursor
in it...

Maybe I'm too stupid to use this thing...
What do I download for msWindows2000 (and WinXP)?!
Click to expand...

The original tidy is a command line program. There is a windows GUI
version downloadable at
http://perso.wanadoo.fr/ablavier/TidyGUI/TidyGUI-exe.zip

You should be able to download this, unzip it, and run the program. Then
load your exported HTML, then click 'Tidy!'. It will tell you what it's
done - but not make the changes to your original until you click 'replace'.

Hope that helps,

Ian M

PS - apologies for top-posting earlier - i don't know what came over me!
 
Shiperton said:
Sounds promising but - Gad streuth!! - I cant understand
what the heck I'm looking at...

I downloaded something called tidy.exe, and when I ran
it all I got was a big black box. With a flashing cursor
in it...

Maybe I'm too stupid to use this thing...
What do I download for msWindows2000 (and WinXP)?!


Ship
Shiperton Henethe
Click to expand...

The original tidy is a command line program. There is a windows GUI
version downloadable at http://users.rcn.com/creitzel/tidy/tidyui.zip

You should be able to download this, unzip it, and run the program. Then
load your exported HTML, then click 'Tidy!'. It will tell you what it's
done - but not make the changes to your original until you click 'replace'.

Hope that helps,

Ian M

PS - apologies for top-posting earlier - i don't know what came over me!
 
Shiperton Henethe said:
Know any good utilities to help me strip out the tags that
Microsoft Excel 2002 leaved behind when you try
and export an HTML format file?
Click to expand...

This is Office 2000 HTML Filter 2.0.

"The Office HTML Filter is a tool you can use to remove
Office-specific markup tags embedded in Office 2000 documents saved as
HTML."

I don't know how it works.
Made by MS, so don't expect miracles.
http://office.microsoft.com/downloads/2000/Msohtmf2.aspx

You can also use HTML Tidy.
http://www.w3.org/People/Raggett/tidy/

altamir
 
Matthias Gutfeldt said:
Yes, you can import csv into DW4.
And don't mix up CVS (Concurrent Versions System) with CSV (Comma
Separated Value file format).
Click to expand...

No that's the whole point. It crashes my DW4!
(Even on small files...)
You could try the Microsoft Office2000 HTML filter
<http://office.microsoft.com/Assistance/2000/htmlfilter.aspx>: It allows
you to "export to compact HTML", and after that you can run a
customizable filter over your file to remove even more fluff.
Click to expand...

Is that safe to run in Office 2002?!
Have Micro$oft genuinely neither built it into Office2002
nor created a filter for 2002? Pah! :-[

But 2500 rows of data in one HTML file seems a bit excessive. Can't you
put that in a database and then only show e.g. 10, 20, 50, or 100 sets
at a time?
Click to expand...
Nope!


Ship
 
William Tasso said:
d/w and pre-procesing editors have been covered elsewhere in this thread.
Which server-side facilities do you have available?
Click to expand...
None.
Client side only.

what are you trying to achieve with this? surely not display 2,500 rows on
one page?
Click to expand...
Yes. Why not?!
We are trying to make a point about how many successful bids have
been made on our site. If our customers REALLY want to see them all
then that's fine we let them. The first 100 or so are in their own
table so the appear first...

Ship
 
Shiperton said:
None.
Client side only.
pity

Yes. Why not?!
We are trying to make a point about how many successful bids have
been made on our site. If our customers REALLY want to see them all
then that's fine we let them. The first 100 or so are in their own
table so the appear first...
Click to expand...

it can be good to shine a little light on your successes but 2,500 rows
seems a little OTT - but it's your site ;o)
 
The original tidy is a command line program. There is a windows GUI
version downloadable at http://users.rcn.com/creitzel/tidy/tidyui.zip

You should be able to download this, unzip it, and run the program. Then
load your exported HTML, then click 'Tidy!'. It will tell you what it's
done - but not make the changes to your original until you click 'replace'.

Hope that helps,
Click to expand...

I tried this (twice) but for some reason it didnt change anything
when I saved it. (I am using win2K)

Ship
 
I tried to use Dreamweaver MX 2004 to clean a html file produced from Excel
and it said "Nothing to clean up!". If there are no redundant or empty
tags, a cleanup utility won't be of much help. Excel produces verbose html
which is still valid.
Click to expand...

Aaaaaaaaaaaaaaaarrrrrrrrrrggggggggghhhhhhhhhhh!! >>>:-[

Is it just me?

This kind of persistent Microsoft-dominate-the-planet
-and-screw-who-is-inconvenienced (by having to
download bloated HTML...)

....makes me so cross I can scarely speak.

Gads!

If they want to take over the planet
all I can say is that they need to
do so a damned site more ethically.

Frankly it's the sort of thing that spawns terrorists.

Ship
 
Nick Kew said:
AccessValet will do it for you. I wouldn't normally recommend it over Tidy
for this particular task, but it does come with a full GUI:-)

http://valet.webthing.com/access/
Click to expand...

As far as I can tell it cost GBP 40 or 60.

Am I mad or deranged or something?
But I find it somehow sticks in my gullet to
have to lash out hard earnt cash
simply because Microsoft are scr*wing us.

They obviously felt guilty enough to produce
a compact HTML version for Office 2000 but
guess what? No Office 2002 version!

Those b*st*rds!


Ship
Click to expand...
 
Shiperton Henethe said:
Hi

Know any good utilities to help me strip out the tags that
Microsoft Excel 2002 leaved behind when you try
and export an HTML format file?
Click to expand...

I just add new columns with the HTML codes and save as a tab-separated text
file.

In other words, I add a new column 'A' and each cell in that column is
"<tr><td>". Skip one column, insert another that contains "</td><td>" on
each line and add another at the end... "</td></tr>". Save as a text file
and it's easy to work with.
 
one of infinite monkeys said:
As far as I can tell it cost GBP 40 or 60.
Click to expand...

Indeed, and I said I wouldn't normally recommend it over Tidy for
this particular task - which is the primary function of Tidy but a
secondary function of AccessValet.
But I find it somehow sticks in my gullet to
have to lash out hard earnt cash
simply because Microsoft are scr*wing us.
Click to expand...

Huh? So you're happy to fork out large sums to Microsoft for defective
software[1], but not to a third party to fix it? Does that extend to
embracing M$'s viruses and refusing to use any antivirus?
Those b*st*rds!
Click to expand...

Can't help that.

[1] unless you're proclaiming yourself a pirate?
 
Nick said:
So you're happy to fork out large sums to Microsoft for defective
software[1], but not to a third party to fix it?
Click to expand...

Though I'm loath to come to the defense of MS, I think it fair to
point out that producing html is a secondary feature of Excel. One
might, thus, fork over money for a functioning spreadsheet program,
and be disappointed with its support for html. Note that I do believe
you should be paid for your work. That is not the issue.
 
S.T. said:
I just add new columns with the HTML codes and save as a tab-separated text
file.

In other words, I add a new column 'A' and each cell in that column is
"<tr><td>". Skip one column, insert another that contains "</td><td>" on
each line and add another at the end... "</td></tr>". Save as a text file
and it's easy to work with.
Click to expand...

Clever. And since Excel lets you hide columns, it can still be a
functioning worksheet.
 
Back
Top