[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