07-11-2012
Thanku for the reply
I tried doing that.It works fine but not givingme the desired output since
loc returns value 0
but when a try to write the output of awk in a file it gives the all the locations at which value is present.
Hiw can a fetch the value of loc the moment it encounters taht line and moving on to next line.
I tried defining the variable locations and locatione inside the action part of awk but it didn't worked
echo $d2|grep -w 'RemittanceId' | awk -v find='RemittanceId' '{loc=index($0,find), locations=`expr $loc + 13` , locatione=`expr $location + 15`}'
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi All,
Can anybody tell me the command used for extracting some selected lines from
a web-page. I guess we'll have to do this using wget or Curl to achieve this....
If anbody has any idea abt it, kindly post your reply ASAP.
Thanks. (1 Reply)
Discussion started by: sunnydynamic15
1 Replies
2. Shell Programming and Scripting
Hi All,
There is a link from were I usually search somthing and fetch the data from.
Is there any way to automate it through a script if I mention search criteria in a note pad.
I mean the script to search the content on the notepad and resutls should be placed into another file.
... (2 Replies)
Discussion started by: indradev
2 Replies
3. Shell Programming and Scripting
Hi Guys,
I have the data in below format.
25 Dec 2011 03:00:01 : aaaaaaaaaaaaaaa
25 Dec 2011 04:23:23 : bbbbbbbbbbbbbbb
25 Dec 2011 16:12:45 : ccccccccccccccc
26 Dec 2011 04:45:34 : ddddddddddddddd
26 Dec 2011 17:01:22 : eeeeeeeeeeeeeee
27 Dec 2011 12:33:45 : ffffffffffffffffffffffff
28... (13 Replies)
Discussion started by: jaituteja
13 Replies
4. Shell Programming and Scripting
Hi All,
I m new to this forum & UNix too.
currently i have a requirement which can fetch data from a logfile between two dates or timestamp.
for example:
1. data from 2012 Jun to 2012 Jul
2. data from 2012 Jun to 2012 Jul 07
3. data from 2012 Jun 16 10:20 to 2012 Jul 03 10:10
Please... (7 Replies)
Discussion started by: KDMishra
7 Replies
5. UNIX for Dummies Questions & Answers
Hi All,
I have a file with the below data as shown.
A|2|20120430
B|EMP|NAME|DEPT
C|12|SARC|01
C|23||ASDD|02
D|END OF FILE
I want to fetch only the records that contains C|, what is unix command to fetch this data.
Thanks (5 Replies)
Discussion started by: halpavan2
5 Replies
6. Shell Programming and Scripting
Hello, How All are Doing today. I have a issue, I have a file which contains the data as follow
<ENVELOPE><ENVELOPE_ID>TEST</ENVELOPE_ID><ENVELOPE_EXTERNAL_ID></ENVELOPE_EXTERNAL_ID><ENVELOPE_VERSION>2</ENVELOPE_VERSION><SIResourceDefaultVersion>true</SIResourceDefaultVersion><TYPE>GS... (1 Reply)
Discussion started by: adisky123
1 Replies
7. Shell Programming and Scripting
Hi Guys,
Am in need of your help one more time on my real data.
I have a file which contains more than thousand lines of data
Live data shown for 4 iterations. We have more than thousand lines of data:-
--------------------------------------------------------------------------
... (4 Replies)
Discussion started by: rocky2013
4 Replies
8. Shell Programming and Scripting
Hi Team,
I m getting my script commands output like given below
GETA-TILL-INF;
U-UU-YRYT-NOD-6002 2015-05-14 THU 19:44:10
C2221 RETRIEVE TILL INFORMATION : COMPLD
----------------------------------------------------------------------
CONNECT_CARD_ID ... (9 Replies)
Discussion started by: Ganesh Mankar
9 Replies
9. UNIX for Beginners Questions & Answers
Hi ,
I have a file which contains 2 days logs(here it is 24 and 25)
I want to list data only for date 25 fron the file.
please suggest me how should i get this.
file content mentioned below
17-05-24 Name Succ Fail
00:00:29 ... (5 Replies)
Discussion started by: scriptor
5 Replies
10. Shell Programming and Scripting
Hi,
I am new to scripting. I have a log file and need to fetch specific logs and copy to another file.
A copy of the log is like this:
===============================================================
= JOB : server123#jobs1.jobstream1
= USER : andyc
= Tue 08/01/17... (3 Replies)
Discussion started by: Prngp
3 Replies
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)