Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Reading columns, making a new file using another as template
Top Forums Shell Programming and Scripting Reading columns, making a new file using another as template Post 302606175 by valente on Friday 9th of March 2012 06:48:36 PM
Old 03-09-2012
Reading columns, making a new file using another as template
Hi fellas,
I have two files such as:
File 1
interacao,AspAsp,AspCys,CysAsp,CysCys,classe

File 2
interacao,AspAsp,CysAsp,AspCys,CysCys,classe
beta_alfa, DA, CA, DD, CD,ppi

Thus, I want to make a File 3 using the File 1 as model:
e.g.
File 3
interacao,AspAsp,AspCys,CysAsp,CysCys,classe
beta_alfa, DA, DD, CA, CD,ppi

NOTE: I inseted the spaces in the File 2 and File 3 examples just to be easier to see.

In the example I just gave 6 columns, but my real file has 402 columns.
So, to do an awk -F "," '{print $1","$2","$4","$3","$5","$6}'
will not work because I dont know the position of the itens of the File 1 in the File 2 (for example the AspCys could be the sixth, the second, or the last columns).

I hope that you can help me and I would like an small explanation of the code, because I'm newbie and do not know a lot the commands.

Thanks in advance.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

gawk - reading two files & re arrange the columns

Hi, I am trying to read 2 files and writing to the 3rd file if I find the same elements in 2 files. my first file is 1 0 kb12124819 766409 1.586e-01 1 0 kb17160939 773886 8.674e-01 1 0 kb4475691 836671 8.142e-01 1 0 ... (2 Replies)
Discussion started by: ezhil01
2 Replies

2. Shell Programming and Scripting

ksh questions - Reading columns and lines on unix

1-) For the command below, I want to read second column: 32751. How will I get it ? $ ps -ef|grep deneme U00 32751 22745 0 16:30 pts/1 00:00:00 ksh deneme U00 32762 32132 0 16:30 pts/2 00:00:00 grep deneme 2-) For the command below, how will I read all lines line by line? For... (1 Reply)
Discussion started by: senem
1 Replies

3. Shell Programming and Scripting

Reading columns in tab delimited file

I want to read only one column in "|" delimited file and write that column to a new file. For Ex: Input File 1|abc|324|tt 2|efd|11|cbcb 3||1|fg 4|ert|23|88 Output : I want to read column 3 in diff file. 324 11 1 88 Can anyone give me inputs on this ? (2 Replies)
Discussion started by: net
2 Replies

4. Shell Programming and Scripting

Compare columns and rows with template, and fill empty slots.

Hi, I'm working on a script that will take the contents of a file, that is in a row and column format, and compare it to a arrangment file. Such that if there is any or all blanks in my content file, the blank will be filled with a flag and will retain the row and column configuration. Ex. ... (2 Replies)
Discussion started by: hizzle
2 Replies

5. Shell Programming and Scripting

Creating a larger .xml file from a template(sample file)

Dear All, I have a template xml file like below. ....Some---Header....... <SignalPreference> ... <SignalName>STRING</SignalName> ... </SignalPreference> ......Some formatting text....... <SignalPreference> ......... ... (3 Replies)
Discussion started by: ks_reddy
3 Replies

6. Programming

Reading multiple columns in C++

Dear all, I am novice in C+= programing. I would like to seek help in one of the progra. Here it is, I have txt file which has the data as following order varA varB -21 0 -21.2 3, 4, 5, 6 -21.4 45, 65, 87, 98, 98 -22.0 345677, 349887, 98766, 877654, 987543 -23.0 76549,... (17 Replies)
Discussion started by: emily
17 Replies

7. Shell Programming and Scripting

Reading columns from a text file and to make an array for each column

Hi, I am not so familiar with bash scripting and would appreciate your help here. I have a text file 'input.txt' like this: 2 3 4 5 6 7 8 9 10 I want to store each column in an array like this a ={2 5 8}, b={3 6 9}, c={4 7 10} so that i can access any element, e.g b=6 for the later use. (1 Reply)
Discussion started by: Asif Siddique
1 Replies

8. Shell Programming and Scripting

Making a composite file of transposed columns

Hello, I have a directory with allot of tab delimited text files that have data that look like, filePath distance (1,4-dioxan-2-ylmethyl)methylamine 0.0 4-methylmorpholine 0.0755473632594 1-propyl-4-piperidone 0.157792911954 heptaminol 0.158142893249 N-acetylputrescine 0.158689628956... (3 Replies)
Discussion started by: LMHmedchem
3 Replies

9. Shell Programming and Scripting

Reading specific range of columns in an Excel file

Hi All, I want to read an excel file. PFA excel, I want to read the cloumn from A to G and the V to AH starting from Row number 3. Please help me on this. (7 Replies)
Discussion started by: Abhisrajput
7 Replies

10. Shell Programming and Scripting

Reading columns using arrays

Hello, Please help in how to read rows and columns using array and print them. I have below output and i want to store this in array and print the required rows or columns. aaaaaaa 123 bbbbbb 456 ccccccc 888 Use code tags, thanks. (1 Reply)
Discussion started by: Cva2568
1 Replies

LEARN ABOUT DEBIAN

createpymb

CREATEPYMB(1)						      General Commands Manual						     CREATEPYMB(1)

NAME

       createPYMB, readPYBase, readPYMB, mb2org, scel2org - fcitx Pinyin related tools

SYNOPSIS

       createPYMB <PinyinFile> <PhraseFile>

       readPYBase [-b <PinyinMBFile>] [-h]

       readPYMB [-f <PhraseMBFile>] [-s] [-h]

       mb2org [-b <PinyinMBFile>] [-f <PhraseMBFile>] [-s] [-h]

       scel2org [-o <Phrase File>] [-h]

DESCRIPTION

       -b <PinyinMBFile>
	      If not specified, it will read system default pybase.mb.

       -f <PhraseMBFile>
	      If not specified, it will read user default PhraseMBFile, which is ~/.config/fcitx/pyusrphrase.mb.

       -s     If specified, it will read PhraseMBFile as system format, otherwise will read it as user format.

       -h     display help and exit

       Pinyin File
	      Pinyin  File  is	a file with pinyin and one character per line, separated with space. One available file is in the source of fcitx,
	      named gbkpy.org.

       Phrase File
	      Phrase File is a file with full pinyin separated with ' and the corresponding phrase. The default phrase file of fcitx can be  down-
	      loaded at http://fcitx.googlecode.com/files/pinyin.tar.gz.

       Pinyin MB File
	      Pinyin MB File is the binary format of Pinyin File.

       Phrase MB File
	      Phrase  MB  File is the binary format of Pinyin File, user's history phrase mb file is ~/.config/fcitx/pyuserphrase.mb. There is two
	      different format, one is system format which can only generated by createPYMB , and other is user format which  can  only  generated
	      while input with fcitx Pinyin IM.

       Output of createPYMB will be pybase.mb, which is Pinyin MB File, and pyphrase.mb, which is Phrase MB File.

       Output  of  mb2org,  readPYBase and readPYMB will be stdout. readPYBase and readPYMB are designed to output more debug message of Pinyin MB
       File and Phrase MB File. mb2org will output in the format of Phrase File.

       scel2org is used for transform Sogou Scel File to Phrase File of fcitx. Output of scel2org will be stdout if -o is not used.

SEE ALSO

       Please see the homepage at http://www.fcitx.org/ and http://fcitx.googlecode.com/

								    2010-12-16							     CREATEPYMB(1)
All times are GMT -4. The time now is 04:26 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy