Basic usage

sed 's/|/ /g' irs1_CDFS1.tbl | sed 's/none/S\/N 00/' > irs1_CDFS1.tbl_mod
/home/akiyama/clfiles/SPECVIEW/spec_view irs1_CDFS1.tbl_mod irs1_CDFS1_lrypbw.fits irs1_CDFS1_agn.res irs1_CDFS1_agn.ps

--- irs1_CDFS1_agn.res format ---
Name1 Name2 Redshift ID NOTE
SDS0_1183 SDS0_1183 1.916 NEM OLDID
SDS0_1184 SDS0_1184 1.432 NEM OLDID

Name1 will be matched with the name in the .tbl file

Memo
-----------------------------------------------------

sed 's/|/ /g' irs1_SXDS7.tbl | grep AGNs > irs1_SXDS7.tbl_agn
sed 's/|/ /g' irs1_SXDS7.tbl | grep SWRS >> irs1_SXDS7.tbl_agn
sed 's/|/ /g' irs1_SXDS7.tbl | grep SXDS3_84623 >> irs1_SXDS7.tbl_agn
sed 's/|/ /g' irs1_SXDS7.tbl | grep SXDS3_116505 >> irs1_SXDS7.tbl_agn
sed 's/|/ /g' irs2_SXDS7.tbl | grep AGNs > irs2_SXDS7.tbl_agn
sed 's/|/ /g' irs2_SXDS7.tbl | grep SWRS >> irs2_SXDS7.tbl_agn
/home/akiyama/clfiles/SPECVIEW/spec_view irs1_SXDS7.tbl_agn irs1_SXDS7_lrypbw.fits ../Xray_summary irs1_SXDS7_agn.ps
/home/akiyama/clfiles/SPECVIEW/spec_view irs2_SXDS7.tbl_agn irs2_SXDS7_lrypbw.fits ../Xray_summary irs2_SXDS7_agn.ps
sed 's/|/ /g' irs1_SXDS7.tbl | awk -f ../format_tbl.awk > tmp
sed 's/|/ /g' irs2_SXDS7.tbl | awk -f ../format_tbl.awk >> tmp
/home/akiyama/clfiles/SXDS/merge_cat /home/akiyama/SXDS/figures/Xraymaster_ID tmp 17 2 1.0 0 | awk '{if(index($19,"SDS")==0) print $0}' 

sed 's/|/ /g' irs1_SXDS8.tbl | grep AGNs > irs1_SXDS8.tbl_agn
sed 's/|/ /g' irs1_SXDS8.tbl | grep SWRS >> irs1_SXDS8.tbl_agn
sed 's/|/ /g' irs2_SXDS8.tbl | grep AGNs > irs2_SXDS8.tbl_agn
sed 's/|/ /g' irs2_SXDS8.tbl | grep SWRS >> irs2_SXDS8.tbl_agn
sed 's/|/ /g' irs1_SXDS8.tbl | grep UDS-NBH-double13 >> irs1_SXDS8.tbl_agn
sed 's/|/ /g' irs2_SXDS8.tbl | grep AzTEC022.2 >> irs2_SXDS8.tbl_agn
sed 's/|/ /g' irs2_SXDS8.tbl | grep SXDS1_25425 >> irs2_SXDS8.tbl_agn
/home/akiyama/clfiles/SPECVIEW/spec_view irs1_SXDS8.tbl_agn irs1_SXDS8_lrypbw.fits ../Xray_summary irs1_SXDS8_agn.ps
/home/akiyama/clfiles/SPECVIEW/spec_view irs2_SXDS8.tbl_agn irs2_SXDS8_lrypbw.fits ../Xray_summary irs2_SXDS8_agn.ps
sed 's/|/ /g' irs1_SXDS8.tbl | awk -f ../format_tbl.awk > tmp
sed 's/|/ /g' irs2_SXDS8.tbl | awk -f ../format_tbl.awk >> tmp
/home/akiyama/clfiles/SXDS/merge_cat /home/akiyama/SXDS/figures/Xraymaster_ID tmp 17 2 1.0 0 | awk '{if(index($19,"SDS")==0) print $0}' 

