#!/bin/awk -f BEGIN { FS = ","; ID = 1; getline; print "NR;NAME;TELNUM"; outputEntry("OBSLUGA KLIENTA","2601"); } { NAME = ""; NAME = appendToName(NAME, $4); # Last Name NAME = appendToName(NAME, $3); # Middle Name NAME = appendToName(NAME, $2); # First Name outputEntry(NAME, $32); # Business Phone outputEntry(NAME, $33); # Business Phone 2 outputEntry(NAME, $34); # Callback outputEntry(NAME, $35); # Car Phone } function appendToName(name, suffix) { if(name != "" && suffix != "") { name = sprintf("%s ", name); } return sprintf("%s%s", name, suffix); } function outputEntry(name, phone) { if(phone != "") { print ID ";" name ";'" phone; ID = ID + 1; } }