Sponsored Content
Full Discussion: Excluding the unwanted rows
Top Forums Shell Programming and Scripting Excluding the unwanted rows Post 302965813 by rocking77 on Wednesday 3rd of February 2016 10:19:56 AM
Old 02-03-2016
Rudi ,

I m trying to fetch the content from column (Tablename).

Let me refine my requirement .

below is query result.
Code:
# Of Versioned Tables         6
     Total # Of Versions      12

       Database        | Schema |           Table Name           |   
-----------------------+--------+--------------------------------+---
 GK_AMP             | ADMIN  | AGG_BUS_PRO_JAN
 GK_AMP          | ADMIN  | AGG_BUS_PRO_MTD
 GK_AMP          | ADMIN  | AGG_BUS_PRO_QTD
 GK_AMP          | ADMIN  | AGG_BUS_PRO_R12
 GK_AMP          | ADMIN  | AGG_BUS_PRO_YTD
 GK_AMP          | ADMIN  | AGG_BUS_PRO_YTD
(6 rows)

Out of that result i am trying to write another SQL like ..


XXXXX $Database . $ Table Name for n number of rows under columns Database & Table Name

Last edited by rocking77; 02-03-2016 at 11:35 AM..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Remove unwanted data?

Hi Can any one help me remove the unwanted data? I would want to remove the complete event id 4910 ( the type there is INFO), that means, I have to remove starting from 7th - 19th lines. can any one of you please help? Thanks, (24 Replies)
Discussion started by: hitmansilentass
24 Replies

2. Shell Programming and Scripting

Filter unwanted lines

Hi All, I have the below input and i only want to filter out some un-wanted info from here. Expected output is below. Can somebody help ? The catch is that i want to grep those lines with term "k=" and lines with term "**" as the 1st column and "07" as the last column. And the number of... (15 Replies)
Discussion started by: Raynon
15 Replies

3. OS X (Apple)

OS/X 10.4 Deleting unwanted applications

What is the correct way to delete unwanted applications from a MACbook running OS/X 10.4.1.1. It is sufficient to drag and drop from Applications folder to Trash, then clear Trash? (2 Replies)
Discussion started by: methyl
2 Replies

4. Shell Programming and Scripting

Deleting specific rows in large files having rows greater than 100000

Hi Guys, I need help in modifying a large text file containing more than 1-2 lakh rows of data using unix commands. I am quite new to the unix language the text file contains data in a pipe delimited format sdfsdfs sdfsdfsd START_ROW sdfsd|sdfsdfsd|sdfsdfasdf|sdfsadf|sdfasdf... (9 Replies)
Discussion started by: manish2009
9 Replies

5. Shell Programming and Scripting

Remove unwanted lines

I have a .xml file, where i need some output. The xml file is like: Code: <?******?></ddddd><sssss>234</dfdffsdf><sdhjh>534</dfdfa>......... /Code I need the output like: code 234 534 . . . /code How can i do it? (5 Replies)
Discussion started by: anupdas
5 Replies

6. Shell Programming and Scripting

grep out unwanted lines

Hi, I got a log file and I want to grep out a list of unwanted line which are IP's. Basiclly I want everything ecxept the ip's from my list. If I do a while read line do grep -v $ip_from_my_list logfile done <ip_list it just grep's one IP at a time and repeats. :( Thanks for... (3 Replies)
Discussion started by: stinkefisch
3 Replies

7. Shell Programming and Scripting

Split single rows to multiple rows ..

Hi pls help me out to short out this problem rm PAB113_011.out rm: PAB113_011.out: override protection 644 (yes/no)? n If i give y it remove the file. But i added the rm command as a part of ksh file and i tried to remove the file. Its not removing and the the file prompting as... (7 Replies)
Discussion started by: sri_aue
7 Replies

8. Shell Programming and Scripting

get rid of unwanted lines

Hi , My output contains the below contents When i execute df -h | grep / | grep -v '^Filesystem|tmpfs|cdrom' | awk '{ print $5 " " $1 }' i get output as below tpshghghg.fgh.com:/vol/scmvol1/scm-vobstore/WebArch.vbs 1.7T 1.3T 452G 74% /vob/WebArch... (6 Replies)
Discussion started by: ptappeta
6 Replies

9. UNIX for Dummies Questions & Answers

merging rows into new file based on rows and first column

I have 2 files, file01= 7 columns, row unknown (but few) file02= 7 columns, row unknown (but many) now I want to create an output with the first field that is shared in both of them and then subtract the results from the rest of the fields and print there e.g. file 01 James|0|50|25|10|50|30... (1 Reply)
Discussion started by: A-V
1 Replies

10. Shell Programming and Scripting

Moving or copying first rows and last rows into another file

Hi I would like to move the first 1000 rows of my file into an output file and then move the last 1000 rows into another output file. Any help would be great Thanks (6 Replies)
Discussion started by: kylle345
6 Replies
Goo::Canvas::Table(3pm) 				User Contributed Perl Documentation				   Goo::Canvas::Table(3pm)

NAME
Goo::Canvas::Table - wrapper for GooCanvasTable HIERARCHY
Glib::Object +----Goo::Canvas::ItemSimple +----Goo::Canvas::Group +----Goo::Canvas::Table INTERFACES
Goo::Canvas::Item METHODS
item = Goo::Canvas::Table->new ($parent, ...) o $parent (Goo::Canvas::Item) o ... (list) PROPERTIES
'column-spacing' (double : default 0 : readable / writable) The default space between columns 'homogeneous-columns' (boolean : default false : readable / writable) If all columns are the same width 'homogeneous-rows' (boolean : default false : readable / writable) If all rows are the same height 'horz-grid-line-width' (double : default 0 : readable / writable) The width of the grid line to draw between rows 'row-spacing' (double : default 0 : readable / writable) The default space between rows 'vert-grid-line-width' (double : default 0 : readable / writable) The width of the grid line to draw between columns 'x-border-spacing' (double : default 0 : readable / writable) The amount of spacing between the lefmost and rightmost cells and the border grid line 'y-border-spacing' (double : default 0 : readable / writable) The amount of spacing between the topmost and bottommost cells and the border grid line SEE ALSO
Glib::Object, Goo::Canvas::ItemSimple, Goo::Canvas::Group COPYRIGHT
Copyright (C) 2011 Gtk2-Perl Team perl v5.14.2 2011-11-16 Goo::Canvas::Table(3pm)
All times are GMT -4. The time now is 02:07 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy