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