Repost + new thread: Replace html code with line breaks

M

mogens

In an earlier thread I got some good advise on concatenating text
strings and line break characters: Chr(13) & Chr(10)

However, I cannot make this work if I have a text string in a database
field like for instance: "This is line 1 <br>This is line 2<br>This is
line 3"

I assume it would somehow be possible to make a Replace function and get
the above to output in the report like this:

This is line 1
This is line 2
This is line 3

But exactly how should this be done?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Multiple Line handling with Split() 1
line breaks 2
Address box with IIf Statement 7
Line breaks in Excel 2
How can I find, replace and delete line breaks? 7
Problem with line breaks 1
Concatenate shows "square boxes" unknown characters at paragraph e 3
Excel Replace with line break (Excel for Mac) 0

Top