Shell Programming and Scripting

I have a flat file like this

0001 THER ULT HEAD & NECK VES
0002 THER ULTRASOUND OF HEART
0003 THER ULT PERIPHERAL VES
0009 OTHER THERAPEUTIC ULTSND
0010 IMPLANT CHEMOTHERA AGENT
0011 INFUS DROTRECOGIN ALFA
0012 ADM INHAL NITRIC OXIDE

I need to conver this to a comma delimited flat file so that I can loadthis into a table using SQL loader.ex:0001,THER ULT HEAD & NECK VES.also let me know if there is any other way too.currently i loaded this using Position(1:4) and position(6:60) and they got loaded,but let me know if i can change this to a csv which will make things easy for me.

Thanks,

Whether you use utilities like cut and others to define where dilimiters go, you're still faced with the same problem of defining the column positions in numeric terms. And, unless you have control of the data feed and you can define delimieters, you're stuck mapping one way or the other.

If you have TOAD (gag!) at your disposal, one of its two nice features enable you to map this a little easier.

Besides, the positioning format is somewhat easier to read.
eg:

Code:

INTO TABLE load_cust
WHEN (001:001)='5'
(
 cust_name                  POSITION(0002:0020) CHAR
,act_number                 POSITION(0021:0039) CHAR
,act_dt                     EXPRESSION "TO_DATE(NULL)"

It doesn't offer much help with delimiters but you can read it versus "Fields terminated by ";" Optionally enclosed by '"'". Also, you don't have any issues with quotations mucking things up.

Thomas

I guess what you said is right..thx for the try thou...