#!/bin/bash
tr ";" " " < dane_1.dsv > tmp1
tr ":" " " < dane_3.dsv > tmp3
tr "!" " " < dane_2.dsv > tmp2
cut -d" " -f1 tmp3 > D
cut -d" " -f2 tmp3 > A
cut -d" " -f3 tmp3 > E
paste -d" " A D E > tmp3


join <(sort -k1  tmp1) <(sort -k1 tmp3) > nowy3
join -t" " -j2 <(sort -k2 nowy3) <(sort -k2 tmp2) >nowy4

cut -d" " -f3 nowy4 > C
cut -d" " -f5 nowy4 > E
cut -d" " -f6 nowy4 > F
cut -d" " -f4 nowy4 > D
paste -d"|" C E F D >wynik
rm C E F D nowy3 nowy4 tmp1 tmp2 tmp3 A