it appears that there are more than 1 carriage returns in your document, and you're only trying to replace 1.. actually only:

<td>
</td>

when maybe you should be replacing <td>#chr(13)##chr(13)##chr(13)#</td> for

<td>

</td>

how bout instead of chr(13) just use a physical cr ...

line = replace(document, '
', '', 'ALL')#

you could also run the above through the whole document. this would essentially out all the html on 1 line, then go through and replace close tags with a close tag and a line feed.

i think you could also use mid or a regex to get the data between <td> and </td> and trim it.

just some ideas.

joe
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to