Access export to CSV carriage returns to new line

Hi
I am having trouble exporting data from a memo field in Access 2007 to csv. FlowHeater creates a new record whenever the data has a carriage return.

Is there any way to remove or replace the carriage return?

I have tried replacing Chr(10) and Chr(13) but no difference. I have also tried to export to Excel but I get the same result. No problems manually exporting from Access.

Foe example this data...
DR3115 Brother Drum for:<BR>
<li>HL5240 and HL5250dn
<li>MFC8460n, MFC8860dn

...will create 3 separate records.

Can anyone help?

Thank you

Hi Richard,

With the help of the String Replace Heater you can replace Carriage Return / Line Feeds before output to your CSV file. In case you just want to remove Chr(10) and Char(13) you have to leave the Replace field empty.

Hi That fixed it thank you. Simple!

By the way I love Flow Heater - a very useful tool although native XML support would be useful.

Hi Richard,
you're welcome. XML is planned for next year!