Support Questions
Find answers, ask questions, and share your expertise

Data with one value per line conversation to csv not working

Solved Go to solution

Data with one value per line conversation to csv not working

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

Accepted Solutions

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

Explorer

Solved. Ihad the settings in the csv writer wrong.

View solution in original post

1 REPLY 1

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

Explorer

Solved. Ihad the settings in the csv writer wrong.

View solution in original post