sed 's/|/ /g' irs1_SXDS3.tbl | sed 's/Dummy BS target for/Dummy:/' | grep AGNS > irs1_SXDS3.tbl_agn
# SDS0_0088
sed 's/|/ /g' irs1_SXDS3.tbl | sed 's/Dummy BS target for/Dummy:/' | grep nbH-03 >> irs1_SXDS3.tbl_agn
sed 's/|/ /g' irs2_SXDS3.tbl | sed 's/Dummy BS target for/Dummy:/' | grep AGNS > irs2_SXDS3.tbl_agn
# SDS0_0040
sed 's/|/ /g' irs2_SXDS3.tbl | sed 's/Dummy BS target for/Dummy:/' | grep AzTEC42 >> irs2_SXDS3.tbl_agn 
# SDS0_0051
sed 's/|/ /g' irs2_SXDS3.tbl | sed 's/Dummy BS target for/Dummy:/' | grep H2S1-54395 >> irs2_SXDS3.tbl_agn
# SDS0_1379
sed 's/|/ /g' irs2_SXDS3.tbl | sed 's/Dummy BS target for/Dummy:/' | grep SXDS3_67966 >> irs2_SXDS3.tbl_agn
/home/akiyama/clfiles/SPECVIEW/spec_view irs1_SXDS3.tbl_agn irs1_SXDS3_lrypbw.fits ../Xray_summary irs1_SXDS3_agn.ps
/home/akiyama/clfiles/SPECVIEW/spec_view irs2_SXDS3.tbl_agn irs2_SXDS3_lrypbw.fits ../Xray_summary irs2_SXDS3_agn.ps
sed 's/|/ /g' irs1_SXDS3.tbl | sed 's/Dummy BS target for/Dummy:/' | awk -f ../format_tbl.awk > tmp
sed 's/|/ /g' irs2_SXDS3.tbl | sed 's/Dummy BS target for/Dummy:/' | awk -f ../format_tbl.awk >> tmp
/home/akiyama/clfiles/SXDS/merge_cat /home/akiyama/SXDS/figures/Xraymaster_ID tmp 17 2 1.0 0 | awk '{if(index($19,"SDS")==0) print $0}' 

sed 's/|/ /g' irs1_SXDS5.tbl | grep AGNs > irs1_SXDS5.tbl_agn
sed 's/|/ /g' irs1_SXDS5.tbl | grep SWRS >> irs1_SXDS5.tbl_agn
/home/akiyama/clfiles/SPECVIEW/spec_view irs1_SXDS5.tbl_agn irs1_SXDS5_lrypbw.fits irs1_SXDS5_agn.ps

sed 's/|/ /g' irs1_SXDS6.tbl | grep AGNs > irs1_SXDS6.tbl_agn
sed 's/|/ /g' irs1_SXDS6.tbl | grep SWRS >> irs1_SXDS6.tbl_agn
sed 's/|/ /g' irs2_SXDS6.tbl | grep AGNs > irs2_SXDS6.tbl_agn
sed 's/|/ /g' irs2_SXDS6.tbl | grep SWRS >> irs2_SXDS6.tbl_agn
/home/akiyama/clfiles/SPECVIEW/spec_view irs1_SXDS6.tbl_agn irs1_SXDS6_lrypbw.fits irs1_SXDS6_agn.ps
/home/akiyama/clfiles/SPECVIEW/spec_view irs2_SXDS6.tbl_agn irs2_SXDS6_lrypbw.fits irs2_SXDS6_agn.ps

sed 's/|/ /g' irs1_SXDS9.tbl | grep AGNs > irs1_SXDS9.tbl_agn
sed 's/|/ /g' irs1_SXDS9.tbl | grep SWRS >> irs1_SXDS9.tbl_agn
sed 's/|/ /g' irs2_SXDS9.tbl | grep AGNs > irs2_SXDS9.tbl_agn
sed 's/|/ /g' irs2_SXDS9.tbl | grep SWRS >> irs2_SXDS9.tbl_agn
sed 's/|/ /g' irs2_SXDS9.tbl | grep double11 >> irs2_SXDS9.tbl_agn
/home/akiyama/clfiles/SPECVIEW/spec_view irs1_SXDS9.tbl_agn irs1_SXDS9_lrypbw.fits ../Xray_summary irs1_SXDS9_agn.ps
/home/akiyama/clfiles/SPECVIEW/spec_view irs2_SXDS9.tbl_agn irs2_SXDS9_lrypbw.fits ../Xray_summary irs2_SXDS9_agn.ps
sed 's/|/ /g' irs1_SXDS9.tbl | awk -f ../format_tbl.awk > tmp
sed 's/|/ /g' irs2_SXDS9.tbl | awk -f ../format_tbl.awk >> tmp
/home/akiyama/clfiles/SXDS/merge_cat /home/akiyama/SXDS/figures/Xraymaster_ID tmp 17 2 1.0 0 | awk '{if(index($19,"SDS")==0) print $0}' 

sed 's/|/ /g' irs1_SXDS10.tbl | grep AGNs > irs1_SXDS10.tbl_agn
sed 's/|/ /g' irs1_SXDS10.tbl | grep SWRS >> irs1_SXDS10.tbl_agn
sed 's/|/ /g' irs2_SXDS10.tbl | grep AGNs > irs2_SXDS10.tbl_agn
sed 's/|/ /g' irs2_SXDS10.tbl | grep SWRS >> irs2_SXDS10.tbl_agn
/home/akiyama/clfiles/SPECVIEW/spec_view irs1_SXDS10.tbl_agn irs1_SXDS10_lrypbw.fits ../Xray_summary irs1_SXDS10_agn.ps
/home/akiyama/clfiles/SPECVIEW/spec_view irs2_SXDS10.tbl_agn irs2_SXDS10_lrypbw.fits ../Xray_summary irs2_SXDS10_agn.ps
sed 's/|/ /g' irs1_SXDS10.tbl | awk -f ../format_tbl.awk > tmp
sed 's/|/ /g' irs2_SXDS10.tbl | awk -f ../format_tbl.awk >> tmp
/home/akiyama/clfiles/SXDS/merge_cat /home/akiyama/SXDS/figures/Xraymaster_ID tmp 17 2 1.0 0 | awk '{if(index($19,"SDS")==0) print $0}' 

