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 PHP

neaten

NEATEN(1)						      General Commands Manual							 NEATEN(1)

NAME

       neaten - neaten up output columns

SYNOPSIS

       neaten [ format ]

DESCRIPTION

       Neaten  reads  from  its standard input and neatens up columns separated by white space using the specified format.  The format is a string
       consisting of a positive integer followed by an alignment character and another integer.  The alignment	character  is  usually	a  decimal
       point ('.'), but it can be any non-digit.

       The  alignment  character  is used as the central point of each column.	The total column field width will be the number to the left of the
       alignment character plus one for the alignment character itself plus the number to the right of the alignment character.

       If a field does not contain the alignment character, it will be printed to the left of where the alignment character would  have  appeared.
       If  a  field  is  too long to print within the specified format, the entire field will be printed and that row will not be aligned with the
       rest.

       The default format is "8.8".

EXAMPLE

       To examine a file with columns of numbers:

	 neaten 10.8 < input | more

BUGS

       Columns wider than the total width of the format specification will be printed without any separating white space.

       The program does not do anything special with tabs on the input.

AUTHOR

       Greg Ward

SEE ALSO

       cnt(1), rcalc(1), rlam(1), total(1)

RADIANCE
							     11/15/93								 NEATEN(1)