Change hit values

Questions
1

hi guys question
I saved hits from a config to a csv file in the following format

spoedtest;Wilhelminalaan 4, 2405 ED Alphen aan den Rijn;20
mcdmedical;Rijksweg A4 nr. 1, 2132 MA, Hoofddorp;12
leadhealthcare;Pondweg 7, 2153 PK, Nieuw-Vennep;32

When I run the config again and i get these hits (example)

spoedtest;Wilhelminalaan 4, 2405 ED Alphen aan den Rijn;25
Planjecoronatest;Hoeksteen 74-84, 2132 MS, Hoofddorp;5

I want to change the existing records and add the new record like this:

spoedtest;Wilhelminalaan 4, 2405 ED Alphen aan den Rijn;25
mcdmedical;Rijksweg A4 nr. 1, 2132 MA, Hoofddorp;12
leadhealthcare;Pondweg 7, 2153 PK, Nieuw-Vennep;32
Planjecoronatest;Hoeksteen 74-84, 2132 MS, Hoofddorp;5
2

You cant edit past hits but you can append to the same file if its not already doing that.

Just use the Append file (Utility → Files → File Append Lines)

Just format the line in whatever format you want and your all set.

3

Yes that’s not the problem I already appended the hits to a csv file. But when I run the config I want it to read that file and search for matching hits and change the value (if the hit is not matching it should just be added to the list)

4

@Ruri do you maybe know a way to solve this

5

Have no idea, sorry ^^

6

no one has found a solution? I am currently in the same problem

7

Nope I still haven’t found any solution

8

I mean you can always write a python or c# script/snippet that will preprocess the data.

Have it load the csv and check line for line matches, if match found replace and stop else append