Ok, I try to explain a little bit more.
Here the code:
set -x
ft -t -k sotest1:1100!`awk '{if ($7 ~ /KAN/) { x = substr($7, 11, 27); print x;} else continue}
'pr.hoeft-jan` FT.KAU.%UNIQUE NHDRWSMb
#awk '{if ($7 ~ /KAN/)
# { x = substr($7, 11, 27); y = substr($7, 1, 3);
# print "ft -t...