Web Hosting Talk







View Full Version : html to text format


hoachen
04-20-2006, 01:54 PM
Hey, guys
I know this forum is not for my question here but i have no idea where i should post my question.

Here is what i want to do.
I have a folder that have over a 500+ html pages and I would like to copy all of html page name and put them into spreadsheet. It doesn't matter still keep the link or not. I just want to have all of 500+ html name in my spreasheet.

I don't want to have it copy one by one of every html page name, it is tedious to do and i am wondering someone have a advice and help me with this.

cheers
hoachen

Phil Mossop
04-20-2006, 02:32 PM
You could write a small script to find all HTML files and put them into a CSV format then simply import this CSV file to Excel.

hoachen
04-20-2006, 07:53 PM
that's good idea, but i don't know how to write the script! Anywhere I can find the similar script that I can use to do the task i want?


You could write a small script to find all HTML files and put them into a CSV format then simply import this CSV file to Excel.

TonyEmpire
04-20-2006, 08:05 PM
Yeah how would u do that?

foobic
04-20-2006, 08:59 PM
cd [folder]
ls --format=single-column *.html >filelist.csv