Search Results

I have one more thread: Korn shell program to parse CSV text file and insert values into Oracle database. I would appreciate if you have any suggestions.
My only concern is: when there is space...

Chirel:
It was my mistake. I was reading the wrong text file.
Now, I need to store values in the database. So i need to assign it to variables.
Can i do it this way? My oracle is not installed...

I need to store each field in a variable as i need to insert in the database.

chirel: I do not get correct output:
for i in $(seq 1 14); do
echo "Field ${i}:"
cut -d',' -f${i} infile...

I have 14 fields. I have to insert them in the oracle database. That is why i am going through the loop.

I have a CSV file like this:
abc ,def ghi ,jkl
mno ,pqr stu ,vwx

Desired Output:
Field 1:
abc
mno
Field 2:
def ghi
pqr stu
Field 3:
jkl
vwx

This does not work:...

Table columns & file columns are not in the same order.

---------- Post updated at 10:44 PM ---------- Previous update was at 11:55 AM ----------

How do we tell in awk to ignore spaces in the...

I get the last two fields as output and only for the first record.
Now this is the output:
2011/04/21
05:28

---------- Post updated at 01:09 AM ---------- Previous update was at 01:07 AM...

When i print the columns, some have commas and in some there are 2 columns and one column has a comma.
for i in `cat endevor.txt`
do
col1=`cat $i | awk -F ',' '{print $1}'`
col2=`cat $i | awk -F...

Enclosed is comma separated text file. I need to write a korn shell program that will parse the text file and insert the values into Oracle database.
I need to write the korn shell program on Red...