my original file is below one
and i want output of 6th field to get increase by 2 without space in 6th field being removed.
like output below
which i am not getting as the space in 6th value is getting removed.
---------- Post updated at 01:35 PM ---------- Previous update was at 01:32 PM ----------
u can see the output above where the space is not present in 6th field after the value which was there in original file
Last edited by Scott; 04-25-2011 at 03:38 PM..
Reason: Use code tags, please...
Hello all,
i am new one to this forum.
:
i have file with these contents..
internal://project/squid-internal-static/icons/anthony-xpm.gif
http://widget.blogrush.com/img/br.png
http://www.wingware.com/css/print
http://publib.boulder.ibm.com/infocenter/systems/advanced/filterwarning.css... (3 Replies)
Discussion started by: viveksnv
3 Replies
2. Post Here to Contact Site Administrators and Moderators
How can I write an AWK so it could print some fixed strings and concatenate that with other words from an input file. Also having a string like "go" in the next line in the output file as below:
Example:
A fixed string like: "Hello my"
and the input file is:
friend
mother
father... (4 Replies)
Hi,
I am trying to perform a simple soustraction between two floating numbers and cannot get it done for some reason due to the use of the sub command.
The following is the straight-forward result of the soustraction:
$ echo | gawk '{a=968;b=967.99;c=a-b;print c}' ... (2 Replies)
Hello,
I am getting problem in awk command during matching (using if in awk) when there is special character ""
I have tried by loosing the special meaning, still its not working
Below is my code:
set pinname_watch = "DCORRECT"
set pinname = "DCORRECT\"
echo 'defineGateSize... (2 Replies)
I am having problem running an awk commad on a file
Before applying awk command on the file
After applying
I don't expect more than 409743 records in the file. Why do I have 1 record more after applying awk command?
Please let me know (4 Replies)
I have written some code in a KSH script to find the index of the character in a string like this
#!usr/bin/ksh
string="Hi How are you"
awk 'BEGIN {print index ($string, "are")}'
My expected output should be : 8
but it is giving the out put as : 0
I wanted to store that index value in... (8 Replies)
#!/bin/sh
date=`date +%y%m%d -d"1 day ago"`
inbound_dir=/vis/logfiles/to_solmis
cp `grep -il ST~856~ $inbound_dir/*$date*` /vis/sumit/in_ASN/
echo 'SENDER,RECEIVER,DATE,TIME,ASNUMBER' > a.csv
for i in /vis/sumit/in_ASN/*
do
... (8 Replies)
Hi to all,
I'm facing some problems when adding an alias like:
#alias list="ls -al | awk '{ print $1, $2, $3, $4, (($5/1048576))"\t", $6, $7, $8, $9 }'"
and when I enter:
#list
I get:
Syntax Error The source line is 1.
The error context is
{ print >>> , <<<
awk:... (3 Replies)
Okay, so I am trying to use a count variable to reference the column of output sent from an echo statement. So I am trying to do this
#!/bin/bash
CURRENT=$PWD
VAR=3
CHANGE=`echo $CURRENT | awk -F "/" '{ print \$$VAR }'`
This instead of giving me the third instance after the "/" gives... (4 Replies)
Hi All,
I am trying to find a word from a file in loop.
while read i; do
DB_Name=$i
awk '{for(i=1;i<=NF;i++)if($i~/$DB_Name/)print $(i)}' $BTEQ_NAME > $DB_Name_TableList.txt
done <Param.txt
here Param.txt contents data as
ODS_TARGT_RECV
FIN_TARGT... (7 Replies)
Discussion started by: Shilpi Gupta
7 Replies
LEARN ABOUT SUSE
move
MOVE(7) SQL Commands MOVE(7)NAME
MOVE - position a cursor
SYNOPSIS
MOVE [ direction { FROM | IN } ] cursorname
DESCRIPTION
MOVE repositions a cursor without retrieving any data. MOVE works exactly like the FETCH command, except it only positions the cursor and
does not return rows.
The parameters for the MOVE command are identical to those of the FETCH command; refer to FETCH [fetch(7)] for details on syntax and usage.
OUTPUTS
On successful completion, a MOVE command returns a command tag of the form
MOVE count
The count is the number of rows that a FETCH command with the same parameters would have returned (possibly zero).
EXAMPLES
BEGIN WORK;
DECLARE liahona CURSOR FOR SELECT * FROM films;
-- Skip the first 5 rows:
MOVE FORWARD 5 IN liahona;
MOVE 5
-- Fetch the 6th row from the cursor liahona:
FETCH 1 FROM liahona;
code | title | did | date_prod | kind | len
-------+--------+-----+------------+--------+-------
P_303 | 48 Hrs | 103 | 1982-10-22 | Action | 01:37
(1 row)
-- Close the cursor liahona and end the transaction:
CLOSE liahona;
COMMIT WORK;
COMPATIBILITY
There is no MOVE statement in the SQL standard.
SEE ALSO
CLOSE [close(7)], DECLARE [declare(7)], FETCH [fetch(7)]
SQL - Language Statements 2010-05-14 MOVE(7)