Data with one value per line conversation to csv not working

Mandrill — Thu, 04 Feb 2021 09:51:59 GMT

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

Re: Data with one value per line conversation to csv not working

Mandrill — Mon, 08 Feb 2021 18:57:39 GMT

Solved. Ihad the settings in the csv writer wrong.

question Data with one value per line conversation to csv not working in Support Questions

Data with one value per line conversation to csv not working

Re: Data with one value per line conversation to csv not working