Trim String in 3rd Column in Tab Delimited File...SED/PERL/AWK? Post: 302241169

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Delete parts of a string of character in one given column of a tab delimited file

I would like to remove characters from column 7 so that from an input file looking like this: >HWI-EAS422_12:4:1:69:89 GGTTTAAATATTGCACAAAAGGTATAGAGCGT U0 1 0 0 ref_chr8.fa 6527777 F DD I get something like that in an output file: ...

2. 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;...

3. UNIX for Dummies Questions & Answers

Using awk to log transform a column in a tab-delimited text file?

How do I use awk to log transform the fifth column of a tab-delimited text file? Thanks!

4. Shell Programming and Scripting

Extract second column tab delimited file

I have a file which looks like this: 73450 articles and news developmental psychology 2006-03-30 16:22:40 1 http://www.usnews.com 73450 articles and news developmental psychology 2006-03-30 16:22:40 2 http://www.apa.org 73450 articles and news developmental psychology 2006-03-30...

5. UNIX for Dummies Questions & Answers

add (append) a column in a tab delimited file

I have a file having the following entries: test1 test2 test3 11 22 33 22 44 66 99 99 44 --- I want to add a column so that the above file becomes: test1 test2 test3 notest 11 22 33 * 22 44 66 * 99 99 44 * --- Thanks

6. Shell Programming and Scripting

Delete string between 3rd tab and first pattern with SED

Hello, I have this sentence :Pattern1 Pattern2 Pattern3 Pattern4-which-contains-HELLO-string-and-other-stuff-and-second-HELLO-and-third-HELLO I want to delete everything between the 3rd tab (\t) and the FIRST pattern "HELLO" of the line. Result expected is : Pattern1 ...

7. Shell Programming and Scripting

Delete an entire column from a tab delimited file

Hi, Can anyone please tell me about how we can delete an entire column from a tab delimited file? Mu input_file.txt looks like this: And I want the output as: I used the below code nawk -v d="1" 'BEGIN{FS=OFS="\t"}{$d=""}{print}' input_file.txtBut in the output, the first column is...

8. UNIX for Dummies Questions & Answers

awk - Extract 4 lines in Column to Rows Tab Delimited between tags

I have tried the following to no avail. xargs -n8 < test.txt awk '{if(NR%6!=0){p=""}else{p="\n"};printf $0" "p}' Mod_Alm_log.txt > test.txt I have tried different variations of the above, the problem is mixes lines together. And it includes the tags "%a and %A" I need them to be all tab...

9. Shell Programming and Scripting

Solution for replacement of 4th column with 3rd column in a file using awk/sed preserving delimters

input "A","B","C,D","E","F" "S","T","U,V","W","X" "AA","BB","CC,DD","EEEE","FFF" required output: "A","B","C,D","C,D","F" "S", T","U,V","U,V","X" "AA","BB","CC,DD","CC,DD","FFF" tried using awk but double quotes not preserving for every field. any help to solve this is much...

10. UNIX for Beginners Questions & Answers

Replace a column in tab delimited file with column in other tab delimited file,based on match

Hello Everyone.. I want to replace the retail col from FileI with cstp1 col from FileP if the strpno matches in both files FileP.txt ...

LEARN ABOUT HPUX

quot_hfs

quot_hfs(1M)															      quot_hfs(1M)

NAME

       quot_hfs: quot - summarize ownership on an HFS file system

SYNOPSIS

       filesystem ...

DESCRIPTION

       The  command  displays  the  number  of	1024-byte blocks in the named HFS filesystem that are currently owned by each user.  filesystem is
       either the name of the directory on which the file system is mounted or the name of the device containing the file system.

   Options
       recognizes the following options:

	      Generate a report for all mounted HFS file systems.

	      Report size rather than user statistics.
			Generates histogram statistics in 3-column format:

			     Column 1:	 File size in blocks.  Sizes are listed in ascending order up to 499 blocks per file.  Files occupying 499
					 or  more blocks are counted together on a single line as 499-block files (but column 3 is based on actual
					 number of blocks occupied).

			     Column 2:	 Number of files of size indicated in column 1.

			     Column 3:	 Cumulative total blocks occupied by files counted in current plus all preceding lines.

			Use of this option overrides the and options.

	      Display number of files and space occupied by each user.

	      Specify the file system type

	      Calculate the number of blocks in the file based on file size
			rather than actual blocks allocated.  This option does not account for sparse files (files with holes in them).

	      Accept data from the
			command (see ncheck(1M)) as input.  Run the pipeline:

			to produce a list of all files and their owners.

	      Report on users.
			This is the default action.

	      Display three columns containing the number of blocks
			not accessed in the last 30, 60, and 90 days.

	      Echo the completed command line, but perform no other
			action.  The command line is generated by incorporating the user-specified options and other information derived from This
			option	allows	the  user  to  verify the command line.  If the options specified are valid, the completed command line is
			echoed.  If the options specified are not valid, an error message is printed.

AUTHOR

       a disk quota command, was developed by the University of California, Berkeley, Sun Microsystems, Inc., and HP.

FILES

       Static information about the file systems
       Mounted file system table
       Password file (contains user names)

SEE ALSO

       du(1), find(1), ls(1), fstyp(1M), mount(1M), ncheck(1M), quot(1M), repquota(1M), quota(5).

																      quot_hfs(1M)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Delete parts of a string of character in one given column of a tab delimited file

Discussion started by: matlavmac

2. Shell Programming and Scripting

Using sed on 1st column of tab delimited file

Discussion started by: Hkins552

3. UNIX for Dummies Questions & Answers

Using awk to log transform a column in a tab-delimited text file?

Discussion started by: evelibertine

4. Shell Programming and Scripting

Extract second column tab delimited file

Discussion started by: shoaibjameel123