Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: To print the 1st column using sed
Top Forums UNIX for Dummies Questions & Answers To print the 1st column using sed Post 302537386 by ctsgnb on Friday 8th of July 2011 03:45:23 AM
Old 07-08-2011
To print only column 3 & 4 in a tab separated file:

Code:
awk -F"\t" '{print $3 FS $4}' yourfile

Regarding good Unix books, just go here
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Strings from one file which exactly match to the 1st column of other file and then print lines.

Hi, I have two files. 1st file has 1 column (huge file containing ~19200000 lines) and 2nd file has 2 columns (small file containing ~6000 lines). ################################# huge_file.txt a a ab b ################################## small_file.txt a 1.5 b 2.5 ab ... (4 Replies)
Discussion started by: AshwaniSharma09
4 Replies

2. Shell Programming and Scripting

print first few lines, then apply regex on a specific column to print results.

abc.dat tty cpu tin tout us sy wt id 0 0 7 3 19 71 extended device statistics r/s w/s kr/s kw/s wait actv wsvc_t asvc_t %w %b device 0.0 133.2 0.0 682.9 0.0 1.0 0.0 7.2 0 79 c1t0d0 0.2 180.4 0.1 5471.2 3.0 2.8 16.4 15.6 15 52 aaaaaa1-xx I want to skip first 5 line... (4 Replies)
Discussion started by: kchinnam
4 Replies

3. Shell Programming and Scripting

sed/awk to update 1st column if condition met

Hi, I am trying to update the 1st column of a file but only if it contains a char here is an example of my file 1111aaa 9999 textaaa 22222bbb 9999 textbbb 3333 9999 textccc 444ddd 9999 textddd i would like the output to remove any characters () from... (5 Replies)
Discussion started by: plennon
5 Replies

4. Shell Programming and Scripting

Using sed on 1st column of tab delimited file

Hi all, I'm new to Unix and work primarily in bioinformatics. I am in need of a script which will allow me to replace "1" with "chr1" in only the first column of a file which looks like such: 1 10327 rs112750067 T C . PASS ASP;RSPOS=10327;... (4 Replies)
Discussion started by: Hkins552
4 Replies

5. Shell Programming and Scripting

AWK/SED print if 2nd character in a column is greater than 0

We have an access log where column 8 displays the time in seconds like below: Tj8nQAoNgwsAABov9cIAAAFL - 10.13.131.80 - - (0) - "GET /aaaaa/bbbb/bbbb where column 8 is printed (0). We are trying to find how many entries are there that has column 8 greater than 0. Remember $8 is (0) and not... (5 Replies)
Discussion started by: spacemtn5
5 Replies

6. Shell Programming and Scripting

comparing column of two different files and print the column from in order of 2nd file

Hi friends, My file is like: Second file is : I need to print the rows present in file one, but in order present in second file....I used while read gh;do awk ' $1=="' $gh'" {print >> FILENAME"output"} ' cat listoffirstfile done < secondfile but the output I am... (14 Replies)
Discussion started by: CAch
14 Replies

7. Shell Programming and Scripting

awk Print New Column For Every Two Lines and Match On Multiple Column Values to print another column

Hi, My input files is like this axis1 0 1 10 axis2 0 1 5 axis1 1 2 -4 axis2 2 3 -3 axis1 3 4 5 axis2 3 4 -1 axis1 4 5 -6 axis2 4 5 1 Now, these are my following tasks 1. Print a first column for every two rows that has the same value followed by a string. 2. Match on the... (3 Replies)
Discussion started by: jacobs.smith
3 Replies

8. Linux

Print the 1st column and the value in 2nd or 3rd column if that is different from the values in 1st

I have file that looks like this, DIP-17571N|refseq:NP_651151 DIP-17460N|refseq:NP_511165|uniprotkb:P45890 DIP-17571N|refseq:NP_651151 DIP-19241N|refseq:NP_524261 DIP-19241N|refseq:NP_524261 DIP-17151N|refseq:NP_524316|uniprotkb:O16797 DIP-19588N|refseq:NP_731165 ... (2 Replies)
Discussion started by: Syeda Sumayya
2 Replies

9. UNIX for Beginners Questions & Answers

Compare 1st column from 2 file and if match print line from 1st file and append column 7 from 2nd

hi I have 2 file with more than 10 columns for both 1st file apple,0,0,0...... orange,1,2,3..... mango,2,4,5..... 2nd file apple,2,3,4,5,6,7... orange,2,3,4,5,6,8... watermerlon,2,3,4,5,6,abc... mango,5,6,7,4,6,def.... (1 Reply)
Discussion started by: tententen
1 Replies

