FlowHeater Demo Video
 
With the freeware Version up to 100.000 recordscan be processed!
FlowHeater - The Data Import / Export Specialist
DOWNLOADFreeware Version (10 MB)- No registration required -
 
Welcome, Guest
Username: Password: Remember me
Forgot your password? Forgot your username? Create an account
Support Forum
Access Adapter
Access export to CSV carriage returns to new line
See also the existing examples of using the Access Adapter , which may answer your question: CSV import , generate test data , automated batch CSV import
  • Page:
  • 1

TOPIC:

Access export to CSV carriage returns to new line 7 years 1 month ago #2302

  • Richard Barnett
  • Richard Barnett's Avatar Topic Author
  • Offline
  • Posts: 6
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 7 years 1 month ago #2303

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.
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 7 years 1 month ago #2304

  • Richard Barnett
  • Richard Barnett's Avatar Topic Author
  • Offline
  • Posts: 6
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 7 years 1 month ago #2305

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.

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
Support Forum
Access Adapter
Access export to CSV carriage returns to new line

other Languages

de

FlowHeater Home

de en

Imprint/Contact

Privacy Statement

Copyright © 2009-2021 by FlowHeater GmbH.
All rights reserved.

Follow us on

twitter  facebook

YouTube

 de en