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

Embedded return character in text field

  • Henry Hayden
  • Topic Author
  • Offline
  • User
  • User
More
6 years 11 months ago #3176 by Henry Hayden
Embedded return character in text field was created by Henry Hayden
I'm trying to import a CSV file into SQL Server, but the text file adapter has a problem with a text field with an embedded return character. When I configure the text file adapter, and view the records in column mode, I can immediately see that the first record has the wrong data in the first column. Every succeeding column header has the wrong name, as well.

I can see that an address field is actually a multi-line memo field that allows for entering return characters. I can proceed no further. Choosing any other column delimiter does not help. Is this a bug, or is there a workaround?

Please Log in to join the conversation.

More
6 years 11 months ago #3178 by FlowHeater-Team
Replied by FlowHeater-Team on topic Embedded return character in text field
Hi Henry,

FlowHeater support also new lines in CSV field content. This option ist not activated in the standard settings by default. To enable this you just have to oben the READ TextFile Adapter configurator and switch to the tab “Advanced”. Here you´ll find the option “Allow line breaks in column data”.
In the attached ZIP Archive you´ll find a short example.



File Attachment:

File Name: csv-import...ield.zip
File Size:2 KB

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.

Time to create page: 0.289 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.