10. UNIX for Beginners Questions & Answers

Need to print nth till last column of ls output using sed

I wish to print first, third and sixth till the last column from the output of ls command ls -ltr /app/deploy.yml -rw-rw-r-- 1 user1 dba 27342 Aug 28 10:17 /app/deploy.yml Desired Output: Below command gives me the desired output. ls -ltr /app/deploy.yml | awk '{$2=$4=$5=""; print... (6 Replies)
Discussion started by: mohtashims
6 Replies

LEARN ABOUT CENTOS

perlko

PERLKO(1)						 Perl Programmers Reference Guide						 PERLKO(1)

NAME

       perlko - PerlXX XXXXXXXX XXXXXXX

DESCRIPTION

       PerlXXX XXXXXXXX XXXXX XXXXX XXXXXXXXXXXXXX !

       PerlXXX 5.8.0XXXXXXXX XXXXXXXXXXX/ISO 10646XXX XXXXXX XXXXXXXXXX XXXXXXXX XXXXXXXX.  XXXXXXXXXXX XXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXX
       XXXXX XXXXXXXXXX XXXXXXXXXXX XXXXXXXX XXXXX XXXXXXXX XXXXXXX XXXXX XXXXXXX XXXXXX XXXXXXXX XXXXXXXXXX XXXXXXXXXXXXX.  XXXXXXXXXXXXXX XXX
       XXXXXXXXXXX XXXXXXX XXXX XXXXXXX XXXXXX XXXXX XXXX - XXXXXXXX XXXXX XXXXXXXX, XXXX XXXXXXXX, XXXXXX XXXXXXXX, XXXXXXXX XXXXXX XXXXXXXXXXXX
       XXXXXXX XXXXX XXXXXXXXX, XXXXXX XXXX, XXXXXXX XXXX, XXXXXXXXXX XXXXXX, XXXXXXXXXX XXXXX, XXXXXXXXX XXXXX, XXXX XXXXXXXXXXX XXXXX XXXX XXX-
       XX XXXXXXXXXXX XXXXX XXXXXX XXXXX XXXXX XXXXXXX XXXXXX XXXXXXX  XX XXXXX XX XXXX XXXXX XXXXX XXXXXXX XXXXXXXX XXXX XXXXXX XXXXXXXXXX XXX
       XXX XXXXXX XXXX XXXXXXXX XXXXXXXXX  XXX XXXX XXXXXXXXXX XXXXXXXXXX XXXXX XXXXXX XXXXX XXXXX XXXXXXX  XXXXXXXXX XXXXXXXXXXX.

       PerlXXX XXXXXXXXXXXXX XXXXXXXXXXXXX XXXX XXXXXXXXX XXXXXX XXXXXXXXXXXX. XXXX XXXXXXXXXXX XXXXXXX Perl XXXXXXXXX XXXXXXXXX  UTF-8 XXXXXXXXX
       XXX XXX XXXXX, XXXX XXXXXXXX XXXXXXX(XXXXX XXXXX, XXXXXXXX, index, substr)XX XXXXXXX XXXXX XXXXXX XXXXXXXXXXX XXXXX XXXXXXX XXXXXXXXXXXXXX.
       (XXX XXXXXXXX XXXXX perlunicode XXXXXXXX XXXXXXXXXXXXXXXX.) XXXXXXXXXXXXX XXXXX XXXXXXXXX XXXXXX XXXXX XXXXXXX XXXXXXXX, XXXXXXXX XXXXX
       XXXXXXX XXXXXX XXXX/XX XXXXXXX XXXXXXXXXXXX XXXXXXXXXX XXXXX XXXXX XXXXXXXXXXXX XXX XXXXXXXXX XXXXXX XXXXXXX XXXXX XXXXX XXXXX 'Encode'XX
       XXXXXXXXXXXXX. XXXXXXXX 'Encode'XX  XXXXX XXXXXXXX XXXXXXXX XXXXXXX XXXXXXXX XXXXX XXX XXX XXXXXXXXXXX.

       'Encode'XXX XXXXXXX XXXXX XXXXXXXX XXXXXXXXXX XXXXXXXXXXXXX.

       euc-kr
	     US-ASCIIXXX KS X 1001XXX XXXXX XXXXX XXXXXXXXXXXX XXXXXXXX (XXXXXX XXXXXXXXXXXXXXX
	     XXXX.) KS X 2901XX RFC 1557 XXXX.

       cp949
		   MS-Windows 9x/MEXXXXXX XXXXXXX XXXXXX XXXXXXXX.  euc-krXXX 8,822XXXXXX
		   XXXXX XXXXXXXXX XXXXXX XXXXX.  aliasXXX uhc, windows-949, x-windows-949,
		   ks_c_5601-1987. XX XXXXXX XXXXXXXX XXXXXXXXXXX XXXXXX XXXXXXXXXXXX, Microsoft
		   XXXXXXXXXXXX CP949XXX XXXXXXX XXXXXXX XXXXXX.

       johab
		   KS X 1001:1998 XXXX 3XXXXXX XXXXXXXX XXXXXX.  XXXX XXXXXXXXXXXX cp949XXX
		   XXXXXXXXXX US-ASCIIXXX  KS X 1001XXX 8,822XXXXXX XXXXX XXXXXXXXX XXXXXX XXXXX.
		   XXXXXXXX XXXXXXX XXXXXX XXXXX.

       iso-2022-kr
		   RFC 1557XXXXXX XXXXXXXX XXXXXXXX XXXXXXX XXXXX XXXXXXXX XXXXXXXXXXXX US-ASCIIXXX
		   KS X 1001XXX XXXXXXXXXXXX XXXXXX XXXXXXXXX euc-krXX XXXXXX XXXXXXXX XXXXXXX XXXXX.
		   1997-8XXX XXXXXX XXXXXXXXXX XXX XXXXX XXXXX XXXXXXXX XXXXXXX XXXXXX.

       ksc5601-raw
		   KS X 1001(KS C 5601)XXX GL(XX, MSBXX 0XXXXX XXX XXXX) XXX XXXXXXXXX XXXXXX
		   XXXXXXXX. US-ASCIIXXX XXXXXXXX XXXXX XXXXXXXXXX XXXXXXX XXXXX X11 XXXXXXXX XXX
		   XXXXXXXX (ksc5601.1987-0. '0'XXX GLXXX XXXXXXX.)XXXXX XXXXXXX XXXXX XXXXXXXXXXXXX
		   XXXX XXXXXX. KS C 5601XXX 1997XXX KS X 1001XX XXXXXXXX XXXXXXXXX.  1998XXXXXXXXX  XXX
		   XXXXX (XXXXXXXX XXXXXXX XXXXX XXXXXX XXXXX)XX XXXXXXXXXXX.

	XX XXXX XXXXX XXXXXXXX XXXXXXXXX XXXXXXXXXX.

       XXXXX XXXXX, euc-kr XXXXXXXXXXXX XXX XXXXXXXX UTF-8XX XXXXXXXXXXXX XXXXXX XXXXX XXXXX XXXXXXXX.

	   perl -Mencoding=euc-kr,STDOUT,utf8 -pe1  < file.euckr > file.utf8

       XXXXXXXXXXX XXXXXXX XXXXX XXX XXX XXXXXXXXXXX.

	   perl -Mencoding=utf8,STDOUT,euc-kr -pe1  < file.utf8  > file.euckr

	 XXXXX XXXXXXXX XXXXX XXXXXXXXX XXX XXX XXXXXXXX Encode XXXXXXX XXXXX
       XXXXXXXXXXX PerlXXXX XXXXX piconvXX PerlXXX XXXXX XXXXXXXXXXX.
       XX XXXXXXXXXXX XXX XXX XXXXXXXXX piconvXXX UnixXXX XXXXXX iconvX
       XXXXXX XXX XXXXXXXXXXX. XX XXXXXXXXXX XXXXXXXXX XXXXXXXXXX.

	  piconv -f euc-kr -t utf8 < file.euckr > file.utf8
	  piconv -f utf8 -t euc-kr < file.utf8 > file.euckr

	 XXX, 'PerlIO::encoding' XXXXXXX XXXXX XXXXXXXX XXXXXXXXXX XXXXXXX XXXXX XXXXX
       (XXXXXXX XXXXXXX XXXXXXXXX) XXXXXX XXXXX XXX XXX XXXXXXXXXXX.

	 #!/path/to/perl

	 use encoding 'euc-kr', STDIN => 'euc-kr',
				STDOUT-> 'euc-kr', STDERR=>'euc-kr';

	 print length("XXXXX");        # 2  (XXX XXXXXXXXXX XXXXX XXXXX XXXXXX XXXXX)
	 print length('XXXXX');        # 4  (XXXXXX XXXXXXXXXX XXXXXXX XXXXX XXXXXX XXXXX)
	 print index("XXXXX, XXXXXXXX", "XXX");   # -1 ('XXX'XXX XXXXXX)
	 print index('XXXXX, XXXXXXXX', 'XXX');   # 7 (8XXXXXX 9XXXX XXXXXXXXX 'XXX'XXX
						   XXXXXXXXX XXXXXXXX.)

   XXX XXXXXXXX XXXXX XXXXXX...
	 PerlXXX XXXXXXXXXX  XXXXXXXX XXXXXXXX XXXXXX XXXXX XXXXX XXXX, XXX XXXXXX XXXX
       Perl XXXXX XX XXXXXXXXX XXXXXXXXXXX XXXXX, EncodeXXX XXXXXXX XXXXX XXXXX XXXXX
       XXXX XXX XXXXXXXXXXX.  XXXXX XXX XXXXXXX XXXXXX XXXX XXXXXXXX XXXXX XXXXXXXXXXX.

   Perl XXXXX XXXXX
       XXXXXXXXX XXXXXXXX  XXXX XXXXXXXX XXXXXXX XXXXX XXXXXXX XXXXXXXXXXX. XXX XXXXXXX XXXX XXXXXXXXX XXXXX XXXXXXXX XXXXX XXXXXXXXXXXX XXXX XXXX
       XXXXXXXXXXX.

       <http://www.perl.com/>
	      O'ReillyXXX Perl XXX XXXXXXXX

       <http://www.cpan.org/>
		   Comprehensive Perl Archive Network

       <http://lists.perl.org/>
	     Perl XXXXXXX XXXXXX. XXXXX XXXXXX XXXXXX
	     perl-unicodeXXXXXX 'Encode'XXX XXXXXX XXXXXXXX.

   PerlXXX XXX XXXX XXXXXXXXXXXXX XXXXXXXXX XX XXX XXXXXX XXXXXXXX XXXXX XXXXXX
       <http://www.perl.or.kr/>
	     Perl XXXXX XXXXXXX XXXX

       <news:han.comp.lang.perl/>
	     XXXXXXXX Perl XXXXX XXX

       <http://www.hanb.co.kr/search/searchResult.html?keyword=perl>
	     O'ReillyXXXXXX XXXXXX XXXXXXXX Perl XXXXXX XXXX

       <http://www.perlschool.net/>
	     Perl XXXX XXXX XX XXXXXX, XXXX XXXXXX, XXXXX XXXXX XXXXXXX XXXXX

       <http://www.perl.co.kr>
	     PerlXXX XXXXXXX CGI, DB, XXXXX XXXXX XXXXXX  XXXXX XX XXXXX XXXX

   XXXXXXXXXXX XX XXXXXXXX XXXXXXXX XXXXX XXXXX
       <http://www.unicode.org/>
	     XXXXXXXXXXX XXXXXXXXXX.

       <http://std.dkuug.dk/JTC1/SC2/WG2>
	   XXXXXXXXXXX UnicodeXXX XXXXX ISO XXXXXXXX  ISO/IEC 10646 UCS(Universal Character Set)XXX XXXXXXXX  ISO/IEC JTC1/SC2/WG2XXX XXX
	   XXXXXXXX.

       <http://www.cl.cam.ac.uk/~mgk25/unicode.html>
	     XXXXXXXXX/XXXXXXXXXXXX XXXXXXXXXXXXXX UTF-8 XXXXXXX XXXXXX XXXXXX(FAQ)

       http://wiki.kldp.org/Translations/html/UTF8-Unicode-KLDP/UTF8-Unicode-KLDP.html <http://wiki.kldp.org/Translations/html/UTF8-Unicode-
       KLDP/UTF8-Unicode-KLDP.html>
	     XXXXXXXXX/XXXXXXXXXXXX XXXXXXXXXXXXXX UTF-8 XXXXXXX XXXXXX XXXXXX(FAQ)XXX	XXXXXXXX XXXXX

SEE ALSO

       Encode, Encode::KR, encoding, perluniintro, perlunicode

AUTHORS

       Jarkko Hietaniemi <jhi@iki.fi> XXXXXXXXX <jshin@mailaps.org>

perl v5.16.3							    2013-03-04								 PERLKO(1)
All times are GMT -4. The time now is 04:45 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy