supergg02 Posted December 3, 2004 Posted December 3, 2004 (edited) Please, is there a way to convert html table to a csv file ? somme think like this Func html_To_csv ($The_given_url, $separator,$output_csv_file) ; URLDownloadToFile($The_given_url, $html_file) $htmlCode=FileRead($html_file, FileSize($html_file)) ..scan engine... for each html table <Table> take only Cells values and separate tem with $separator ";" ........ Endfunc Edited December 3, 2004 by supergg02
Wolvereness Posted December 4, 2004 Posted December 4, 2004 I have a question, can you read? your in the scripts/scraps forum, and when you pressed the button it said "this is not a general support forum" And to answer your question, you need to get very creative. Yes it is possible though, but you need to extract the table from the rest of the html first. Something you need to check though is amke sure a table is not nested when doing this. Offering any help to anyone (to my capabilities of course)Want to say thanks? Click here! [quote name='Albert Einstein']Only two things are infinite, the universe and human stupidity, and I'm not sure about the former.[/quote][quote name='Wolvereness' date='7:35PM Central, Jan 11, 2005']I'm NEVER wrong, I call it something else[/quote]
supergg02 Posted December 4, 2004 Author Posted December 4, 2004 thinks for "help" i'll never ask other think. bye
scriptkitty Posted December 4, 2004 Posted December 4, 2004 Side note, for stripping tags it gets messy. <td> usually starts a collum, and <tr> ends a line/starts a new row. you will have to take into consideration colspan and rowspan, and all the other useless things like <td width="100"> and such. All these can be done, and are not that hard, but have to be taken into account.I usually parse out just the table I need (find what is between <table and </table.)Next I stringsplit by <if stringleft($infoline,2)="td" then; new collum$infoline=stringtrimleft($infoline,Stringintr($infoline,">")); finish off on your ownwell ya get the approach.honestly I do most of these with a regular expression editor to save time. AutoIt3, the MACGYVER Pocket Knife for computers.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now