[librecat-dev] Catmandu and general csv manipulation use case example
aina at openmailbox.org
aina at openmailbox.org
Thu Sep 15 10:56:48 CEST 2016
Dear community,
looking for a way to achieve the below task with a fix:
columnA,columnB,columnC
namea1,namea1,newnamea1
namea2,namea2,newnamea2
namea3,namea3,newnamea3
namea1
namea2
namea3
namea1
namea2
namea3
namea1
namea2
....................
for each value found in columnA, we need to find it in columnB, and then
replace this value found, with what exists in the same row, in columnC.
Columns B and C, are the "map", where we need to lookup for
the result will be a new column, like below
newnamea1
newnamea2
newnamea3
newnamea1
newnamea2
newnamea3
newnamea1
newnamea2
newnamea3
newnamea1
newnamea2
Thank you in advance for any help,
best
More information about the librecat-dev
mailing list