Re: Combine Text Files

On Wed, 18 May 2016 17:17:49 +0300, "Ufuk YILDIRIM
[email protected] [sed-users]" <[email protected]> wrote:

> fileA.txt
> 
> 
> ID111;a;a;a;a;a;a;a;a;a
> ID222222;a;a;a;a;a;a;a;a;a
> ID3333;a;a;a;a;a;a;a;a;a
> 
> 
> FileB.txt
> 
> 
> ID111;b;b;b;b;b;b;b;b;b;b;b;b;b;b;b
> ID44;b;b;b;b;b;b;b;b;b;b;b;b;b;b;b
> ID3333;b;b;b;b;b;b;b;b;b;b;b;b;b;b;b
> ID555;b;b;b;b;b;b;b;b;b;b;b;b;b;b;b
> 
> 
> 
> 
> result.txt
> ID111;a;a;a;a;a;a;a;a;a;b;b;b;b;b;b;b;b;b;b;b;b;b;b;b
> ID222222;a;a;a;a;a;a;a;a;a
> ID3333;a;a;a;a;a;a;a;a;a;b;b;b;b;b;b;b;b;b;b;b;b;b;b;b
> ID44;b;b;b;b;b;b;b;b;b;b;b;b;b;b;b
> ID555;b;b;b;b;b;b;b;b;b;b;b;b;b;b;b

A possible approach with (GNU) sed:

sed '

:a

$!{
  N
  ba
}

s/$/\n/

:loop
s/\(ID[^;]*;\)\([^\n]*\)\n\(.*\)\1\([^\n]*\)\n/\1\2;\4\n\3/
t loop

s/\n$//' filea.txt fileb.txt


Another way is with awk:

awk -F';' -v OFS=';' '
  NR==FNR{
    id=$1; sub(/^[^;]*;/, ""); a[id]=$0; next
  }

  {
    id=$1; sub(/^[^;]*;/, ""); sep=(id in a)?";":""; a[id]=a[id] sep $0
  }

  END {
    for (id in a) {
      print id";"a[id]
    }
  }
' filea.txt fileb.txt


-- 
D.