Creating a condensed table from a pre-existing table in putty

Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Creating a condensed table from a pre-existing table in putty
# 1  
Old 05-11-2012
Bug Creating a condensed table from a pre-existing table in putty

I'm working with putty on Windows 7 professional and I'd like to know if there's a way to gather specific lines from a pre-existing table and make a new table with that information.

More specifically, I'd like the program to look at a specific column, say column N, and see if any of the rows in the column contain specific words (i.e. from this_is_what_i'm_looking_for, I'd like to to find all the rows in the colum that contain this_is), and print all these rows in a new table that I can save.

I can do this using Excel, but I'd like to know if there's a way to do it using putty.

Thank you.
# 2  
Old 05-12-2012
What kind of table? text, db2, sql server, oracle?
# 3  
Old 05-14-2012
.txt or .xlsx
# 4  
Old 05-14-2012
putty is a terminal. It talks to servers. It doesn't do text manipulation.

What does this .txt file look like?
# 5  
Old 05-15-2012
I figured out what to do in order to make my program do what I want it to do:

vi (gets you to the VIM program)

e: filename.txt (opens up the text file you want to manipulate)

:%g!/searchwords/d (looks for the words you are searching for in your document, and deletes any row that doesn't contain this information)

:w newfilename.txt (saves the information left over (the info you are looking for) as a new text file)

So, let's say this is my newfilename.txt document:

1234    someinfo1    moreinfo1, 1235
1236    someinfo2    moreinfo2, 1238
1239    someinfo3    moreinfo3, 5793

and I have some other text file called othertextfile.txt that looks like this:

1235    someinfo4    moreinfo4
1238    someinfo5    moreinfo5
5793    someinfo6    moreinfo6

and I want my program to go through newfilename.txt and look at all the numbers found in the third column of the first file (1235, 1238, 5793) and output the corresponding 3rd column in the second file, for each one

the third column of the first file has the numbers 1235, so it would find 1235 in the second file and output 1235 moreinfo4.

I'd like to continue using vi if possible

Thank you

Moderator's Comments:
Mod Comment Code tags for code, please.
# 6  
Old 05-15-2012
vi isn't a programming language, it's a text editor, something like awk would probably be better suited.

You haven't shown what you want the output data to look like, would you please do so?

You still haven't said what your system and shell is. Whatever it is, it's not "PUTTY". If you don't know, echo $SHELL ; uname -a

Lastly, is this data tab-separated?

Once you start answering our questions, we can help you.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Web Development

Getting Rid of Annoying Bootstrap Table Borders and Wayward Table Lines

Bootstrap is great; but we have had some issues with Bootstrapped <tables> (and legacy <fieldset> elements) showing annoying, wayward lines. I solved that problem today with this simple jQuery in the footer: <script> $(function(){ $('tr, td, fieldset,... (0 Replies)
Discussion started by: Neo
0 Replies

2. Shell Programming and Scripting

awk to convert table-by-row to matrix table

Hello, I need some help to reformat this table-by-row to matrix? infile: site1 A:o,p,q,r,s,t site1 C:y,u site1 T:v,w site1 -:x,z site2 A:p,r,t,v,w,z site2 C:u,y site2 G:q,s site2 -:o,x site3 A:o,q,s,t,u,z site3 C:y site3 T:v,w,x site3 -:p,routfile: SITE o p q r s t v u w x y... (7 Replies)
Discussion started by: yifangt
7 Replies

3. UNIX and Linux Applications

Help in copying table structure to another table with constraints in Oracle

hi, i need to copy one table with data into another table, right now am using create table table1 as select * from table2 i want the constraints of table1 to be copied to table2 also , can anyone give me some solution to copy the constraints also, now am using oracle (1 Reply)
Discussion started by: senkerth
1 Replies

4. Shell Programming and Scripting

Build a table from a list by comparing existing table entries

I am new to this shell scripting.... I have a file which contains list of users. This files get updated when new user comes into the system. I want to create script which will give a table containing unique list of users. When I say unique, it means script should match table while parsing... (3 Replies)
Discussion started by: dchavan1901
3 Replies

5. UNIX and Linux Applications

create table via stored procedure (passing the table name to it)

hi there, I am trying to create a stored procedure that i can pass the table name to and it will create a table with that name. but for some reason it creates with what i have defined as the variable name . In the case of the example below it creates a table called 'tname' for example ... (6 Replies)
Discussion started by: rethink
6 Replies

6. Shell Programming and Scripting

Creating a table

I have a file like below Iter 1: Best Model = 10.0 12.0 13.0 17.0 23.3 78.7 Iter 2: Best Model = 10.0 20.0 30.0 40.0 50.0 60.0 Iter 3: Best Model = 27.3 46.3 84.5 23.0 34.5 35.4 etc I want to use a scipts using csh or awk to select the iteration number and show the numbers in a table... (2 Replies)
Discussion started by: kristinu
2 Replies

7. Shell Programming and Scripting

select values from db1 table and insert into table of DB2

Hi I am having three oracle databases running in three different machine. their ip address is different. from one of the DB am able to access both the databases.(means am able to select values and insert values in to tables individually.) I need to fetch some data from DB1 table(say DB1 ip is... (2 Replies)
Discussion started by: aemunathan
2 Replies

8. Shell Programming and Scripting

Creating table in Unix

Hi All, In a given directory, I need to list the files present in it in the below given format as a table. File name Permission Number of Bytes File Type Telecom1 --w-r-x 1230 Directory Telecom2 ---x---x---x 450 Device file Telecom3 ... (7 Replies)
Discussion started by: mr_manii
7 Replies

9. Shell Programming and Scripting

Check the record count in table (table in oracle)

I have requirement: 1) Check the record count in table (table in oracle) 2) If records exists generate the file for existing records and wait for some time (Go to sleep mode) and Again check the record count after 10 min.......... (Loop this process if record count >0). 3) Generate touch... (1 Reply)
Discussion started by: kamineni
1 Replies

10. Programming

Creating a Hash Table

Dear Friends, I want to create a hash table using the standard Glib header (if possible) so that I can store a structure and keep the hash key(search key) based on a string. Any example code would be great since I am not able to get the main idea. best regards Skull (4 Replies)
Discussion started by: callmetheskull
4 Replies
Login or Register to Ask a Question

Featured Tech Videos