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: Embedded return character in text field

Embedded return character in text field 6 months 3 weeks ago #3176

  • Henry Hayden
  • Henry Hayden's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 1
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 or Create an account to join the conversation.

Embedded return character in text field 6 months 3 weeks ago #3178

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 275
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-new-lines-in-field.zip
File Size: 2 KB
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.
  • Page:
  • 1
Moderators: FlowHeater-Team
Time to create page: 0.251 seconds