Search Results

You can easily do this b spooling your result to text file from sql codes.
If this could mean what you want, then try it:

spool result.txt
<select ...... from .... >
spool off;

Thanks a lot, it really works.

linus>cat data1
8119463 | 15000
8136789 | 50000
8152238 | 15000
8167890 | 15000
7155789 | 15000
8123334 | 30000
7166330 | 15000
8146683 | 15000
8152238 | 15000
8167877 | 15000...

posted in error.

thanks a lot, the codes work well for the sample, I am still working on it for long list.

I use perl codes, I got some output errors
with
output files good, fair, bad.txt with empty column contents except the fixed one
for good.txt I have:

GOOD
A B C
Strawberry
Banana
Plantain...

Thanks a lot ldapswandog, I think the perl codes should work for me. While I am still working on it. I will be very grateful if you have more useful hint on your codes. I quickly run the perl codes...

I have several files like this

file A
Good Bad Fair
Strawberry 1 4 5
Banana 23 12 4
Plantain 0 0 1 ...