Shell Programming and Scripting

Hi,

I am facing a problem regarding .csv file, my script does not read .csv file and if i open this file in vi editor and perform :wq option then only my script reads the .csv file.

Thanks

How does your script access your .csv file?

What error messages does your script produce when it tries to read your .csv file?

What is the output from the command ls -l file.csv (assuming your .csv file is named file.csv) before and after you update file.csv using vi?

Hi,

below is the code i am using

Code:

#!/usr/bin/bash

while read each_line
do
var_tcode=`echo $each_line | awk -F',' '{print $1}'`

done < WPA_20131120_APP0000108.csv

echo "Value:: "$var_tcode

i have a file "WPA_20131120_APP0000108.csv" having below data

Code:

CE2DD,00000000108,00000000108,,20.11.2013,2.38.00.00.100010,20.00,MVR,Web Payment

when i run the above script it does not print any thing but when i open the same .csv file in vi editor and exit with :wq option and i run the script it prints CE2DD

Is there some problem in .csv file format or permission??

It sounds like whatever is creating your .csv files is not adding the proper line terminator (a newline character) at the end of the file. Then, when you open the file with vi and re-write it, vi adds the newline for you.

To verify this, use:

Code:

od -bc file.csv

to examine the contents of a .csv file that is not producing any output from your bash script. Then re-write your file using vi and run the above od command again. I expect that the last character in your .csv file displayed by od will change.

Code:

echo "CE2DD,00000000108,00000000108,,20.11.2013,2.38.00.00.100010,20.00,MVR,Web Payment" > WPA.csv

Code:

 awk -F, '{print $1}' WPA.csv

Output:

Code:

CE2DD

In your case, how WPA_20131120_APP0000108.csv file is written ?
Can you post the output of ls -l WPA_20131120_APP0000108.csv as Don asked earlier ?

I dont think,it can be a permission issue .

i got it , Thnkyou so much ..