Sponsored Content
Full Discussion: search for columns
Top Forums Shell Programming and Scripting search for columns Post 302237082 by era on Wednesday 17th of September 2008 01:22:56 AM
Old 09-17-2008
If your awk has the toupper function, you can use that to do case-insensitive comparisons.

Code:
awk 'toupper($0) ~ /CREATE TABLE /{table=$2; start=0; }
toupper($0) ~ /START_DT/ { start++ }
toupper($0) ~ /END_DT/ && start  { print table }' file

This creates an uppercase version of the input line, and compares that against the regular expressions. (I suppose it would be more economical to only invoke toupper once. If this is a time-critical operation, we can look at that.)
 

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
KICONV(3)						   BSD Library Functions Manual 						 KICONV(3)

NAME
kiconv_add_xlat16_cspair, kiconv_add_xlat16_cspairs, kiconv_add_xlat16_table -- kernel side iconv library LIBRARY
Kernel side iconv library (libkiconv, -lkiconv) SYNOPSIS
#include <sys/iconv.h> int kiconv_add_xlat16_cspair(const char *tocode, const char *fromcode, int flag); int kiconv_add_xlat16_cspairs(const char *foreigncode, const char *localcode); int kiconv_add_xlat16_table(const char *tocode, const char *fromcode, const void *data, int datalen); DESCRIPTION
The kiconv library provides multi-byte character conversion tables for kernel side iconv service. The kiconv_add_xlat16_cspair() function defines a conversion table using iconv(3) between fromcode charset and tocode charset. You can spec- ify flag to determine if tolower(3) / toupper(3) conversion is included in the table. The flag has following values. KICONV_LOWER KICONV_FROM_LOWER It generates a tolower table in addition to a character conversion table. The difference between two is tolower tocode or tolower fromcode. KICONV_UPPER KICONV_FROM_UPPER It generates a toupper table in addition to a character conversion table. The difference between two is toupper tocode or toupper fromcode. A tolower/toupper conversion is limited to single-byte characters. The kiconv_add_xlat16_cspairs() function defines two conversion tables which are from localcode to foreigncode and from foreigncode to localcode. These conversion tables also contain both tolower and toupper tables. The kiconv_add_xlat16_table() function defines a conversion table directly pointed by data whose length is datalen, not using iconv(3). SEE ALSO
iconv(3), tolower(3), toupper(3) BSD
July 17, 2003 BSD
All times are GMT -4. The time now is 11:51 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy