Parsing text with VBA
-
Hello all, I received a .csv file containing the HTML code generated from running a web-based report. I need to parse the file to get rid of all the HTML, leaving only the viewable text. I would like to just run a macro to perform this but if someone knows another way, say in VB.Net, that will be fine also. Unfortunately I cannot attach the file due to the sensative nature of the data. Thanks in advance for any help provided. Mark Oium Mark Oium
-
Hello all, I received a .csv file containing the HTML code generated from running a web-based report. I need to parse the file to get rid of all the HTML, leaving only the viewable text. I would like to just run a macro to perform this but if someone knows another way, say in VB.Net, that will be fine also. Unfortunately I cannot attach the file due to the sensative nature of the data. Thanks in advance for any help provided. Mark Oium Mark Oium
simple answer: copy the .csv to a backup file open the copy in word and find/Replace "," with " ". then rename the file extension to .html then open it with your favorite browser. if the information displays as desired, copy out the desired text (cntrl + a or Shift + End help a lot) and paste it into another word or text document. that should work... as for an script or applet, that would take some time and trouble. depending on the html, it would probably be quite dificult to define all the things you need to strip out. probably longer than editing it cy hand... hey...slang is the vernacular for the vernacular...wow