Use awk to Extract a Column from a Text File
Here is an example of how to use awk to extract a column from a text file. The default field separator is a space, so this will work with some text files: cat somefile.txt | awk '{print $2}' But, if the fields are separated by a delimiter, such as tab, or comma, just specify the field separator by using "-F" before the print statement cat somefile.txt | awk -F"\t" '{print $2}' Unix and linux distributions generally come with sed and awk, among other things. The problem. You want to get a list of companies to research before investing in them, and paste only the stock symbols into a Yahoo finance portfolio. You run a stock screen on a site such as magicformulainvesting.com , or investors.com but if you try to paste the text into a spreadsheet it may show up as a single row, with no way to extract the column. Here is the process 1.) Run a Stock Screen Get output similar to this: Company Name (in alphabetical...