Hi - hopefully someone of you can help me here.<br><br>I managed to be able to convert a table to kvtml2 for KHangMan, but part of the work is still being done manually and having many "categories" that takes loads of time.<br>
<br>What I am doing now is deleting rows manually. I know now how to delete the first column in a .csv file from comand line and therefore there must be such a "cut" command to delete lines as well.<br><br>Example of the csv:<br>
<br>ID;source;category;target1;target2; etc.<br>1;cat;animal,Katze;gatto; etc.<br>2;dog;animal;Hund;cane; etc.<br>3;Germany;country;Deutschland;Germania; etc.<br>4;Italy;country;Italien;Italia; etc.<br>5;bread;food;Brot;pane; etc.<br>
6;potatoe;food;Kartoffel;patata; etc.<br><br>now what I need is a command that cuts all lines where column 3 does not correspond to <category name><br><br>Can anyone help with that?<br><br>This can be a command line or python script - in the end it does not make any difference. I am now using a .sh file to execute the various scripts or commands one after the other to get the final files I need.<br>
<br>I know this can be resolved in a more elegant way, but actually: for me only the result counts, not how elegant and nice the script is that I use.<br><br>Thanks in advance!<br><br>Cheers, Sabine<br>