awk ' BEGIN{printf("adm::10:")} $0~"adm"{printf("%s,",$1)} END{printf("\n")}' masterlist > ngr sed 's/,$//' ngr > newngr rm ngr