Dynamic data import / export

datenbank

simply more productive
Up to 10,000 records can be processed with the freeware version!
Welcome, Guest
Username: Password: Remember me
Welcome to the FlowHeater support forum.

Questions about using FlowHeater are answered here.

TOPIC: Access export to CSV carriage returns to new line

Access export to CSV carriage returns to new line 3 years 5 days ago #2302

  • Richard Barnett
  • Richard Barnett's Avatar
  • Offline
  • New Member
  • Posts: 2
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
The administrator has disabled public write access.

Access export to CSV carriage returns to new line 3 years 4 days ago #2303

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Posts: 240
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.

Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
The administrator has disabled public write access.

Access export to CSV carriage returns to new line 3 years 3 days ago #2304

  • Richard Barnett
  • Richard Barnett's Avatar
  • Offline
  • New Member
  • Posts: 2
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.
The administrator has disabled public write access.

Access export to CSV carriage returns to new line 3 years 2 days ago #2305

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Posts: 240
Hi Richard,
you're welcome. XML is planed for next year!
Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
The administrator has disabled public write access.
Moderators: FlowHeater-Team
Time to create page: 0.078 seconds