I want to mege the rows based on first column with same ID. In column 2, I want only ID starting with PF and in 3rd column, want to concatenate all GO term seperated with comma. in each case there should be no duplicate eg:
Thankyou
Last edited by anjaliANJALI; 08-13-2019 at 01:43 PM..
Hi,
I have two files consisting of two columns. So I want to merge column 2 if column 1 is the same. So heres an example of what I mean.
FILE1
driver 444
car 333
hat 222
FILE2
driver 333
car 666
hat 999
So I want to merge the column 2's together so... (4 Replies)
Guys,
i have a file in below format where the barcode's are uniq per site but could be repeated for different site. so i want to convert the site column to rows based on the barcode's as below output.
your help is appreciated!!!
input:
SITE BARCODE QTY SP CP
10001 6281103890017 10 50 48... (5 Replies)
Hi All,
I do have 2 files
file 1 has 4 tab delimited columns
234 a c dfgyu
294 b g fih
302 c h jzh
328 z c san
597 f g son
File 2 has 2 tab delimted columns
234 23
302 24
597 24
I want to merge file 2 with file 1 based on the data common in both files which is the first column so... (6 Replies)
I had two files file1 and file2. I want a o/p file(file3) like below using first column as ref. Pls give suggestion ass join is not working as the number of lines in each file is nealry 5 C?
file1
---------------------
404000324810001 Y
404000324810004 N
404000324810008 Y
404000324810009 N... (1 Reply)
I have the following space-delimited input:
1 11.785710 117.857100
1 15 150
1 20 200
1 25 250
3 2.142855 21.428550
3 25 250
22 1.071435 10.714350
The first field is the ID number, the second field is the percentage of the total points that the person has and the third column is the number... (3 Replies)
I have 2 files,
file01= 7 columns, row unknown (but few)
file02= 7 columns, row unknown (but many)
now I want to create an output with the first field that is shared in both of them and then subtract the results from the rest of the fields and print there
e.g.
file 01
James|0|50|25|10|50|30... (1 Reply)
Hi,
I have a file which I'd like to merge lines based on duplicates in one column while keeping the info for other columns. Let me simplify it by an example:
File
ESR1 ANASTROZOLE NA FDA_approved
ESR1 CISPLATIN NA FDA_approved
ESR1 DANAZOL agonist NA
ESR1 EXEMESTANE NA FDA_approved... (3 Replies)
Hello :)
I am in this situation:
Input: two tab-delimited files, `File1` and `File2`. `File2` (`$2`) has to be parsed by patterns found in `File1` (`$1`).
Expected output: tab-delimited file, `File3`. `File3` has to contain the same rows as `File2`, plus the corresponding value in... (5 Replies)
I Want to merge multiple lines based on the 1st field and keep into single record.
SRC File:
AAA_POC_DB.TAB1
AAA_POC_DB.TAB2
AAA_POC_DB.TAB3
AAA_POC_DB.TAB4
BBB_POC_DB.TAB1
BBB_POC_DB.TAB2
CCC_POC_DB.TAB6
OUTPUT
-----------------
'AAA_POC_DB','TAB1','TAB2','TAB3','TAB4'... (10 Replies)
Discussion started by: raju2016
10 Replies
LEARN ABOUT DEBIAN
shorewall-init
SHOREWALL-INIT(8) [FIXME: manual] SHOREWALL-INIT(8)NAME
shorewall-init - Companion package
SYNOPSIS
/etc/init.d/shorewall-init [start|stop]
DESCRIPTION
Shorewall-init is an optional package (added in Shorewall 4.4.10) that can be installed along with Shorewall, Shorewall6, Shorewall-lite
and/or Shorewall6-lite. It provides two key features:
1. It can close (stop) the firewall during boot prior to starting the network. This can prevent unwanted connections from being accepted
after the network comes up but before the firewall is started.
2. It can interface with your distribution's ifup/ifdown scripts and/or NetworkManager to allow firewall actions when an interface starts
or stops.
These two capabilities can be enabled separately.
After you install the shorewall-init package, you can activate it by modifying the Shorewall-init configuration file:
o On Debian-based system, the file is /etc/default/shorewall-init.
o On other systems, the file is /etc/sysconfig/shorewall-init.
To activate the safe boot feature, edit the configuration file and set PRODUCTS to a space-separated list of Shorewall products that you
want to be closed before networking starts.
Example:
PRODUCTS="shorewall shorewall6"
You also must insure that the compiled scripts for the listed products are compiled using Shorewall 4.4.10 or later.
Shorewall
shorewall compile
Shorewall6
shorewall6 compile
Shorewall-lite
On the administrative system, enter the command shorewall export firewall from the firewall's configuration directory.
Shorewall6-lite
On the administrative system, enter the command shorewall6 export firewall from the firewall's configuration directory.
The second feature (ifup/ifdown and NetworkManager integration) should only be activated on systems that do not use a link status monitor
line swping or LSM.
o Edit the configuration file and set IFUPDOWN=1
For NetworkManager integration, you will want to disable firewall startup at boot and delay it to when your interface comes up. For this to
work correctly, you must set the required or the optional option on at least one interface then:
o On Debian-based systems, edit /etc/default/product for each product listed in the PRODUCTS setting and set startup=0.
o On other systems, use the distribution's service control tool (insserv, chkconfig, etc.) to disable startup of the products listed in
the PRODUCTS setting.
On a laptop with both ethernet and wireless interfaces, you will want to make both interfaces optional and set the REQUIRE_INTERFACE option
to Yes in shorewall.conf[1](5) or shorewall6.conf[2] (5). This causes the firewall to remain stopped until at least one of the interfaces
comes up.
FILES
/etc/default/shorewall-init (Debian-based systems) or /etc/sysconfig/shorewall-init (other distributions)
SEE ALSO shorewall(8), shorewall-accounting(5), shorewall-actions(5), shorewall-blacklist(5), shorewall-hosts(5), shorewall_interfaces(5),
shorewall-ipsets(5), shorewall-maclist(5), shorewall-masq(5), shorewall-nat(5), shorewall-netmap(5), shorewall-params(5),
shorewall-policy(5), shorewall-providers(5), shorewall-proxyarp(5), shorewall-rtrules(5), shorewall-routestopped(5), shorewall-rules(5),
shorewall.conf(5), shorewall-secmarks(5), shorewall-tcclasses(5), shorewall-tcdevices(5), shorewall-tcrules(5), shorewall-tos(5),
shorewall-tunnels(5), shorewall-zones(5)NOTES
1. shorewall.conf
http://www.shorewall.net/manpages/shorewall.conf.html
2. shorewall6.conf
http://www.shorewall.net/manpages/../Manpages6/shorewall6.conf.html
[FIXME: source] 06/28/2012 SHOREWALL-INIT(8)