merged data from 2292 tapes

alltapes5.txt (2292 records, 6 columns, comma delimited)
../norcal/tapebox.txt tapes stored in boxes (2193 records, 4 columns, comma delimited)
../tlist.bynumber.txt FMPro database (1914 records, 14 columns, tab delimited)
../combtape.prn.txt status of MSS archiving (1351 records, 9 columns, comma delimited)
../seedis/50b_2.txt tapes in 50B slots (230 records, 4 columns, comma delimited)
../mss/mss_ok.txt unique tape directories on MSS (1762 records, 4 columns, comma delimited)

output file

alldata.txt (2292 records, 32 columns, comma delimited)

to remake:

cd $PDOCS/gss/merge
csh -fx alldata_1.csh.txt
splus <alldata.s
csh -fx alldata_2.csh.txt

cd $PDOCS/gss/norcal
splus
source ("readalldata.s")

tx[, 1]	tapeno		unique tape number
tapes stored in boxes (2193 records):
tx[, 2]	loc0		n (NOR-CAL) or u (UCDATA)
tx[, 3]	boxno		number of stored box at NOR-CAL or UCDATA
tx[, 4]	boxseq		sequence number within box (1-17)
tapes in FileMaker Pro database (1914 records):
tx[, 5]	owner		LBL tape owner in 1985 (comma changed to _), from tlist
tx[, 6]	account		LBL account number in 1985, from tlist
tx[, 7]	name		LBL tape name in 1985, from tlist 
tx[, 8]	format1		tape format, from tlist 
tx[, 9]	accessed	time since last access, as of June 1985, from tlist
tx[,10] loc1		LBL location as of 1994 (50A vault or 50B closet)
tx[,11]	50bslot		slot location in 50B closet as of 1994
tx[,12]	comments	information from external labels (incomplete)
tx[,13]	tlist		in tlist? (Y/N)
tx[,14]	contents	description of contents
tx[,15]	tapsum		in tapsum? (Y/N) (always empty)
tx[,16] gsslist		GSS list available? (Y/N)
tx[,17] bcklist		VMS backup listing available? (S/-)
MSS status (1351 records):
tx[,18]	owner1		asztalos, petrush, alsu, mikelu
tx[,19]	params		NEW,SL1F,WSS,NEW NDXDAT,OLD NOGS7,NEW SKIP,NEW NOGS7,BCK
tx[,20]	loc2		always 50B
tx[,21]	assigned	date assigned (YYMMDD)
tx[,22]	run		date run (YYMMDD)
tx[,23]	reported	date reported (YYMMDD)
tx[,24]	status		completion status (a1.1.1 etc)
tx[,25]	comments	tape processing comments
tapes in 50B slots (230 records):
tx[,26]	slot		50B slot number
tx[,27]	format2		tape format (BCK or GSS)
tx[,28]	seedis		in SEEDIS? (Y/N) (total 172 tapes with "Y")
tape directories on MSS (1762 records):
tx[,29]	owner2		MSS location: alsu,asztalos,petrush,mikelu,bradtapes
tx[,30]	space_du	size of directory from du, kB (total 46 GB)
tx[,31]	bestcopy	is this the best copy in MSS? (Y/N)
tx[,32]	space_ls	size of directory from ls, kB (total 50 GB)

tx[tx[,28]=="Y",c(1,24,32)]	status and space of 172 SEEDIS tapes