geting specified data from a text file using utl_fie [message #287605] |
Wed, 12 December 2007 22:04  |
ridhi_sundar
Messages: 184 Registered: November 2007 Location: Bangalore
|
Senior Member |
|
|
I am using utl_file to retrive data from a text file.The text file is as below.
ISA*00* *00* *ZZ*170901T *ZZ*2026422 *071128*1315*U*00300*000000002*0*T
GS*PO*170901T*2026422*071128*1315*2*X*003060
ST*850*00
0000002
BEG*00*NE*00514743**071121**AE
CSH*O
here the * are feild separaters. Suppose i want to retrive the data from the 3rd feild from line starting with BEG . Here it should be 'NE'.
How to retrive it?
|
|
|
|
|