With a Function, how can I get rid of formating codes like <di
On Mon, 1 Jun 2009 10:36:01 -0700, AFSSkier
wrote:
Ron,
Your UDF code works great, however there are still additional formatting
codes like (hard return), and &
--
Thanks, Kevin
Hit send too fast.
A bit of research reveals that your codes are designated by being between an
"&" and a ";". So we just need to remove those substrings. Again, easily done
with a slight change to the pattern:
re.Pattern = "<[^<]+|[\r\n]|&[^;]+;"
--ron
|