8/15/14 Downloaded file 49NZ20111220_hy1.csv from http://www.jamstec.go.jp/iorgc/ocorp/data/p10rev_2011/index.html With eXcel Remove leading “X” from bottle numbers Replace “J” in bottle numbers with “0” Surface samples have bottle “-999” replace with 99 Delete CTDPRS_FLAG_W Delete CTDTMP_FLAG_W Delete c13,c14,h3,cs134,cs137 and errors (all empty) Delete XMISSCP Delete SILUNC, NRAUNC,PHPUNC,DNSSAL and flag Save as P10.2011.csv Fix line endings with vi and delete extra “,” copy to SUN ———————————————————— From file header BOTTLE,20140213JAMSTECRIGC #Software_Version: whp_btl_exchange.rb_v3.0 (occrp) #ORIGINAL_SUM_FILE: 49NZ20111220_sum.txt Thu May 24 06:12:40 +0900 2012 #ORIGINAL_HYD_FILE: sea201402120502.csv Thu Feb 13 12:31:45 +0900 2014 #DEPTH_TYPE: COR #EVENT_CODE: BO