Home / Questions / 57251
Accepted
Kevtho
Asked: 2020-03-23 11:29:25 +0800 CST 2020-03-23 11:29:25 +0800 CST

Advanced search on Linux

  • 772

I have two files, in the first a list of reports and in the second a list of companies for example.

file1.csv

20170112;compra;articulos papeleria;Papeleria Pepito
20170112;compra;tinta impresoras;Distribuidora de todito
20170214;venta;juego de sala;Perico de los palotes

file2.csv

Papeleria Pepito;/tmp/transacciones/PapeleriaPepito
Distribuidora de todito;/tmp/transacciones/DistribuidoraTodito

What I need is to go through the first file1 and if the text of the fourth column matches the first column of file 2 copy that line to the file specified in column two of the same file (col2. archive2) if there is no match it would be sent to a file in a location /tmp/others

linux

1 Answers

  1. Best Answer

    You can use 2 nested while of the type:

    # 
    while IFS=';' read uno1 dos1 tres1 cuatro1;do # IFS define el separador
         while IFS=';' read uno2 dos2;do 
##### Comparar los valore con 
              if [[ $cuatro1 == $uno2 ]]
              then ######## si son iguales ===>
              else  ######## si son diferentes
              fi
         done <archivo2.csv
done <archivo1.csv
    #

    OBS: I did not understand well what you want to do when they are the same, I hope it has helped you to shed light on your idea.

    • 1