I am a new bee on this forum.

Can any one help me in parsing the text file in perl.I have very large text file with plenty of columns and rows.how can i parse the file into Oracle databse.

thanks in advance

Hi,

Welcome to LQ!

So you've shown us your need! What's your deed?

We will aid you when you help yourself to a solution. Provide us with what you have attempted and then maybe someone will be able to assist.

'How to Ask Questions the Smart Way' would be one link you should look at to help us to help you in the future.

Just a few links that may aid you;

Linux Documentation Project
Rute Tutorial & Exposition
Linux Command Guide
Utimate Linux Newbie Guide
LinuxSelfHelp
Getting Started with Linux
Bash Reference Manual
Advanced Bash-Scripting Guide
Linux Home Networking


The above links and others can be found at 'Slackware-Links'. More than just Slackware® links!

I fixed your title---Please use thread titles which are descriptive of the actual problem.

Why PERL?----there are lots of utilities that will parse text by column. e.g.: Have you looked at AWK?

Thanks for your email.My req is to use perl to parse.I have tried the following code.I am stuck at this point how can i proceed further,

<code>

open FILENAME "myfilename.txt";
While(<FILENAME>
{
@values = split(/\t/,$_);
$variable1 = value[0]
$variable2 = value[1]
.........
$variable20= value[20]

print@values
}
</code>
How can i insert all the values underneath those variables.
sample file name

var0 var1 var2 var3 var4 var5 ................................var20
1 2 3 4 5 6 .................................20
2.1 3.1 4.1 5.1 6.1 7.1 20.1
.
.
.
.
.
i have the file name like this please help me how i can insert all those values under the above variable names