Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

retrieving data between two strings

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers retrieving data between two strings
# 8  
Old 07-20-2012
Scrutinizer,
Could you plz explain the command. I didn't understand.
Is it will work for huge data file.
Is it possible, by using grep

---------- Post updated at 05:44 PM ---------- Previous update was at 05:29 PM ----------

awk command is working file.
Thanks scrutinizer...

I would like to pass SourceString DestString at runtime.
How can i do this in while using awk.
Here $1 and $2 treats like columns in awk.

example:Executing script
filename CCC FFF
# 9  
Old 07-22-2012
Could you plz help how to pass the parameters to awk
# 10  
Old 07-23-2012
Try:
Code:
awk '$0~s || $0~r,$0~s' r="CCC" s="FFF" infile

# 11  
Old 07-24-2012
Scrutinizer,

It's getting some error if i execute the above command.

awk: syntax error near line 1
awk: bailing out near line 1
# 12  
Old 07-24-2012
If you are using Solaris, use /usr/xpg4/bin/awk instead of awk
# 13  
Old 07-29-2012
Another way to do it is to get the line numbers where the pattern occur and then print the content between the lines:

Code:
$ cat linepat
AAA
AAA
CCC
CCC
CCC
EEE
EEE
EEE
EEE
FFF
FFF
GGG
GGG

using awk to get the line number for the first occurence of CCC
Code:
$ awk '/CCC/{print NR; exit}' linepat
3

using grep to get the line number for the last occurrence of FFF
Code:
grep -n "FFF" linepat | tail -1 | awk -F: '{print $1}'
11

Finally, using awk to read between the lines :
Code:
$ awk '(NR>=3) && (NR<=11)' linepat
CCC
CCC
CCC
EEE
EEE
EEE
EEE
FFF
FFF

# 14  
Old 09-06-2012
Something requirement related to above query,

i have a data like this

Code:
Thu Sep 6 02:15:54 2012->ABCServ(603):$Id: ABCServ.c,v 1.3 2006/08/24 20:52:17 rkaps 
Thu Sep 6 02:20:12 2012->ABCServ(603):$Id: ABCServ.c,v 1.3 2006/08/24 22:52:17 rkaps 
'
'
'
'
'
Thu Sep 6 23:15:54 2012->ABCChild(610):child attempting to open c-tree 02:24:20 rkaps

I want to retrieve the data(full record/all fields) between 02:00:00 to 03:00:00 based on the 4th column.
I am using the code like

Code:
awk '/0[2-2]:[0-2][0-9]:[0-9][0-9]/ || /[0-0][2-2]:[0-9][0-9]:[0-9][0-9]/,/0[2-2]:[0-2][0-9]:[0-9][0-9]/' filename

For the above query, its should not display the last record

Code:
Thu Sep 6 23:15:54 2012->ABCChild(610):child attempting to open c-tree 02:24:20 rkaps

How can i put the check for the above query.
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Get data from file using awk within strings.

i am having the text data file as below. Processing 1 a 111111 b c d e f Processing 2 a b 222222 c erorr d e f Processing 3 a b 3333 (1 Reply)
Discussion started by: expert
1 Replies

2. Shell Programming and Scripting

Retrieving sequence data from other file

Hello experts :cool:, I am new to programming and will need your help.. I have 2 very large files with the following format: FILE1: >MLP1019 PL4 >MLP7456 PL3 >MLP9268 PL9 >MLP6245 PL1 FILE2: >MLP1019 STNAPLQTSNTWVSYQPSMMMSLQ >MLP7456 PPYWYWNSAVMIFYVQPLSLLAVLLA >MLP9268... (2 Replies)
Discussion started by: narachaid
2 Replies

3. Shell Programming and Scripting

Retrieving data from 65th col (of each line) ?

Hello Friends, I am in situation where I have to note down few SQL queries from specific hexdump format. Here is an example (the query text starts at 65th character on each line) ---------------------- 0x000007FEB0E701C0 : 7365 6C65 6374 2063 7573 746E 6F2C 2020 select custno, ... (9 Replies)
Discussion started by: Sunusernewbie
9 Replies

4. Linux

Retrieving Data from VHD File (Virtual Machine Harddrive)

Hello, I had Gentoo installed on a Microsoft Windows Hyper-V virtual machine. The system shutdown properly but the RAID array on the drive it was on failed. We had a backup that was poorly configured and as such we didn't back up all of the data we needed. Therefore, after getting the RAID... (0 Replies)
Discussion started by: ckoeber
0 Replies

5. UNIX and Linux Applications

Retrieving data from a database and store to a file

Hi I'm using and Oracle 10g Database. I want to write a script to retrieve data from the database and store it toa file. I'm using simple sql statements such as Select * from celltable I don't know how to specify the database name etc. I have this but it doesn't work ... (1 Reply)
Discussion started by: ladyAnne
1 Replies

6. Shell Programming and Scripting

Extract and parse data between two strings

Hi , I have a billing CDR file which is separated by “!”. I need to extract and format data between the starting (“!”) and the end of the line (“1.2.1.8”). These two variables are permanent tags to show begin and end. ! TICKET NBR : 2 ! GSI : 101 ! 3100.2.112.1 24/03/2010 00:41:14 !... (3 Replies)
Discussion started by: jaygamini
3 Replies

7. Shell Programming and Scripting

Extract data between two strings

Hi , I have a billing CDR file which has repeated lines as indicated below and I need to extract data between two strings (i.e.: <?> and </?>). Eventually, map that information with the corresponding field. I'm new to unix, any help will be greatly appreciated. Gamini Input (single line): !... (3 Replies)
Discussion started by: jaygamini
3 Replies

8. Shell Programming and Scripting

Using loop reading a file,retrieving data from data base.

Hi All, I am having trouble through, I am reading the input from tab delimited file containing several records, e.g. line1 field1 field2 field3 so on.. line2 field1 field2 field3 so on.. .. .. on the basis of certain fields for each record in input file, I have to retrieve... (1 Reply)
Discussion started by: Sonu4lov
1 Replies

9. Shell Programming and Scripting

How to grab data between 2 strings ?

Hi All, I have a text file below. How do i grab all the data between "05T00NPQSMR1" and "****" using awk ? Pls note that the text lines may not be fixed and text content is dynamic. Pls help. Thanks Below is my code where $LOT_SUFFIX is my shell variable. awk '/'"$LOT_SUFFIX"'/,/blah/'... (16 Replies)
Discussion started by: Raynon
16 Replies

10. UNIX for Dummies Questions & Answers

Retrieving data

Friends, I have a data with 3 columns: 30 41 1 39 19 4 14 25 3 .... .... ..... I want to retrieve any data in the first column that is greater 15. What is the best way to do this? Thanks! (2 Replies)
Discussion started by: bobo
2 Replies
Login or Register to Ask a Question