Re: Help with data conversion???

GIL QUIHUIZ (pdsc_at_netcom.com) wrote:
: What method is best to convert a 190Mb file containing 1100 byte ASCII
: blocks (separated by hex 0A0D - LFCR), and store it into an Oracle7 data
: base??? The file is created elsewhere and they will not change it.
 

: In addition, if-then-else decisions need to be made on each record. For
: example, convert a string YYJJJ julian date to Oracle date field. Some
: records maybe discarded entirely based on certain decisions.
 

: Also, I only have Oracle and Unix at my disposal. Please send me email
: with any helpful suggestions regarding manipulation of Unix files with
: Oracle tools.
Perl. It will do it all quite easily. Not to mention its a snap to write.   The O'riely book 'Programming Perl' is the bible on the subject.

d

--
Darrell Cavens
dcavens_at_ingenia.com
Ingenia Communications Corporation