Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: replace "," with "." only in specific columns of a file?
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
Old 08-08-2011
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!
 

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 (4 Replies)
Discussion started by: Lokesha
4 Replies

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 (4 Replies)
Discussion started by: harshakusam
4 Replies

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... (7 Replies)
Discussion started by: shis100
7 Replies

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 (8 Replies)
Discussion started by: timmywong
8 Replies

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. :( (16 Replies)
Discussion started by: wolfgang
16 Replies

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... (6 Replies)
Discussion started by: poliver
6 Replies

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... (2 Replies)
Discussion started by: asjaiswal
2 Replies

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... (1 Reply)
Discussion started by: jcdole
1 Replies

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) ... (3 Replies)
Discussion started by: penchev
3 Replies

LEARN ABOUT SUNOS

iconv_1250

iconv_1250(5)						Standards, Environments, and Macros					     iconv_1250(5)

NAME

       iconv_1250 - code set conversion tables for MS 1250 (Windows Latin 2)

DESCRIPTION

       The following code set conversions are supported:

       +----------------------------------------------------------------------+
       |		   Code Set Conversions Supported		      |
       +-------------+----------+--------------+----------+-------------------+
       |    Code     |	Symbol	| Target Code  | Symbol   |  Target Output    |
       +-------------+----------+--------------+----------+-------------------+
       |MS 1250      | win2	| ISO 8859-2   |iso2	  |ISO Latin 2	      |
       +-------------+----------+--------------+----------+-------------------+
       |MS 1250      | win2	| MS 852       |dos2	  |MS-DOS Latin 2     |
       +-------------+----------+--------------+----------+-------------------+
       |MS 1250      | win2	| Mazovia      |maz	  |Mazovia	      |
       +-------------+----------+--------------+----------+-------------------+
       |MS 1250      | win2	| DHN	       |dhn	  |Dom Handlowy Nauki |
       +-------------+----------+--------------+----------+-------------------+

