Search Results

Try alsoawk 'NR==1 {MX=NF; for (i=NF;i>=1;i--) {if ($i=="period") break; T[i]=$i};i+=1;next}
{for (j=i; j<=NF; j++) print $1, $2, $3, $4, $5"_"T[j], $(6-i+j), _}
'...

Sorry I get you now:

awk 'NR==1 {
for (i=6;i<=NF;i++) {
h[i]=$i
}
next
}
{for (x=6;x<=NF;x++) {
print $1 OFS $2 OFS $3 OFS $4 OFS $5"_"h[x] OFS $x OFS
}
}' FS=\; OFS=\| ...

You can try this:

awk 'NR==1 {next}
{for (x=6;x<=NF;x++) {
print $1 OFS $2 OFS $3 OFS $4 OFS $5"_"substr($x,1,match($x,/[0-9]/)-1) OFS $x OFS
}
}' FS=\; OFS=\| in.csv > out.txt