Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Not able to assign a value to variable

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Not able to assign a value to variable
# 1  
Old 07-22-2009
Question Not able to assign a value to variable
Hi Experts,

I am facing some problem while developing the script.My input config.csv file contains the three columns namely pathname,filename,filetype.Based on the file type i have to use ftp command that is if filetype=csv then do ftp.
The input file is

HTML Code:
cat config.csv
pathname,filename,filetype
/home/fir/dir,filename1,csv
/home/fir1/dir,filename2,csv
/home/fir4/dir,filename3,csv
/home/fir/dir6,filename4,dat
To achieve this i have developed the following script:
HTML Code:
#!/bin/ksh
head -5 config.csv | while read line
do
Type1=`echo $line | awk -F"," '{print $3}'`
Type=`echo $Type1 | tr [A-Z] [a-z]`
if [ $Type == 'csv' ]
 then
   DataFileName=`echo $line | awk -F"," '{print $2}'`
   DataPath=`echo $line| awk -F"," '{print $1}'`
   echo $DataPath
   slash=`echo '\'`
   filelocation=`echo $DataPath$slash$DataFileName`
   echo do sftp -n
fi
done
Now the problem is that the value of DataPath variable is coming as
HTML Code:
echo $DataPath
homefirdir
Some how the slashes are getting removed.Smilie
How can we achieve the variable value as '/home/fir/dir ' and pass it to ftp command?

Thanks in Advance!
# 2  
Old 07-22-2009
try qouting the $line in all lines
Code:
DataPath=`echo "$line"| awk -F"," '{print $1}'`

# 3  
Old 07-22-2009
Quote:
Originally Posted by Amey Joshi
Hi Experts,

I am facing some problem while developing the script.My input config.csv file contains the three columns namely pathname,filename,filetype.Based on the file type i have to use ftp command that is if filetype=csv then do ftp.
The input file is

HTML Code:
cat config.csv
pathname,filename,filetype
/home/fir/dir,filename1,csv
/home/fir1/dir,filename2,csv
/home/fir4/dir,filename3,csv
/home/fir/dir6,filename4,dat
To achieve this i have developed the following script:
HTML Code:
#!/bin/ksh
head -5 config.csv | while read line
do
Type1=`echo $line | awk -F"," '{print $3}'`
Type=`echo $Type1 | tr [A-Z] [a-z]`
if [ $Type == 'csv' ]
 then
   DataFileName=`echo $line | awk -F"," '{print $2}'`
   DataPath=`echo $line| awk -F"," '{print $1}'`
   echo $DataPath
   slash=`echo '\'`
   filelocation=`echo $DataPath$slash$DataFileName`
   echo do sftp -n
fi
done
Now the problem is that the value of DataPath variable is coming as
HTML Code:
echo $DataPath
homefirdir
Some how the slashes are getting removed.Smilie
How can we achieve the variable value as '/home/fir/dir ' and pass it to ftp command?

Thanks in Advance!
For me your code works just fine...Smilie
try the solution given above, if you still have a problem debug using set -x.
# 4  
Old 07-22-2009
Power
Sorry, actually the input file data is Smilie Smilie

HTML Code:
$ cat config.csv
pathname,filename,filetype
\home\fir\dir,filename1,csv
\home\fir1\dir,filename2,csv
\home\fir4\dir,filename3,csv
\home\fir\dir6,filename4,dat
Actually i tried to send this pathname to file and again cat the file,but this command is also not working... Smilie

HTML Code:
.....
echo $line > 45.txt
.....
DataPath=`cat 45.txt | awk -F"," '{print $1}'
# 5  
Old 07-22-2009
did you try qouting the line variable?

Code:
"$line"

# 6  
Old 07-22-2009
Thanks! for your reply..
Yes! I have tried the above mentioned command,but still it is not working Smilie
# 7  
Old 07-22-2009
hmm.. can you just use backlash? forward slashes complicate things
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Assign value to variable

Hi Guys, I need to assign the value of which has rows to a variable, Can you advise how to do that hive --orcfiledump /hdfs_path/ | grep "Rows" Rows: 131554 I need to assign this row count itself to a unix variable count=$(hive --orcfiledump /hdfs_path/ | grep "Rows") Expected ... (6 Replies)
Discussion started by: Master_Mind
6 Replies

2. UNIX for Beginners Questions & Answers

How can I assign awk's variable to shell script's variable?

I have the following script, and I want to assign the output ($10 and $5) from awk to N and L: grdinfo data.grd | awk '{print $10,$5}'| read N L output from gridinfo data.grd is: data.grd 50 100 41 82 -2796 6944 0.016 0.016 3001 2461. where N and L is suppose to be 3001 and 100. I use... (8 Replies)
Discussion started by: geomarine
8 Replies

3. UNIX for Beginners Questions & Answers

Need to pass variable in a command and assign value to a variable

Hello All, Hope you're doing well ! I am trying below command to be passed in a shell script, header_date_14 is a variable and $1 is the name of a file I intend to pass as a command line argument, however command line argument is not being accepted. header_date_14=$(m_dump... (8 Replies)
Discussion started by: ektubbe
8 Replies

4. Shell Programming and Scripting

Assign a variable with awk

I launch 'netstat -a', if string 'ESTABLISHED' found, then VAR=1 #!/bin/bash VAR=0; netstat -a | awk '$6 ~ /ESTABLISHED/ {VAR=1}' I cannot find the right syntax. thanx guys! (3 Replies)
Discussion started by: arpagon
3 Replies

5. Shell Programming and Scripting

Shell assign variable to another variable

How can I assign a variable to an variable. IE $car=honda One way I can do it is export $car=honda or let $car=2323 Is there any other ways to preform this task (3 Replies)
Discussion started by: 3junior
3 Replies

6. Shell Programming and Scripting

assign awk's variable to shell script's variable?

Dear All, we have a command output which looks like : Total 200 queues in 30000 Kbytes and we're going to get "200" and "30000" for further process. currently, i'm using : numA=echo $OUTPUT | awk '{print $2}' numB=echo $OUTPUT | awk '{print $5}' my question is : can I use just one... (4 Replies)
Discussion started by: tiger2000
4 Replies

7. Shell Programming and Scripting

Assign this to a variable....

bash-3.00$ /usr/bin/netstat -an -f inet | awk -F' ' '{if ($1$4 == "tcp*.21")print $5}' *.* bash-3.00$ A=` /usr/bin/netstat -an -f inet | awk -F' ' '{if ($1$4 == "tcp*.21")print $5}'` bash-3.00$ echo $A db2_lastdone.bkp As you can see ,after running command i get *.* in return but the same... (5 Replies)
Discussion started by: ak835
5 Replies

8. Shell Programming and Scripting

assign a value to a variable

I have a list of names in a file. i want to assign those names to a variable in such a manner eg: $cat file.txt pete lisa john var=pete-lisa-john how do i do this in shell scripting? (10 Replies)
Discussion started by: Shivdatta
10 Replies

9. Shell Programming and Scripting

assign a value to variable

I have to assign a result of a query to a vairable like this how can i do this Query = select count(*) from table x=`db2 ${Query}| sed -n '4p'` but this doesn't work, is there any other way to assign the result without redirecting the result to temp file. . Thanks Mark. (3 Replies)
Discussion started by: markjason
3 Replies

10. UNIX for Dummies Questions & Answers

assign to variable

why i can't use this command: echo $arg | cut -c 1,2 | read remainArg or echo $arg | cut -c 1,2 | read $remainArg so that the result will be assign to remainArg. Anyway to do this? :) (1 Reply)
Discussion started by: AkumaTay
1 Replies
Login or Register to Ask a Question