Dynamic data import / export

datenbank

simply more productive
Up to 100,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.
  • Page:
  • 1

TOPIC: Access export to CSV carriage returns to new line

Access export to CSV carriage returns to new line 3 years 4 months ago #2302

  • Richard Barnett
  • Richard Barnett's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 4
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

Please Log in or Create an account to join the conversation.

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

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

Attachments:

Please Log in or Create an account to join the conversation.

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.

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

  • Richard Barnett
  • Richard Barnett's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 4
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.

Please Log in or Create an account to join the conversation.

Access export to CSV carriage returns to new line 3 years 4 months ago #2305

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

Please Log in or Create an account to join the conversation.

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.
  • Page:
  • 1
Moderators: FlowHeater-Team
Time to create page: 0.110 seconds