Path: utzoo!attcan!uunet!husc6!bu-cs!berlin
From: berlin@bu-cs.BU.EDU (David K. Fickes)
Newsgroups: comp.databases
Subject: Ingres question....
Message-ID: <22714@bu-cs.BU.EDU>
Date: 17 May 88 23:21:33 GMT
References: <1251@its63b.ed.ac.uk>
Reply-To: berlin@buita.bu.edu (David Fickes Einstein Project)
Followup-To: comp.databases
Organization: Boston University - Einstein Papers Project
Lines: 30

Just a quick question for you Ingres hackers (RTI that is..)

I'm attempting to port a VERY old dataset that has no delimiters on 
the fields... Most of the 50,000 or so records are in good order now
and I'd like to run a few replace statements as follows:

replace p(pages=int1(right(squeeze(p.note6),2))) where p.note6="PP ?"

Unfortunately.. a handful of these records can't convert to integers
either because the last two characters aren't numbers or the field is
longer than it should be.. ect.. (we took the usual cases
when breaking the file into fields and didn't include a few
exceptions..)  

I'd love for the program to do as many as possible and then give
me a count of all the records that cannot be converted.. Is this
possible?  For this database, I'll be doing quite a few of thes
conversions and it seems to come up periodically with the type of work
I do...

thanks, david

ps: has anyone looked into Metamorph software by EPI in Ohio?
-- 
==============================================================================
David K. Fickes     Center for Einstein Studies/Einstein Papers Project
UUCP: ...harvard!bu-it!berlin			Boston University 
OTHERWISE: berlin@bu-it.bu.edu			745 Commonwealth Avenue
PHONE:	(617) 353-9249	(617) 277-9741		Boston, MA 02215