Results 1 to 8 of 8

Thread: Htm2Csv.vdm : convert an html table to a csv file

Threaded View

  1. #1
    Senior Member
    Join Date
    Aug 2011
    Location
    British Columbia, Canada
    Posts
    383

    Htm2Csv.vdm : convert an html table to a csv file

    Hi Peter,

    Okay, I have written the macro, you requested. Htm2csv.vdm converts a html table to a csv file.

    To use:

    1. load html file into vedit
    2. position text cursor on a line ABOVE the line containing the table tag
    3. execute htm2csv.vdm
    4. save-as the output to a filename with a .csv extension
    5. load new csv file into MS Excel
    6. highlight all text
    7. on Home tab, select format, and then auto-fit column width
    8. on Home tab, select Find & Select, then select replace
    9. in Find what:, put [comma]
    10. in Replace with: put an actual comma symbol
    11. select Replace All
    12. save file

    You might want to copy & paste these instructions into a local text file.

    Let me know if this works for you.

    Hope others also find this useful.

    Comments, bug report, etc welcomed!

    Scott
    Attached Files Attached Files
    Last edited by Scott Lambert; March 14th, 2015 at 01:48 PM.
    Using Vedit 6.21.3, (32 bit), dated 9/12/11 running on Windows 7 (64 bit).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts