07-22-2009
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.
How can we achieve the variable value as '/home/fir/dir ' and pass it to ftp command?
Thanks in Advance!
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
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
2. Shell Programming and Scripting
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
3. Shell Programming and Scripting
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
4. Shell Programming and Scripting
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
5. Shell Programming and Scripting
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
6. Shell Programming and Scripting
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
7. Shell Programming and Scripting
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
8. UNIX for Beginners Questions & Answers
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
9. UNIX for Beginners Questions & Answers
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
10. UNIX for Beginners Questions & Answers
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
LEARN ABOUT PHP
ovrimos_result_all
OVRIMOS_RESULT_ALL(3) OVRIMOS_RESULT_ALL(3)
ovrimos_result_all - Prints the whole result set as an HTML table
SYNOPSIS
int ovrimos_result_all (int $result_id, [string $format])
DESCRIPTION
Prints the whole result set as an HTML table.
PARAMETERS
o $result_id
- A result identifier, returned by ovrimos_execute(3) or ovrimos_exec(3).
o $format
- Optional HTML attributes for the generated table element.
RETURN VALUES
Returns the number of rows in the generated table.
EXAMPLES
This will execute an SQL statement and print the result in an HTML table.
Example #1
Prepare a statement, execute, and view the result
<?php
$conn = ovrimos_connect("db_host", "8001", "admin", "password");
if ($conn != 0) {
echo "Connection ok!";
$res = ovrimos_prepare($conn, "select table_id, table_name
from sys.tables where table_id = 7");
if ($res != 0) {
echo "Prepare ok!";
if (ovrimos_execute($res, array(3))) {
echo "Execute ok!
";
ovrimos_result_all($res);
} else {
echo "Execute not ok!";
}
ovrimos_free_result($res);
} else {
echo "Prepare not ok!
";
}
ovrimos_close($conn);
}
?>
Example #2
ovrimos_result_all(3) with meta-information
<?php
$conn = ovrimos_connect("db_host", "8001", "admin", "password");
if ($conn != 0) {
echo "Connection ok!";
$res = ovrimos_exec($conn, "select table_id, table_name
from sys.tables where table_id = 1");
if ($res != 0) {
echo "Statement ok! cursor=" . ovrimos_cursor($res) . "
";
$colnb = ovrimos_num_fields($res);
echo "Output columns=" . $colnb . "
";
for ($i=1; $i <= $colnb; $i++) {
$name = ovrimos_field_name($res, $i);
$type = ovrimos_field_type($res, $i);
$len = ovrimos_field_len($res, $i);
echo "Column " . $i . " name=" . $name . " type=" . $type . " len=" . $len . "
";
}
ovrimos_result_all($res);
ovrimos_free_result($res);
}
ovrimos_close($conn);
}
?>
PHP Documentation Group OVRIMOS_RESULT_ALL(3)