Skip to main content
simply more productive

The Data Specialist

Thanks to our intuitive transformation designer, you can convert data effortlessly to a variety of formats without knowing how to program. It’s not only efficient, it’s also easy to use.
Flowheater Download

Access export to CSV carriage returns to new line

  • Richard Barnett
  • Topic Author
  • Offline
  • User
  • User
More
10 years 3 months ago #2302 by Richard Barnett
Access export to CSV carriage returns to new line was created by Richard Barnett
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 to join the conversation.

More
10 years 3 months ago #2303 by FlowHeater-Team
Replied by FlowHeater-Team on topic Access export to CSV carriage returns to new line
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 to join the conversation.

  • Richard Barnett
  • Topic Author
  • Offline
  • User
  • User
More
10 years 3 months ago #2304 by Richard Barnett
Replied by Richard Barnett on topic Access export to CSV carriage returns to new line
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 to join the conversation.

More
10 years 3 months ago #2305 by FlowHeater-Team
Replied by FlowHeater-Team on topic Access export to CSV carriage returns to new line
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 to join the conversation.

Time to create page: 0.272 seconds

FlowHeater - The Data Specialist

Efficient data integration and transformation with FlowHeater – the perfect solution for a seamless transfer of your data.

Rechtliches

Support & Contact

Kontaktinformation

Telefon:0951 / 99339792 E-Mail:This email address is being protected from spambots. You need JavaScript enabled to view it.

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