Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Searching for string between two different strings

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Searching for string between two different strings
# 1  
Old 03-11-2012
Searching for string between two different strings
I want to the following results using unix script, can some one help ? Thanks

Input:
Code:
select col1, col2 from tab1 where .........
select col1,.....,coln from tab2, tab3 where....
select clo1,clo2,col3 from tab4 where...


output (results)
Code:
tab1
tab2
tab3
tab4

basically I need the list of table names from list of select statements in a file.

Thank You,
Last edited by radoulov; 03-12-2012 at 03:59 AM.. Reason: Code tags!
# 2  
Old 03-12-2012
awk
Hi,
Welcome to the unix forum:-)

Try this,
Code:
awk '{str=substr($0,index($0,"from "),index($0,"where")-1);sub(/from /,"",str);split(str,a,",");for (i in a){print i;}}' file

Cheers,
Ranga:-)
Last edited by rangarasan; 03-12-2012 at 01:22 AM.. Reason: typo
This User Gave Thanks to rangarasan For This Post:
jim mcnamara
# 3  
Old 03-12-2012
Code:
perl -lne 'if(/from (.+?) where/g){$x=$1;$x=~s/ ?, ?/\n/g;print $x}' inputfile

# 4  
Old 03-12-2012
The perl code is working for my requirement. Thanks Rangarasan and balajesuri.
# 5  
Old 03-12-2012
Through Sed..
Code:
sed 'h;s/, */\n/g;s/.*from \(.*\) where.*/\1/' inputfile

# 6  
Old 03-12-2012
Code:
awk -F'from | where' '{$0=$2;gsub(/, /,RS)}1' infile

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Can I combine below mentioned grep commands using OR (when searching strings having spaces)

Command 1: $script | grep 'Write to ECC( SSID=MARGIN)' Command 2: $script | grep 'is not greater than existing logical processing' The above commands run my script and search the mentioned strings but I do not want to run my script twice. It is increasing run time. Can someone tell me... (3 Replies)
Discussion started by: Tanu
3 Replies

2. Programming

Hsearch() problem when searching for strings.

I have written a code in C where the objective is to search for strings. There are two files: 1. Database file which has more than one billion entries. This file is read in argv in the C code below. The format of the file is like this: a.txt apple b.txt candle c.txt glue 2. There is another... (1 Reply)
Discussion started by: shoaibjameel123
1 Replies

3. Shell Programming and Scripting

Searching for a list of strings in a file with Python

Hi guys, I'm trying to search for several strings, which I have in a .txt file line by line, on another file. So the idea is, take input.txt and search for each line in that file in another file, let's call it rules.txt. So far, I've been able to do this, to search for individual strings: ... (1 Reply)
Discussion started by: starriol
1 Replies

4. Shell Programming and Scripting

Searching for strings amongst non-uniform data

Hi Guys, I have a source file which contains significant strings amongst a lot of dross in non-uniform format, I'd like to search the input file for any examples of data from my reference file, and then output any matches to a list (text file). I've made something that achieves this, it's... (4 Replies)
Discussion started by: gazza86
4 Replies

5. Shell Programming and Scripting

Need help in searching 2 files for strings then perform an action

I have 2 files. I basically want to search both of them to see if the 1st column ($1) matches and if it matches then check to see if the 2nd column ($2) matches, then execute some code showing the results of the matches. File 1: AAA 123 misc blah BBB 456 CCC 789 File 2: ... (2 Replies)
Discussion started by: streetfighter2
2 Replies

6. Solaris

higlighting strings while searching

Hello experts, i am using sun solaris 9 i try to searching string from a file using more command. I wish when i search a string it will higlight the string/strings from the file. Have any idea how to do it..? I use putty. br//purple (9 Replies)
Discussion started by: thepurple
9 Replies

7. Shell Programming and Scripting

Extracting a string from one file and searching the same string in other files

Hi, Need to extract a string from one file and search the same in other files. Ex: I have file1 of hundred lines with no delimiters not even space. I have 3 more files. I should get 1 to 10 characters say substring from each line of file1 and search that string in rest of the files and get... (1 Reply)
Discussion started by: mohancrr
1 Replies

8. Shell Programming and Scripting

How to concatenate two strings or several strings into one string in B-shell?

like connect "summer" and "winter" to "summerwinter"? Can anybody help me? thanks a lot. (2 Replies)
Discussion started by: fontana
2 Replies

9. Shell Programming and Scripting

searching for filenames with search strings in another file

Hi, I have 5 files in a directory. emp1_usage.txt emp2_usage.txt emp3_usage.txt emp4_usage.txt emp5_usage.txt I am using sqlldr to get the contents of the above 5 files and store it in a temp table and update my original table using temp table. for f in *emp*.txt do sqlldr... (3 Replies)
Discussion started by: pathanjalireddy
3 Replies

10. UNIX for Dummies Questions & Answers

searching for strings/user IP addresses

Hi, I'm trying to write a script, which will perform the following actions. Pick up the IP address of the PC I have used to telnet into the SUN server. Export this. Run the rest of my script. I am struggling with the first part, I know the IP address can be displayed by the command... (2 Replies)
Discussion started by: 30694
2 Replies
Login or Register to Ask a Question