CONVERSIONS

       The conversions are performed according to the following tables. All values in the tables are given in octal.

   MS 1250 to ISO 8859-2
       For the conversion of MS 1250 to ISO 8859-2, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |   MS 1250     |  ISO 8859-2	|   MS 1250	 |  ISO 8859-2	 |
       |24-211	       | 40		|235		 |273		 |
       |212	       | 251		|236		 |276		 |
       |213	       | 40		|237		 |274		 |
       |214	       | 246		|241		 |267		 |
       |215	       | 253		|245		 |241		 |
       |216	       | 256		|246-267	 |40		 |
       |217	       | 254		|271		 |261		 |
       |221-231        | 40		|273		 |40		 |
       |232	       | 271		|274		 |245		 |
       |233	       | 40		|276		 |265		 |
       |234	       | 266		|247		 |365		 |
       +---------------+----------------+----------------+---------------+

   MS 1250 to MS 852
       For the conversion of MS 1250 to MS 852, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |   MS 1250     |    MS 852	|   MS 1250	 |    MS 852	 |
       |200-211        | 40		|311		 |220		 |
       |212	       | 346		|312		 |250		 |
       |213	       | 40		|313		 |323		 |
       |214	       | 227		|314		 |267		 |
       |215	       | 233		|315		 |326		 |
       |216	       | 246		|316		 |327		 |
       |217	       | 215		|317		 |322		 |
       |220-231        | 40		|320		 |321		 |
       |232	       | 347		|321		 |343		 |
       |233	       | 40		|322		 |325		 |
       |234	       | 230		|323		 |340		 |
       |235	       | 234		|324		 |342		 |
       |236	       | 247		|325		 |212		 |
       |237	       | 253		|326		 |231		 |
       |240	       | 377		|327		 |236		 |
       |241	       | 363		|330		 |374		 |
       |242	       | 364		|331		 |336		 |
       |243	       | 235		|332		 |351		 |
       |244	       | 317		|333		 |353		 |
       |245	       | 244		|334		 |232		 |
       |246	       | 40		|335		 |355		 |
       |247	       | 365		|336		 |335		 |
       |250	       | 371		|337		 |341		 |
       |251	       | 40		|340		 |352		 |
       |252	       | 270		|341		 |240		 |
       |253	       | 256		|342		 |203		 |
       |254	       | 252		|343		 |307		 |
       |255	       | 360		|344		 |204		 |
       |256	       | 40		|345		 |222		 |
       |257	       | 275		|346		 |206		 |
       |260	       | 370		|347		 |207		 |
       |261	       | 40		|350		 |237		 |
       |262	       | 362		|351		 |202		 |
       |263	       | 210		|352		 |251		 |
       |264	       | 357		|353		 |211		 |
       |265-267        | 40		|354		 |330		 |
       |270	       | 367		|355		 |241		 |
       |271	       | 245		|356		 |214		 |
       |272	       | 255		|357		 |324		 |
       |273	       | 257		|360		 |320		 |
       |274	       | 225		|361		 |344		 |
       |275	       | 361		|362		 |345		 |
       |276	       | 226		|363		 |242		 |
       |277	       | 276		|364		 |223		 |
       |300	       | 350		|365		 |213		 |
       |301	       | 265		|366		 |224		 |
       |302	       | 266		|367		 |366		 |
       |303	       | 306		|370		 |375		 |
       |304	       | 216		|371		 |205		 |
       |305	       | 221		|372		 |243		 |
       |306	       | 217		|374		 |201		 |
       |307	       | 200		|375		 |354		 |
       |310	       | 254		|376		 |356		 |
       +---------------+----------------+----------------+---------------+

   MS 1250 to Mazovia
       For the conversion of MS 1250 to Mazovia, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |   MS 1250     |    Mazovia	|   MS 1250	 |   Mazovia	 |
       |200-213        | 40		|310-311	 |40		 |
       |214	       | 230		|312		 |220		 |
       |215-216        | 40		|313-320	 |40		 |
       |217	       | 240		|321		 |245		 |
       |220-233        | 40		|322		 |40		 |
       |234	       | 236		|323		 |243		 |
       |235-236        | 40		|324-325	 |40		 |
       |237	       | 246		|326		 |231		 |
       |240	       | 377		|327-333	 |40		 |
       |241-242        | 40		|334		 |232		 |
       |243	       | 234		|335-336	 |40		 |
       |244	       | 40		|337		 |341		 |
       |245	       | 217		|340-341	 |40		 |
       |246-252        | 40		|342		 |203		 |
       |253	       | 256		|343		 |40		 |
       |254	       | 252		|344		 |204		 |
       |255-256        | 40		|345		 |40		 |
       |257	       | 241		|346		 |215		 |
       |260	       | 370		|347		 |207		 |
       |261	       | 361		|350		 |40		 |
       |262	       | 40		|351		 |202		 |
       |263	       | 222		|352		 |221		 |
       |264	       | 40		|353		 |211		 |
       |265	       | 346		|354-355	 |40		 |
       |266	       | 40		|356		 |214		 |
       |267	       | 372		|357-360	 |40		 |
       |270	       | 40		|361		 |244		 |
       |271	       | 206		|362		 |40		 |
       |272	       | 40		|363		 |242		 |
       |273	       | 257		|364		 |223		 |
       |274-276        | 40		|365		 |40		 |
       |277	       | 247		|366		 |224		 |
       |300-303        | 40		|367		 |366		 |
       |304	       | 216		|370-373	 |40		 |
       |305	       | 40		|374		 |201		 |
       |306	       | 225		|375-376	 |40		 |
       |307	       | 200		|		 |		 |
       +---------------+----------------+----------------+---------------+

   MS 1250 to DHN
       For the conversion of MS 1250 to DHN, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |   MS 1250     |      DHN	|   MS 1250	 |     DHN	 |
       |200-213        | 40		|306		 |201		 |
       |214	       | 206		|307-311	 |40		 |
       |215-216        | 40		|312		 |202		 |
       |217	       | 207		|313-320	 |40		 |
       |220-233        | 40		|321		 |204		 |
       |234	       | 217		|322		 |40		 |
       |235-236        | 40		|323		 |205		 |
       |237	       | 220		|324-325	 |40		 |
       |240	       | 377		|326		 |231		 |
       |241-242        | 40		|327-333	 |40		 |
       |243	       | 203		|334		 |232		 |
       |244	       | 40		|335-336	 |40		 |
       |245	       | 200		|337		 |341		 |
       |246-252        | 40		|340		 |40		 |
       |253	       | 256		|341		 |240		 |
       |254	       | 252		|342-345	 |40		 |
       |255-256        | 40		|346		 |212		 |
       |257	       | 210		|347-351	 |40		 |
       |260	       | 370		|352		 |213		 |
       |261	       | 361		|353-354	 |40		 |
       |262	       | 40		|355		 |241		 |
       |263	       | 214		|356-360	 |40		 |
       |264	       | 40		|361		 |215		 |
       |265	       | 346		|362		 |40		 |
       |266	       | 40		|363		 |216		 |
       |267	       | 372		|364		 |223		 |
       |270	       | 40		|365		 |40		 |
       |271	       | 211		|366		 |224		 |
       |272	       | 40		|367		 |366		 |
       |273	       | 257		|370-371	 |40		 |
       |274-276        | 40		|372		 |243		 |
       |277	       | 221		|373-376	 |40		 |
       |300-305        | 40		|		 |		 |
       +---------------+----------------+----------------+---------------+

FILES

       /usr/lib/iconv/*.so	       conversion modules

       /usr/lib/iconv/*.t	       conversion tables

       /usr/lib/iconv/iconv_data       list of conversions supported by conversion tables

SEE ALSO

       iconv(1), iconv(3C), iconv(5)

SunOS 5.10							    18 Apr 1997 						     iconv_1250(5)
All times are GMT -4. The time now is 07:31 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy