UNIX for Dummies Questions & Answers

Hello,
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.

What kind of table? text, db2, sql server, oracle?

.txt or .xlsx

putty is a terminal. It talks to servers. It doesn't do text manipulation.

What does this .txt file look like?

Hello,
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:

Code:

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:

Code:

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

i.e.
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:

Code tags for code, please.

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.