search

sr320 / course-fish546-2016

6 stars 5 forks source link

Problems with awk command #98

Open aspanjer opened 7 years ago

aspanjer commented 7 years ago

I'm having a problem getting awk to print the first column of data in tab deliminated files. When i run:

awk '{print $1}' lookup.txt

it only returns the first cell or line, instead of listing everything in the column. I've searched google, but every forum seems to say the simple code above is how to extract a single column?

lookup.txt

sr320 commented 7 years ago

can you try on this one?

lookup.txt

sr320 commented 7 years ago

Tell the truth... how did you create that file? 😈

Explanation: line breaks need to be unix- Sam hinted at this yesterday when he talked about line breaks in Windows.

see http://d.pr/i/lz91

aspanjer commented 7 years ago

Thanks!

I edited it in textWrangler from the original .csv file, but I didn't switch the line formatting to Unix.

sr320 commented 7 years ago

But where did the original .csv come from?

On Fri, Dec 2, 2016 at 10:04 AM aspanjer notifications@github.com wrote:

Thanks!

I edited it in textWrangler from the original .csv file, but I didn't switch the line formatting to Unix.

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/sr320/course-fish546-2016/issues/98#issuecomment-264520124, or mute the thread https://github.com/notifications/unsubscribe-auth/AEPHt9kr016Vf3UfwyjN4f4HUsqxSbqHks5rEF13gaJpZM4LCzkT .

aspanjer commented 7 years ago

Definitely excel! It's the lookup table from the sequencing facility.