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: Text Process Question --

Text Process Question -- 5 years 5 days ago #2231

  • Christian Glahn
  • Christian Glahn's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 5
I need to re-organize a tab delimited file, easy right?
One of my columns will be LAST,FIRST<space>MI. is there a way to look for the , and <space> to make them separate TAB delimiters?

Also how can I insert a new column when one doesn't exist?

Thank you FH forum members. You rock!

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

Re:Text Process Question -- 5 years 4 days ago #2232

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 261
Hi Christian,

The easiest way to do that is you read your CSV file with the standard CSV delimiter comma. The field that contains two fields delimited by SPACES you have to split by yourself with the help of the String Split Heater .

In your case you need 2 String Split Heaters. On for the first column and one for the second column. The output of these two Heaters you have to move to the certain field on the WRITE side, that’s all.

I've made a brief example; please have a look to the attachment.

Your second question
) The TextFile and the Excel Adapter supports to add new columns by Drag&Drop fields to the WRITE side. It’s also possible to add new fields in the Adapter Configurator.

Database Adapter can't handle this. If you need here new fields you have to alter the table schema by yourself and read in the new table schema with the FlowHeater Designer.

Attachment two_column_separator_in_csv_file.zip not found

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.083 seconds