Gnagesh,

I'm not a moderator so it's no big deal :) Just as a suggestion, you might want to post the real issue when you say something is Urgent in the subject line. I imagine many of us try to look at a posting quickly if someone marks it urgent. If people mark postings as urgent when they are not, it may lead people to start treating Urgent posts like any other which would be a shame. Also, you probably would have gotten a better answer to your real question. You probably don't need "Unix Commands" for this problem. You probably need to look at something like awk or sed.

Are you saying that you have a text file that you need to insert some delimiters around to bring the file into the database? If it's not in a fixed-length format and the data isn't uniform then that's probably going to be an issue. If you
can email me a sample of 40 or 50 rows I'd be glad to take a look and help you out if you haven't resolved the issue already. Send the file to [email protected]