Search Results

I thought of that as well; one gsub should suffice:awk 'FNR==NR{T[$1]=$0; gsub($1", *|, *$","",T[$1]); next} {print $0 " - " T[$1]}' FS=, file2 FS=" " file1

Perhaps a small addition to remove the training spaces and that pesky dangling `,'

wk 'FNR==NR{T[$1]=$0; gsub($1", *","",T[$1]); sub(/[, ]*$/, "", T[$1]); next} {print $0 " - " T[$1]}' FS=,...

Please use code tags as required by forum rules!

Tryawk 'FNR==NR{T[$1]=$0; gsub($1", *","",T[$1]); next} {print $0 " - " T[$1]}' FS=, file2 FS=" " file1
UNIQUENAME 2013-12-06 11:23:48.1 -...