macro for parsing text



Hello. I have a very large .csv file (90 columns, 1396 rows) that was
converted from running a web report. The .csv file contains all the
HTML tags from the web report. I have tried using find/replace using <
* > (a wildcard between opening and closing tags) and replacing all
with a blank but I get a "Formula is too long" error. I want to write a
macro to accomplish this and hopefully get past the error message. Many
of the cells have numerous HTML tags in them. I am relatively new to
macros and any help, even a push in the right direction, would be
appreciated. Thanks in advance for any guidance provided. -Mark

.



Relevant Pages

  • grab html table[s] from html to files
    ... convert to a csv file per table. ... is in fact oratclsh that comes with oracle 9.2 ... ... This filters out all html tags, what is nice for the last part. ...
    (comp.lang.tcl)
  • Re: HTML tag encoding
    ... If you open the CSV file in a text editor are all the HTML tags in there? ... are you sure it's the DTS import process that's stripping your HTML ...
    (microsoft.public.sqlserver)
  • CSV and random from elements
    ... shuffle; $show = implode; include; //contains html tags and form tag ... The problem is that I have a header in the CSV file BUT .. ... I have no idea how to put the form elements value into the proper column of the csv file ...
    (alt.php)