Support Questions

Find answers, ask questions, and share your expertise

Data with one value per line conversation to csv not working

avatar
Explorer

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

 

 

1 ACCEPTED SOLUTION

avatar
Explorer

Solved. Ihad the settings in the csv writer wrong.

View solution in original post

1 REPLY 1

avatar
Explorer

Solved. Ihad the settings in the csv writer wrong.