replace "," with "." only in specific columns of a file? Post: 302545434

Sponsored Content

Top Forums UNIX for Dummies Questions & Answers replace "," with "." only in specific columns of a file? Post 302545434 by Unilearn on Monday 8th of August 2011 10:24:58 AM

08-08-2011

Registered User

Here you go,

File.txt

MarkerName Allele1 Allele2 Freq1 FreqSE Weight Zscore P-value Direct
1kg_2_25451489 c g 0.3220 0.0329 233.00 3.732 0.0001903+++-
imm_12_9663851 a g 0.1388 0.0111 209.00 3.724 0.0001958+++?
imm_12_9679839 a g 0.8612 0.0111 209.00 -3.724 0.0001958---?
imm_12_9698340 t c 0.8804 0.0107 233.00 -4.215 2.5e-005----
imm_12_9698384 a g 0.8804 0.0107 233.00 -4.215 2.5e-005----
imm_12_9698598 a g 0.8804 0.0107 233.00 -4.215 2.5e-005----
imm_12_9699693 t c 0.8804 0.0107 233.00 -4.215 2.5e-005----
imm_12_9699837 t c 0.8804 0.0107 233.00 -4.215 2.5e-005----

So when I sort them according to 8th coloumn, I would expect it to have

MarkerName Allele1 Allele2 Freq1 FreqSE Weight Zscore P-value Direct
imm_12_9698340 t c 0.8804 0.0107 233.00 -4.215 2.5e-005----
imm_12_9698384 a g 0.8804 0.0107 233.00 -4.215 2.5e-005----
imm_12_9698598 a g 0.8804 0.0107 233.00 -4.215 2.5e-005----
imm_12_9699693 t c 0.8804 0.0107 233.00 -4.215 2.5e-005----
imm_12_9699837 t c 0.8804 0.0107 233.00 -4.215 2.5e-005----
1kg_2_25451489 c g 0.3220 0.0329 233.00 3.732 0.0001903+++-
imm_12_9663851 a g 0.1388 0.0111 209.00 3.724 0.0001958+++?
imm_12_9679839 a g 0.8612 0.0111 209.00 -3.724 0.0001958---?

Thanks!

Unilearn

View Public Profile for Unilearn

Find all posts by Unilearn

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Explain the line "mn_code=`env|grep "..mn"|awk -F"=" '{print $2}'`"

Hi Friends, Can any of you explain me about the below line of code? mn_code=`env|grep "..mn"|awk -F"=" '{print $2}'` Im not able to understand, what exactly it is doing :confused: Any help would be useful for me. Lokesha

2. Shell Programming and Scripting

cat $como_file | awk /^~/'{print $1","$2","$3","$4}' | sed -e 's/~//g'

hi All, cat file_name | awk /^~/'{print $1","$2","$3","$4}' | sed -e 's/~//g' Can this be done by using sed or awk alone

3. Shell Programming and Scripting

awk command to replace ";" with "|" and ""|" at diferent places in line of file

Hi, I have line in input file as below: 3G_CENTRAL;INDONESIA_(M)_TELKOMSEL;SPECIAL_WORLD_GRP_7_FA_2_TELKOMSEL My expected output for line in the file must be : "1-Radon1-cMOC_deg"|"LDIndex"|"3G_CENTRAL|INDONESIA_(M)_TELKOMSEL"|LAST|"SPECIAL_WORLD_GRP_7_FA_2_TELKOMSEL" Can someone...

4. Shell Programming and Scripting

how to use "cut" or "awk" or "sed" to remove a string

logs: "/home/abc/public_html/index.php" "/home/abc/public_html/index.php" "/home/xyz/public_html/index.php" "/home/xyz/public_html/index.php" "/home/xyz/public_html/index.php" how to use "cut" or "awk" or "sed" to get the following result: abc abc xyz xyz xyz

5. Solaris

The slices "usr", "opt", "tmp" disappeared!!! Help please.

The system don't boot. on the screen appears following: press enter to maintenance (or type CTRL-D to continue)...I checked with format command. ... the slices "0-root","1-swap","2-backup" exist. ...the slises "3-var","6-usr" -unassigned. :(

6. Shell Programming and Scripting

Substituting comma "," for dot "." in a specific column when comma"," is a delimiter

Hi, I'm dealing with an issue and losing a lot of hours figuring out how i would solve this. I have an input file which looks like this: ('BLABLA +200-GRS','Servi�o ','Tarifa��oServi�o','wap.bla.us.0000000121',2985,0,55,' de convers�o em escada','Dia','Domingos') ('BLABLA +200-GRR','Servi�o...

7. UNIX for Dummies Questions & Answers

Using "mailx" command to read "to" and "cc" email addreses from input file

How to use "mailx" command to do e-mail reading the input file containing email address, where column 1 has name and column 2 containing �To� e-mail address and column 3 contains �cc� e-mail address to include with same email. Sample input file, email.txt Below is an sample code where...

8. Shell Programming and Scripting

Bash script - Print an ascii file using specific font "Latin Modern Mono 12" "regular" "9"

Hello. System : opensuse leap 42.3 I have a bash script that build a text file. I would like the last command doing : print_cmd -o page-left=43 -o page-right=22 -o page-top=28 -o page-bottom=43 -o font=LatinModernMono12:regular:9 some_file.txt where : print_cmd ::= some printing...

9. AIX

Apache 2.4 directory cannot display "Last modified" "Size" "Description"

Hi 2 all, i have had AIX 7.2 :/# /usr/IBMAHS/bin/apachectl -v Server version: Apache/2.4.12 (Unix) Server built: May 25 2015 04:58:27 :/#:/# /usr/IBMAHS/bin/apachectl -M Loaded Modules: core_module (static) so_module (static) http_module (static) mpm_worker_module (static) ...

LEARN ABOUT OPENDARWIN

column

COLUMN(1)						    BSD General Commands Manual 						 COLUMN(1)

NAME

     column -- columnate lists

SYNOPSIS

     column [-tx] [-c columns] [-s sep] [file ...]

DESCRIPTION

     The column utility formats its input into multiple columns.  Rows are filled before columns.  Input is taken from file operands, or, by
     default, from the standard input.	Empty lines are ignored.

     The options are as follows:

     -c      Output is formatted for a display columns wide.

     -s      Specify a set of characters to be used to delimit columns for the -t option.

     -t      Determine the number of columns the input contains and create a table.  Columns are delimited with whitespace, by default, or with
	     the characters supplied using the -s option.  Useful for pretty-printing displays.

     -x      Fill columns before filling rows.

DIAGNOSTICS

     The column utility exits 0 on success, and >0 if an error occurs.

ENVIRONMENT

     COLUMNS  The environment variable COLUMNS is used to determine the size of the screen if no other information is available.

EXAMPLES

	   (printf "PERM LINKS OWNER GROUP SIZE MONTH DAY " ; 
	   printf "HH:MM/YEAR NAME
" ; 
	   ls -l | sed 1d) | column -t

SEE ALSO

     colrm(1), ls(1), paste(1), sort(1)

HISTORY

     The column command appeared in 4.3BSD-Reno.

BSD
								   June 6, 1993 							       BSD