#!/bin/bash # Set the locale export LC_ALL=C.UTF-8 if ! [ -f exportphonebook_hs1.tsv ] then echo "File exportphonebook_hs1.tsv not found" exit 1 fi # Charset conversion, if any, goes here dos2unix exportphonebook_hs1.tsv # record ID (starts at 1) # name # reserved # phone number 1 # phone number 2 # phone number 3 # phone number 4 # phone number 5 # reserved # line break > "phonebook.txt" # Set IFS newline IFS=$'\n' while read LINE do #echo "${LINE}" | awk -F\\\t '{print $1 "\t" $2 "\t" $4}' echo "${LINE}" | awk -F\\\t '{print $2 "\t" $4}' >> "phonebook.txt" done < "exportphonebook_hs1.tsv" # Restore IFS IFS=$' \t\n' sort -o phonebook.txt phonebook.txt