Skip to main content
Mandrill
Gold ⭐️
February 4, 2021
Solved

Data with one value per line conversation to csv not working

Hello everyone,

 

i have data which has only one value per line, often not even a header. My goal is to conert the data to csv and format it afterwards (remove the comments and add some columns).

 

Example base data:

#This is my base data#

#################

value1

value2

value3

 

Example finished data:

value-description, source, timestamp

value1, source1, 984359345

value2, source1, 98249732

value3, source1, 984u9834

 

Right now I'm able to achieve the output if I have an input which is already in a CSV format (comma separated). But if I try is with the example data above the output is the following:

 

header-descriptionvalue1value2value3

 

This happens after the ReplaceText processor which should delete blank lines. The source and timestamp column is not yet added. This is the config of the processor:

 

I am glad about every response. 

 

Best regards

Maurice

 

 

Mandrill
MandrillAnswer
Gold ⭐️
February 8, 2021

Solved. Ihad the settings in the csv writer wrong.

1 reply

Mandrill
MandrillAuthorAnswer
Gold ⭐️
February 8, 2021

Solved. Ihad the settings in the csv writer wrong.

Translate