Searching multiple patterns and construct SQL Post: 303014202

Sponsored Content

Top Forums Shell Programming and Scripting Searching multiple patterns and construct SQL Post 303014202 by RudiC on Wednesday 7th of March 2018 04:20:44 AM

03-07-2018

Registered User

How about

Code:

awk '
#                                       {gsub (/\r/, _)
#                                       }
match ($0, /tableName:[^,]*/)           {printf "Analyze Table %s ", substr ($0, RSTART+10, RLENGTH-10)
                                        }
match ($0, /partitionKeys:[[][^]]*]/)   {TMP = substr ($0, RSTART+15, RLENGTH-16)
                                         n   = gsub (/FieldSchema\(name:/, "\n", TMP)
                                         if (n) {printf "Partition ("
                                                 m = split (TMP, TARR, "\n")
                                                 for (i=2; i<=m; i++)   {sub (/,.*$/, _, TARR[i])
                                                                         printf "%s%s", TARR[i], i<m?",":""
                                                                        }
                                                 printf ") "
                                                }
                                         printf "Compute statistics;\n"
                                        }
' /tmp/describe_table_output.txt
Analyze Table tablea Compute statistics;
Analyze Table tableb Partition (partb) Compute statistics;
Analyze Table tablec Partition (partc1,partc2) Compute statistics;

Your files have non-*nix (DOS) line terminators (<CR> = 0x0D = \r = ^M), the commented-out gsub can take care of those should they irritate any algorithms.

This User Gave Thanks to RudiC For This Post:

RudiC

View Public Profile for RudiC

Find all posts by RudiC

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

searching for two or more patterns in a line

how can I search for two or more patterns in one line using grep? for example if I want to show only the lines that have patterns "abc" and "123"? and what if I want to show only the lines that have either "abc" or "123" in them? any hint apprecited

2. Shell Programming and Scripting

Searching patterns in 1 file and deleting all lines with those patterns in 2nd file

Hi Gurus, I have a file say for ex. file1 which has 3500 lines in it which are different account numbers and another file (file2) which has 230000 lines in it. I want to read all the lines in file1 and delete all those lines from file2 which has that same pattern as in file1. I am not quite...

3. Shell Programming and Scripting

Searching for multiple patterns in files

I have a situation where I need to search for multiple strings (error messages) such as 'aborted' 'file not found' etc in directory having logs. I have put all the error messages in a text file and using the command. grep -f <textfile> <filetobegrepped> I'm doing this thru a script where I...

4. Shell Programming and Scripting

Searching for multiple patterns in a file

Hi All, I have a file in which i have to search for a pattern from the beginning of the file and if the pattern is found , then i have to perform a reverse search from that line to the beginning of the file to get the first occurrence of another pattern. sample input file hey what are you...

5. Shell Programming and Scripting

Awk script searching patterns issue

Hi I am having a file like this FILE1 ##################### C16ROTINV_ REFCLK_RXL RXBCLK32_R REFCLK_TXL CLK8_TXLIN RXBCLK32_R DCLK_TXLIN CLK32D_TXL RXACLK32_R #####################

6. Shell Programming and Scripting

searching multiple patterns in perl

Hi, I have code like: Output it is comming as: Rels: WM2 Rels: WG2 Rels: 5 - pre/prods.pl Rels: 6 Rels: 7 Rels: 8 Rels: 10 Rels: Int But i want only "Rels: 5" pattern Just above "- pre/prods.pl". By...

7. Shell Programming and Scripting

print the next line by searching with different patterns

Hi, I am having an '.xml' file with 'n' number of lines and also having another file with '.txt' format contains values which i want to search. Now I want to print the next line with the pattern which i am searching in '.xml' file. And the loop has to repeat for different patterns which...

8. Shell Programming and Scripting

How to print the next line by searching with different patterns in AIX server?

9. UNIX for Dummies Questions & Answers

Help searching for patterns occuring near one another in document

I'm very new to unix and linux, so I apologize if the answer to this question should be obvious.. What I would like to know is, is there a way to search a text document ( opened in less, or some other text viewer) for any two or more patterns that appear near one another in the document? In...

10. Shell Programming and Scripting

Searching multiple patterns using awk

Hello, I have the following input file: qh1adm 20130710111201 : tp import all QH1 u6 -Dsourcesystems=BFI,EBJ qh1adm 20130711151154 : tp import all QH1 u6 -Dsourcesystems=BFI,EBJ qx1adm 20130711151154 : tp count QX1 u6 -Dsourcesystems=B17,E17,EE7 qh1adm 20130711151155 : tp import all...

LEARN ABOUT DEBIAN

shtool-mkln

SHTOOL-MKLN.TMP(1)					      GNU Portable Shell Tool						SHTOOL-MKLN.TMP(1)

NAME

       shtool-mkln - GNU shtool enhanced ln(1) replacement

SYNOPSIS

       shtool mkln [-t|--trace] [-f|--force] [-s|--symbolic] src-path [src-path ...]  dst-path

DESCRIPTION

       This is a ln(1) style command. It is enhanced to provide automatic calculation and usage of relative links with the shortest possible path,
       if possible. Usually if src-path and dst-path are not absolute paths or at least they share a common prefix except the root directory
       (``"/"''). When more than one src-path is specified, all of them are linked into dst-path.

OPTIONS

       The following command line options are available.

       -t, --trace
	   Enable the output of the essential shell commands which are executed.

       -f, --force
	   Force the creation of the link even if it exists. Default is to fail with error.

       -s, --symbolic
	   Create a symbolic link instead of a hard-link.

EXAMPLE

	#   shell script
	shtool mkln -s foo/bar baz/quux

HISTORY

       The GNU shtool fixperm command was originally written by Ralf S.  Engelschall <rse@engelschall.com> in 1998 for ePerl.

SEE ALSO

       shtool(1), ln(1).

18-Jul-2008							   shtool 2.0.8 						SHTOOL-MKLN.TMP(1)