Sponsored Content
Full Discussion: awk function
Top Forums Shell Programming and Scripting awk function Post 302950823 by RavinderSingh13 on Wednesday 29th of July 2015 04:58:31 AM
Old 07-29-2015
Quote:
thanks for your correction.

In my code this condition is not working. not sure my syntax is wrong. any inputs please.

Syntax chek :


cat shell.sh
#!/bin/sh
while IFS='[,]' read locationinp sales; do
location_id=`echo $locationinp | cut -d' ' -f2`
sqlplus -S /NOLOG << EOF
CONNECT xxxx/password@xxxxdbt
set echo off
set heading off
set feedback off
set pagesize 0
CONNECT xxxx/password@xxxxdbt
SET head off
select count(*) into :loc_count from location_count where location_id='$location_id' and sales=$sales;
if [[ $loc_count > 1]]; then
delete from location_count where location_id='$location_id' and sales=$sales;
exit
EOF

done < queryout.txt
Hello Arun,

I think you need to close the if condition properly as follows.
Code:
 if [[ $loc_count > 1]]; then
 delete from location_count where location_id='$location_id' and sales=$sales;
 exit
 fi

Hope this helps.

Thanks,
R. Singh

Last edited by RavinderSingh13; 07-29-2015 at 06:00 AM.. Reason: Added quote section now
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk with function ?? please, help :(

Here is my test.in file Case Modify 10001 20002 30003 40004|Report Create 3417176211|Case Modify 10002 20002 30003 40004| Script: Remove.ksh This script to remove $1 which I type in: $ cat test.in Case Modify 10001 20002 30003 40004|Report Create 3417176211|Case Modify 10002 20002 30003... (0 Replies)
Discussion started by: sabercats
0 Replies

2. Shell Programming and Scripting

Help with the function awk

Hi I am trying to create a modify a txt file via a sh script and I'm not sure how to do it. I have this: data1a#data2a#data3aµ data1b#data2b#data3bµ data1c#data2c#data3cµ and I want to have this (more or less) data1a data2a data3a data1b data2b data3b data1c data2c data3c I know... (5 Replies)
Discussion started by: Morgwen
5 Replies

3. Shell Programming and Scripting

external function in awk

Hi all, I have a basic doubt. Is there any way to use external functions (i.e. functions not defined in AWK), in AWK. I have a shell script in which I'm using a AWK snippet. In this snippet I'm calling a function defined in the shell script. But the AWK snippet is not working. I figured that... (5 Replies)
Discussion started by: kamel.seg
5 Replies

4. Shell Programming and Scripting

MODE function in awk

Hello, Can someone pls help me with some statistical calculation in awk In excel there is a statistical function called "Mode". How Mode works: MODE returns the most frequently occurring, or repetitive, value in array or range. Eg if we have 5 numbers in 5 different columns... (12 Replies)
Discussion started by: Needhelp2
12 Replies

5. Shell Programming and Scripting

Awk problem: How to express the single quote(') by using awk print function

Actually I got a list of file end with *.txt I want to use the same command apply to all the *.txt Thus I try to find out the fastest way to write those same command in a script and then want to let them run automatics. For example: I got the file below: file1.txt file2.txt file3.txt... (4 Replies)
Discussion started by: patrick87
4 Replies

6. Shell Programming and Scripting

AWK Function syntax

Hi, I would like to know what is the correct syntax to perform a function in awk. Although I have seen several examples, not get it to work, this is what I'm trying: #!/bin/bash awk function multi (number) { return number * 3 } print multi (4)Thanks (2 Replies)
Discussion started by: Godie
2 Replies

7. Shell Programming and Scripting

Awk-using group function

Hi, I have file with below format and sample data - File is pipe delimited Col1|col2|Account|Bal1|Bal2 1|2|1|10|5 1|2|2|10|2 1|3|3|10|3 I want output as SUM|1|2|2|20|7 SUM|1|3|1|10|3 Can anyone give me awk command (4 Replies)
Discussion started by: sanranad
4 Replies

8. Shell Programming and Scripting

awk function

Hi all, I need to have informations in a URL : https://www.autolib.eu/stations/ Valors I need are in bold: {"charging_status": "nonexistent", "rental_status": "future", "subscription_status": "nonexistent", "station_id": 791, "address": "10 rue de Rome, 93110 Rosny-sous-Bois", "lat":... (3 Replies)
Discussion started by: roulitto
3 Replies

9. Shell Programming and Scripting

System function in awk

Hello Friends, I have written a script like below, I aimed to move some CDR files (call data record) whose the last field is "1" (NF=1 ) from a spesific directory to a new directory Field Seperator is pipe. If the directory does not exitst i should create it. I will give the script two... (5 Replies)
Discussion started by: EAGL€
5 Replies

10. Shell Programming and Scripting

Need help on awk for printing the function name inside each function

Hi, I am having script which contains many functions. Need to print each function name at the starting of the function. Like below, functionname() { echo "functionname" commands.... } I've tried like below, func=`grep "()" scriptname | cut -d "(" -f1` for i in $func do nawk -v... (4 Replies)
Discussion started by: Sumanthsv
4 Replies
create object(1m)														 create object(1m)

NAME
create object - Creates an object entry SYNOPSIS
cdscp create object object-name [CDS_Class = class-name CDS_ClassVersion = value] ARGUMENTS
The full name of the object entry. The class of object entry being created. You can specify an application-defined class name. A class is specified as a simple name limited to 31 characters. The version of the class assigned to the object entry. Specify the value as v.n, where v defines the major release number and n specifies the minor version number. Specifying a class version is useful as it allows the definition of a class to evolve as the application is revised. DESCRIPTION
The create object command creates an object entry. This task is usually done through a client application. Privilege Required You must have insert permission to the parent directory. NOTE
This command is replaced at Revision 1.1 by the dcecp command and may not be provided in future releases of DCE. EXAMPLE
The following command creates an object entry named /.:/sales/east/floor1cp. The object entry describes a color printer on the first floor of a company's eastern sales office. cdscp> create object /.:/sales/east/floor1cp CDS_Class = printer CDS_ClassVersion = 1.0 RELATED INFORMATION
Commands: delete object(1m), list object(1m), set object(1m), show object(1m) create object(1m)
All times are GMT -4. The time now is 01:07 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy