You can use the following awk script awk -F"|" '{ print $1"|"$2"|#"$3 }' <sites_file_name> to get the file for s.surf.tps Nalneesh Gaur