8/15/14
Downloaded file 49NZ20120113_hy1.csv from
http://www.jamstec.go.jp/iorgc/ocorp/data/p10rev_2011/index.html

8/18/14
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
Delete DNSSAL and flag, XMISSCP
Delete SILUNC, NRAUNC,PHPUNC
Save as P10N.2012.csv
Fix line endings with vi and delete extra “,”
copy to SUN


——————————
From original file header

BOTTLE,20140213JAMSTECRIGC
#Software_Version: whp_btl_exchange.rb_v3.0 (occrp)
#ORIGINAL_SUM_FILE: 49NZ20120113_sum.txt Tue Jan 14 11:26:58 +0900 2014
#ORIGINAL_HYD_FILE: sea201402120503.csv Thu Feb 13 13:01:28 +0900 2014
#DEPTH_TYPE: COR
#EVENT_CODE: BO