sed 's/|/ /g' irs1_SXDS_S10B_086.tbl | grep AGNs > irs1_SXDS11.tbl_agn
sed 's/|/ /g' irs1_SXDS_S10B_086.tbl | grep SWRS >> irs1_SXDS11.tbl_agn
sed 's/|/ /g' irs1_SXDS_S10B_086.tbl | grep UDS-NBH-double55 >> irs1_SXDS11.tbl_agn  # SDS0_0047
sed 's/|/ /g' irs1_SXDS_S10B_086.tbl | grep AzTEC157.0 >> irs1_SXDS11.tbl_agn # SDS0_0115
sed 's/|/ /g' irs1_SXDS_S10B_086.tbl | grep AzTEC058.1 >> irs1_SXDS11.tbl_agn # SDS0_1062
/home/akiyama/clfiles/SPECVIEW/spec_view irs1_SXDS11.tbl_agn irs1_SXDS_S10B_086_lrypbw.fits ../Xray_summary irs1_SXDS11_agn.ps
sed 's/|/ /g' irs1_SXDS_S10B_086.tbl | awk -f ../format_tbl.awk > tmp
/home/akiyama/clfiles/SXDS/merge_cat /home/akiyama/SXDS/figures/Xraymaster_ID tmp 17 2 1.0 0 | awk '{if(index($19,"SDS")==0) print $0}' 

awk '{if($2>0 && $2!=8.888) print $0}' Xray_summary | awk '{if(index($3,"SDS")>0){print $3,$2} else{print $1,$2}}' > Xray_summary_FMOSobs

sed 's/|/ /g' 20101123_red/irs1_SXDS9.tbl | awk '{if(index($3, "SDS")>0) print $3}' > list_all_SDS
sed 's/|/ /g' 20101123_red/irs2_SXDS9.tbl | awk '{if(index($3, "SDS")>0) print $3}' >> list_all_SDS
sed 's/|/ /g' 20101122_red/irs1_SXDS8.tbl | awk '{if(index($3, "SDS")>0) print $3}' >> list_all_SDS
sed 's/|/ /g' 20101122_red/irs2_SXDS8.tbl | awk '{if(index($3, "SDS")>0) print $3}' >> list_all_SDS
sed 's/|/ /g' 20101121_red/irs1_SXDS7.tbl | awk '{if(index($3, "SDS")>0) print $3}' >> list_all_SDS
sed 's/|/ /g' 20101121_red/irs2_SXDS7.tbl | awk '{if(index($3, "SDS")>0) print $3}' >> list_all_SDS
sed 's/|/ /g' 20101124_red/irs1_SXDS10.tbl | awk '{if(index($3, "SDS")>0) print $3}' >> list_all_SDS
sed 's/|/ /g' 20101124_red/irs2_SXDS10.tbl | awk '{if(index($3, "SDS")>0) print $3}' >> list_all_SDS

sed 's/|/ /g' irs1_CDFS1.tbl | sed 's/none/S\/N 00/' > irs1_CDFS1.tbl_mod
/home/akiyama/clfiles/SPECVIEW/spec_view irs1_CDFS1.tbl_mod irs1_CDFS1_lrypbw.fits irs1_CDFS1_agn.res irs1_CDFS1_agn.ps
sed 's/|/ /g' irs1_COSMOS1.tbl > irs1_COSMOS1.tbl_mod
/home/akiyama/clfiles/SPECVIEW/spec_view irs1_COSMOS1.tbl_mod irs1_COSMOS1_lrypbw.fits ../../Xray_summary irs1_COSMOS1_agn.ps
sed 's/|/ /g' irs1_SXDS1.tbl > irs1_SXDS1.tbl_mod
/home/akiyama/clfiles/SPECVIEW/spec_view irs1_SXDS1.tbl_mod irs1_SXDS1_lrypbw.fits irs1_SXDS1_res irs1_SXDS1_agn.ps
sed 's/|/ /g' irs1_SXDS1.tbl | sed 's/none/SN 00/' | awk '{if($3=="Dummy:") print $4,$23}' | sed 's/,/ /g' | sed 's/zs=/ /g' | awk '{print $1,$3}' > irs1_SXDS1_res
sed 's/|/ /g' irs1_SXDS2.tbl > irs1_SXDS2.tbl_mod
/home/akiyama/clfiles/SPECVIEW/spec_view irs1_SXDS2.tbl_mod irs1_SXDS2_lrypbw.fits ../../Xray_summary irs1_SXDS2_agn.ps
