Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: search for columns
Top Forums Shell Programming and Scripting search for columns Post 302237159 by akil on Wednesday 17th of September 2008 06:17:34 AM
Old 09-17-2008
Hi Era,
Thanks your great help .This waht I am looking ,Thanks a lot.

Code:
Perl script which posted by summer_cherry its not working ,
temp[6] && $temp[8] {5th and 7th fields) 
If Date columns may be different sequence
in some of the tables,In this case how can the below script can work?

ex:

Create table ..
cd1  char(10),
start_dt date,
desc varcha(200),
end_dt date));

##

undef $/;
open FH,"<file.txt";
while(<FH>){
        @arr=split("CREATE",$_);
        for($i=0;$i<=$#arr;$i++){
                $arr[$i]=~tr/\n/ /;
		@temp=split(" ",$arr[$i]);
		if($temp[6] eq "START_DT" && $temp[8] eq "END_DT"){
			print "Tablename:",$temp[1],"\n";
		}
	}
}
close(FH);
###

Thanks,
Akil
Last edited by akil; 09-17-2008 at 11:20 AM..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Need help in AWK;Search String and rearrange columns

Hi AWK Experts, file1.txt contains: 29b11b820ddcc:-|OHad.perWrk|spn_id=AH111|spn_ordtyp=MY_REQ|msg_typ=ah.ntf.out|spn_ordid=928176|spn_nid=3|msg_strt=1175615334703|msg_que=oput|diff=371|17:48:55,074|17:48:55,084|10 file2.txt contains:... (2 Replies)
Discussion started by: spring_buck
2 Replies

2. UNIX for Dummies Questions & Answers

Can I search columns and print lines?

Hi. First post here. I'm relatively new to UNIX (Solaris8) and writing my first real script, but I seem to have hit a brick wall. The odd thing is that it seems like it should be a simple task....but not with UNIX apparently. I've got a large text file: 14000 lines with 10 columns. I want... (2 Replies)
Discussion started by: Ant1815
2 Replies

3. Shell Programming and Scripting

awk/sed search lines in file1 matching columns in file2

Hi All, as you can see I'm pretty new to this board. :D I'm struggling around with small script to search a few fields in another file. Basically I have file1 looking like this: 15:38:28 sz:10001 pr:14.16 15:38:28 sz:10002 pr:18.41 15:38:29 sz:10003 pr:19.28 15:38:30 sz:10004... (1 Reply)
Discussion started by: floripoint
1 Replies

4. UNIX for Dummies Questions & Answers

Search for & edit rows & columns in data file and pipe

Dear unix gurus, I have a data file with header information about a subject and also 3 columns of n rows of data on various items he owns. The data file looks something like this: adam peter blah blah blah blah blah blah car 01 30 200 02 31 400 03 57 121 .. .. .. .. .. .. n y... (8 Replies)
Discussion started by: tintin72
8 Replies

5. Shell Programming and Scripting

Search multiple columns in each row

Hi All, I have to search in multiple columns for multiple values, if the match is found then print the values as below. Eg: cat t1 Z|VLD_AB_P|VLD_CD_P|VLD_EF_F|VLD_GH_F|100 Y|VLD_AB_F|VLD_CD_F|VLD_EF_P|VLD_GH_P|101 if then print "Invalid AB in $6" if then print "Invalid CD in... (6 Replies)
Discussion started by: gsjdrr
6 Replies

6. Shell Programming and Scripting

awk help to search columns in two files

Hello, I'm trying to compare multiple columns between two files. I would like to use columns 1,2 from file1 and search file2 in columns 2,3 for any matches. If they match, then print columns 2,3 from file2. file1 11:22:33:44:55:66|2010-07-25 12:30|xyz 22:22:22:22:22:22|2010-07-25... (5 Replies)
Discussion started by: pinseeker
5 Replies

7. Shell Programming and Scripting

Search based on 1,2,4,5 columns and remove duplicates in the same file.

Hi, I am unable to search the duplicates in a file based on the 1st,2nd,4th,5th columns in a file and also remove the duplicates in the same file. Source filename: Filename.csv "1","ccc","information","5000","temp","concept","new" "1","ddd","information","6000","temp","concept","new"... (2 Replies)
Discussion started by: onesuri
2 Replies

8. Shell Programming and Scripting

Need to search string from file 1 in one of columns of file 2

hello all. I would like to kindly ask you, if you could help me out with one problem. I have two files -> for ex. file1 and file2 file1 contains only various numbers file 2 contains multiple columns with various values What i need is to take every single number, one by one, from file 1 and... (3 Replies)
Discussion started by: wiety
3 Replies

9. Shell Programming and Scripting

Always output 6 columns regardless of search results

If I am searching for AA then then BB in a loop, how do I make the output always contain 6 columns of comma separated data even when there may only be 4 search matches? AA11 AA12 AA13 AA14 BB11 BB12 BB13 BB14 BB15 BB16 Final output: AA11,AA12,AA13,AA14,,,... (14 Replies)
Discussion started by: jojojmac5
14 Replies

10. UNIX for Advanced & Expert Users

Search for columns with numbers greater than 70

This helped get me started. https://www.unix.com/unix-for-dummies-questions-and-answers/157026-need-command-search-numbers-greater-than-3000-a.html This is the command I am using. I am trying to find numbers greater than 70 in column 5. I do not know if it is getting confused because there... (6 Replies)
Discussion started by: cokedude
6 Replies

LEARN ABOUT OPENSOLARIS

hal-find

hal-find(1M)						  System Administration Commands					      hal-find(1M)

NAME

       hal-find, hal-find-by-capability, hal-find-by-property - search HAL global device list

SYNOPSIS

       hal-find-by-capability --capability capability [--help]
	[--verbose] [--version]

       hal-find-by-property  --key key --string value [--help]
	[--verbose] [--version]

DESCRIPTION

       The  hal-find  commands, hal-find-by-capability and hal-find-by-property, search the Hardware Abstraction Layer (HAL) device list by speci-
       fied criteria and displays results on the standard output. hal-find-by-capability searches by capability, such as  volume  or  block.  hal-
       find-by-property searches by property, such as block.is_volume or volume.disc.has_audio.

OPTIONS

       The following options are supported:

       --capability capability	  HAL device capability to search for.

       --help			  Display list of options.

       --key key		  The key to the property that is the basis of the search.

       --string value		  The string value associated with the property that is the basis of the search.

       --verbose		  Verbose mode.

       --version		  Display version and exit.

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWhalr			   |
       +-----------------------------+-----------------------------+
       |Interface Stability	     |Volatile			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       hald(1M), attributes(5), hal(5)

SunOS 5.11							    22 Aug 2006 						      hal-find(1M)
All times are GMT -4. The time now is 01:13 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy