Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: 4 column tsv file, output 1 specific column
Top Forums Shell Programming and Scripting 4 column tsv file, output 1 specific column Post 302257592 by casphar on Wednesday 12th of November 2008 03:04:41 PM
Old 11-12-2008
Thanks, the tr and cut command seems to be doing the trick. I did notice a few results missed the correct entry but this may be due to bad formating in the tsv file?

thanks

Quote:
Originally Posted by joeyg
So, if your input file was slightly different, you might not get your desired results with a 'plain' awk. See below where there is a single space between the month and a number:

Code:
> cat file66c.tsv
13      Oct 1   Joe     smile
18      Jan 2   Linda   laugh
11      Nov 3   Vets    march

> cat file66c.tsv | tr "\t" "~" | cut -d"~" -f2
Oct 1
Jan 2
Nov 3

> cat file66c.tsv | awk '{print $2}'
Oct
Jan
Nov

 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Question about sort specific column and print other column at the same time !

Hi, This is my input file: ali 5 usa abc abu 4 uk bca alan 6 brazil bac pinky 10 utah sdc My desired output: pinky 10 utah sdc alan 6 brazil bac ali 5 usa abc abu 4 uk bca Based on the column two, I want to do the descending order and print out other related column at the... (3 Replies)
Discussion started by: patrick87
3 Replies

2. UNIX for Dummies Questions & Answers

Replacing a specific column of a text file with another column

I have a text file in the following format: 13412 NA06985 0 0 2 46.6432798439 4 4 4 4 13412 NA06991 NA06993 NA06985 2 48.8478948517 4 4 2 4 13412 NA06993 0 0 1 45.8022601455 4 4 2 4 13401 NA06994 0 0 1 48.780669145 4 4 4 4 13401 NA07000 0 0 2 47.7312017846 2 4 4 4 13402 NA07019... (3 Replies)
Discussion started by: evelibertine
3 Replies

3. UNIX for Dummies Questions & Answers

Replacing a specific column of a text file with another column

Hi, I have a text file in the following format: Code: 13412 NA06985 0 0 2 46.6432798439 4 4 4 4 13412 NA06991 NA06993 NA06985 2 48.8478948517 4 4 2 4 13412 NA06993 0 0 1 45.8022601455 4 4 2 4 13401 NA06994 0 0 1 48.780669145 4 4 4 4 13401 NA07000 0 0 2 47.7312017846 2 4 4 4 ... (2 Replies)
Discussion started by: evelibertine
2 Replies

4. Shell Programming and Scripting

Replace column that matches specific pattern, with column data from another file

Can anyone please help with this? I have 2 files as given below. If 2nd column of file1 has pattern foo1@a, find the matching 1st column in file2 & replace 2nd column of file1 with file2's value. file1 abc_1 foo1@a .... abc_1 soo2@a ... def_2 soo2@a .... def_2 foo1@a ........ (7 Replies)
Discussion started by: prashali
7 Replies

5. Shell Programming and Scripting

Awk: Need help replacing a specific column in a file by part of a column in another file

Hi, I have two input files as File1 : ABC:client1:project1 XYZ:client2-aa:project2 DEF:client4:proj File2 : client1:W-170:xx client2-aa:WT-04:yy client4:L-005A:zz Also, array of valid values can be hardcoded like Output : ABC:W:project1 XYZ:WT:project2 (1 Reply)
Discussion started by: aa2601
1 Replies

6. Shell Programming and Scripting

Split each column in TSV file to be new line?

My TSV looks like: Hello my name is John \t Hello world \t Have a good day! \t See you later! Is there a simple bash script that splits the tsv on tab to: Hello my name is John Hello world Have a good day! See you later! I'm really stuck, would appreciate any help! (5 Replies)
Discussion started by: pxalpine
5 Replies

7. Shell Programming and Scripting

Converting Single Column into Multiple rows, but with strings to specific tab column

Dear fellows, I need your help. I'm trying to write a script to convert a single column into multiple rows. But it need to recognize the beginning of the string and set it to its specific Column number. Each Line (loop) begins with digit (RANGE). At this moment it's kind of working, but it... (6 Replies)
Discussion started by: AK47
6 Replies

8. Shell Programming and Scripting

Counting specific column and add result in output

Hi all, I have a quick question: I have a 4 column tab-separated file. I want to count the number of times each unique value in column 2 appears and add that number in a 5th column. I have the following input file: waterline-n below-sheath-v 14.8097 A dock-n below-sheath-v ... (4 Replies)
Discussion started by: owwow14
4 Replies

9. Shell Programming and Scripting

Overwrite specific column in xml file with the specific column from adjacent line

I have an xml file dumped from rrd file, that I want to "patch" so the xml file doesn't contain any blank hole in the resulting graph of the rrd file. Here is the file. <!-- 2015-10-12 14:00:00 WIB / 1444633200 --> <row><v> 4.0419731265e+07 </v><v> 4.5045912770e+06... (2 Replies)
Discussion started by: rk4k
2 Replies

LEARN ABOUT DEBIAN

sqlline

SQLLINE:(1)							   User Commands						       SQLLINE:(1)

NAME

       sqlline - JDBC command-line utility for issuing SQL

SYNOPSIS

       sqlline [ option... ]

DESCRIPTION

       -u <database url>
	      the JDBC URL to connect to

       -n <username>
	      the username to connect as

       -p <password>
	      the password to connect as

       -d <driver class>
	      the driver class to use

       --color=[true/false]
	      control whether color is used for display

       --showHeader=[true/false]
	      show column names in query results

       --headerInterval=ROWS;
	      the interval between which heades are displayed

       --fastConnect=[true/false]
	      skip building table/column list for tab-completion

       --autoCommit=[true/false]
	      enable/disable automatic transaction commit

       --verbose=[true/false]
	      show verbose error messages and debug info

       --showWarnings=[true/false]
	      display connection warnings

       --force=[true/false]
	      continue running script even after errors

       --maxWidth=MAXWIDTH
	      the maximum width of the terminal

       --maxColumnWidth=MAXCOLWIDTH
	      the maximum width to use when displaying columns

       --silent=[true/false]
	      be more silent

       --autosave=[true/false]
	      automatically save preferences

       --outputformat=[table/vertical/csv/tsv]
	      format mode for result display

       --isolation=LEVEL
	      set the transaction isolation level

       --help display this message

       Usage: java sqlline.SqlLine

       -u <database url>
	      the JDBC URL to connect to

       -n <username>
	      the username to connect as

       -p <password>
	      the password to connect as

       -d <driver class>
	      the driver class to use

       --color=[true/false]
	      control whether color is used for display

       --showHeader=[true/false]
	      show column names in query results

       --headerInterval=ROWS;
	      the interval between which heades are displayed

       --fastConnect=[true/false]
	      skip building table/column list for tab-completion

       --autoCommit=[true/false]
	      enable/disable automatic transaction commit

       --verbose=[true/false]
	      show verbose error messages and debug info

       --showWarnings=[true/false]
	      display connection warnings

       --force=[true/false]
	      continue running script even after errors

       --maxWidth=MAXWIDTH
	      the maximum width of the terminal

       --maxColumnWidth=MAXCOLWIDTH
	      the maximum width to use when displaying columns

       --silent=[true/false]
	      be more silent

       --autosave=[true/false]
	      automatically save preferences

       --outputformat=[table/vertical/csv/tsv]
	      format mode for result display

       --isolation=LEVEL
	      set the transaction isolation level

       --help display this message

       -u <database url>
	      the JDBC URL to connect to

       -n <username>
	      the username to connect as

       -p <password>
	      the password to connect as

       -d <driver class>
	      the driver class to use

       --color=[true/false]
	      control whether color is used for display

       --showHeader=[true/false]
	      show column names in query results

       --headerInterval=ROWS;
	      the interval between which heades are displayed

       --fastConnect=[true/false]
	      skip building table/column list for tab-completion

       --autoCommit=[true/false]
	      enable/disable automatic transaction commit

       --verbose=[true/false]
	      show verbose error messages and debug info

       --showWarnings=[true/false]
	      display connection warnings

       --force=[true/false]
	      continue running script even after errors

       --maxWidth=MAXWIDTH
	      the maximum width of the terminal

       --maxColumnWidth=MAXCOLWIDTH
	      the maximum width to use when displaying columns

       --silent=[true/false]
	      be more silent

       --autosave=[true/false]
	      automatically save preferences

       --outputformat=[table/vertical/csv/tsv]
	      format mode for result display

       --isolation=LEVEL
	      set the transaction isolation level

       --help display this message

sqlline 							    August 2008 						       SQLLINE:(1)
All times are GMT -4. The time now is 03:14 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy