11-30-2007
how to use expr
You need to use back tics not single quotes
x=`expr $x + 1`
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hello!
I want to evaluate some mathematical expressions in a script and I try to use 'expr' command.
Unfortunatally, when I have, for example,
expr 8.2 + 6
the result is 'expr: non-numeric argument'
Why ?
I work on SunOs 5.7.
Thanks in advance
Nathe (5 Replies)
Discussion started by: Nathe
5 Replies
2. Shell Programming and Scripting
Hi,
in my ksh script
expr 22 / 10 results as 2
but the actual result expected in 2.2.
how do i get that result. Please help
Thanks, (2 Replies)
Discussion started by: kotasateesh
2 Replies
3. Shell Programming and Scripting
sum=0;
cat op_api2 |while read word1 word2;
do
echo $word2
sum=`expr $word2 + $sum`;
done
echo $sum
op_api2 ( file has this data )
----------------------------
UsageSummary 1034
UsageSummary 1675
UnbilledUsage 175
UnbilledUsage 177
UnbilledUsage 177
UnbilledUsage 194
I want the... (2 Replies)
Discussion started by: bishweshwar
2 Replies
4. Shell Programming and Scripting
What is the difference between test expr VS .
For example :
if test 5 -eq 6
echo "Wrong"
and
if
echo "Wrong"
bot will give the same output as Wrong.
Now, what is the difference between these two? though they are producing the same result why we need two?
Any answer will be... (2 Replies)
Discussion started by: ashok.g
2 Replies
5. Shell Programming and Scripting
I'm trying to check if a variable'd string is only one character and use that in an if statement the only way I could find is:
$expr "${var}" : . # expr STRING : regrep
where the "." is the grep wildcard for any single character.
Whats wrong with my code here and is there a... (3 Replies)
Discussion started by: Tewg
3 Replies
6. Shell Programming and Scripting
$ cat > mtable
#!/bin/sh
#
#Script to test for loop
#
#
if
then
echo "Error - Number missing form command line argument"
echo "Syntax : $0 number"
echo "Use to print multiplication table for given number"
exit 1
fi
n=$1
for i in 1 2 3 4 5 6 7 8 9 10
do
echo "$n * $i = `expr $i \*... (1 Reply)
Discussion started by: jackel7777
1 Replies
7. UNIX for Dummies Questions & Answers
Hey there
i want to subtract the content from $b from $a. Each variable has got 18 values (normal numbers from 0 - 99).
How can i subtract them? I know i have to use the expr command, this is what i have till now:
a=`cat Tabelle.dat | awk {'print $4'} | awk -F: {'print $1'}`
b=`cat... (1 Reply)
Discussion started by: Mad van Bert
1 Replies
8. Shell Programming and Scripting
Hi All,
I'm writing a shell script in KSH, where I want to store the filename, total record count and actual record count of all the source files. The source files reside in 4 different sub-folders under the same root folder.
Below is code:
#!/usr/bin/ksh... (6 Replies)
Discussion started by: jagari
6 Replies
9. Shell Programming and Scripting
Hi
I have bellow script:
t1=`cat node1.txt | grep thread1 | cut -f2 -d '-'`
t2=`cat node2.txt | grep thread2 | cut -f2 -d '-'`
t3=`cat node1_rcat.txt | grep thread1 | cut -f2 -d '-'`
t4=`cat node2_rcat.txt | grep thread2 | cut -f2 -d '-'`
if ]; then
echo "no restore" >> log.log... (6 Replies)
Discussion started by: primo102
6 Replies
10. Shell Programming and Scripting
HI there
I am trying to understand Shell scripting to create my own, I am attempting a few examples can anyone tell me what this means?n=$( expr $n + 1)Tried looking on the internet, but just cannot find its anywhere :( .Help please (4 Replies)
Discussion started by: steve2015
4 Replies
LEARN ABOUT DEBIAN
sql::translator::parser::sqlite
SQL::Translator::Parser::SQLite(3pm) User Contributed Perl Documentation SQL::Translator::Parser::SQLite(3pm)
NAME
SQL::Translator::Parser::SQLite - parser for SQLite
SYNOPSIS
use SQL::Translator;
use SQL::Translator::Parser::SQLite;
my $translator = SQL::Translator->new;
$translator->parser("SQL::Translator::Parser::SQLite");
DESCRIPTION
This is a grammar for parsing CREATE statements for SQLite as described here:
http://www.sqlite.org/lang.html
CREATE INDEX
sql-statement ::=
CREATE [TEMP | TEMPORARY] [UNIQUE] INDEX index-name
ON [database-name .] table-name ( column-name [, column-name]* )
[ ON CONFLICT conflict-algorithm ]
column-name ::=
name [ ASC | DESC ]
CREATE TABLE
sql-command ::=
CREATE [TEMP | TEMPORARY] TABLE table-name (
column-def [, column-def]*
[, constraint]*
)
sql-command ::=
CREATE [TEMP | TEMPORARY] TABLE table-name AS select-statement
column-def ::=
name [type] [[CONSTRAINT name] column-constraint]*
type ::=
typename |
typename ( number ) |
typename ( number , number )
column-constraint ::=
NOT NULL [ conflict-clause ] |
PRIMARY KEY [sort-order] [ conflict-clause ] |
UNIQUE [ conflict-clause ] |
CHECK ( expr ) [ conflict-clause ] |
DEFAULT value
constraint ::=
PRIMARY KEY ( name [, name]* ) [ conflict-clause ]|
UNIQUE ( name [, name]* ) [ conflict-clause ] |
CHECK ( expr ) [ conflict-clause ]
conflict-clause ::=
ON CONFLICT conflict-algorithm
CREATE TRIGGER
sql-statement ::=
CREATE [TEMP | TEMPORARY] TRIGGER trigger-name [ BEFORE | AFTER ]
database-event ON [database-name .] table-name
trigger-action
sql-statement ::=
CREATE [TEMP | TEMPORARY] TRIGGER trigger-name INSTEAD OF
database-event ON [database-name .] view-name
trigger-action
database-event ::=
DELETE |
INSERT |
UPDATE |
UPDATE OF column-list
trigger-action ::=
[ FOR EACH ROW | FOR EACH STATEMENT ] [ WHEN expression ]
BEGIN
trigger-step ; [ trigger-step ; ]*
END
trigger-step ::=
update-statement | insert-statement |
delete-statement | select-statement
CREATE VIEW
sql-command ::=
CREATE [TEMP | TEMPORARY] VIEW view-name AS select-statement
ON CONFLICT clause
conflict-clause ::=
ON CONFLICT conflict-algorithm
conflict-algorithm ::=
ROLLBACK | ABORT | FAIL | IGNORE | REPLACE
expression
expr ::=
expr binary-op expr |
expr like-op expr |
unary-op expr |
( expr ) |
column-name |
table-name . column-name |
database-name . table-name . column-name |
literal-value |
function-name ( expr-list | * ) |
expr (+) |
expr ISNULL |
expr NOTNULL |
expr [NOT] BETWEEN expr AND expr |
expr [NOT] IN ( value-list ) |
expr [NOT] IN ( select-statement ) |
( select-statement ) |
CASE [expr] ( WHEN expr THEN expr )+ [ELSE expr] END
like-op::=
LIKE | GLOB | NOT LIKE | NOT GLOB
AUTHOR
Ken Youens-Clark <kclark@cpan.org>.
SEE ALSO
perl(1), Parse::RecDescent, SQL::Translator::Schema.
perl v5.14.2 2012-01-18 SQL::Translator::Parser::SQLite(3pm)