Sponsored Content
Top Forums UNIX for Beginners Questions & Answers Split a file based on number sum at the second column and the third column. Post 303044693 by demo10 on Monday 2nd of March 2020 12:41:16 AM
Old 03-02-2020
I tried to do using bedtools makewindows option and bedops chop option, but none of them worked as I need.
This is why I asked here. I know this forum or another forums are not a script writing service. This is the best I can do because my efforts that I know did not worked.
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How do I sum one column based on another column?

Hi, I am new to this forum and new to awk. I have a file that contains 2 columns. Heres an example of what it looks like: 10 + 20 + 40 + 50 - 70 - So the file is tab-delimited. What I want to do is add 10 to column 1 whenever column 2 is + and substract 10 from column 1... (1 Reply)
Discussion started by: phil_heath
1 Replies

2. Shell Programming and Scripting

Split single file into multiple files based on the number in the column

Dear All, I would like to split a file of the following format into multiple files based on the number in the 6th column (numbers 1, 2, 3...): ATOM 1 N GLY A 1 -3.198 27.537 -5.958 1.00 0.00 N ATOM 2 CA GLY A 1 -2.199 28.399 -6.617 1.00 0.00 ... (3 Replies)
Discussion started by: tomasl
3 Replies

3. Shell Programming and Scripting

Split the file based on column

Hi, I have a file sample_1.txt (300k rows) which has data like below: * Also each record is around 64k bytes 11|1|abc|102553|125589|64k bytes of data 10|2|def|123452|123356|...... 13|2|geh|144351|121123|... 25|4|fgh|165250|118890|.. 14|1|abc|186149|116657|......... (6 Replies)
Discussion started by: sol_nov
6 Replies

4. Shell Programming and Scripting

Sum Of Column Based On Column Condition

I have a following inputfile MT,AP,CDM,TTML,MUM,GS,SUCC,3 MT,AP,CDM,TTSL,AP,GS,FAIL,9 MT,AP,CDM,RCom,MAH,GS,SUCC,3 MT,AP,CDM,RTL,HP,GS,SUCC,1 MT,AP,CDM,Uni,UPE,GS,SUCC,2 MT,AP,CDM,Uni,MUM,GS,SUCC,2 TTSL,AP,GS,MT,MAH,CDM,SUCC,20 TTML,AP,GS,MT,MAH,CDM,FAIL,10... (2 Replies)
Discussion started by: siramitsharma
2 Replies

5. Shell Programming and Scripting

awk to sum a column based on duplicate strings in another column and show split totals

Hi, I have a similar input format- A_1 2 B_0 4 A_1 1 B_2 5 A_4 1 and looking to print in this output format with headers. can you suggest in awk?awk because i am doing some pattern matching from parent file to print column 1 of my input using awk already.Thanks! letter number_of_letters... (5 Replies)
Discussion started by: prashob123
5 Replies

6. Shell Programming and Scripting

Sum column values based in common identifier in 1st column.

Hi, I have a table to be imported for R as matrix or data.frame but I first need to edit it because I've got several lines with the same identifier (1st column), so I want to sum the each column (2nd -nth) of each identifier (1st column) The input is for example, after sorted: K00001 1 1 4 3... (8 Replies)
Discussion started by: sargotrons
8 Replies

7. Shell Programming and Scripting

Split column data if the table has n number of column's

please write a shell script Table -------------------------- 1 2 3 a b c 3 4 5 c d e 7 8 9 f g h Output should be like this --------------- 1 2 3 3 4 5 7 8 9 a b c c d e f g h (1 Reply)
Discussion started by: Priti2277
1 Replies

8. Shell Programming and Scripting

Split column data if the table has n number of column's with some record

Split column data if the table has n number of column's with some record then how to split n number of colmn's line by line with records Table --------- Col1 col2 col3 col4 ....................col20 1 2 3 4 .................... 20 a b c d .................... v ... (11 Replies)
Discussion started by: Priti2277
11 Replies

9. Shell Programming and Scripting

Sum of a column as new column based on header in a script

Hello, I am trying to store sum of a column as a new column inside a file but have to find the column names dynamically I/p c1,c2,c3,c4,c5 10,20,30,40,50 20,30,40,50,60 If i want to find sum only column c1, c3 and output it as c6,c7 O/p c1,c2,c3,c4,c5,c6,c7 10,20,30,40,50,30,70... (6 Replies)
Discussion started by: mkathi
6 Replies

10. UNIX for Beginners Questions & Answers

Sum in file based column

Hi All, I have a file as below and want to sum based on the id in the first column Input 10264;ATE; 12 10265;SES;11 10266AUT;50 10264;ATE;10 10265;SES;13 10266AUT;89 10264;ATE;1 10265;SES;15 10266AUT;78 Output 10264;ATE; 23 10265;SES;39 10266AUT;139 (6 Replies)
Discussion started by: arunkumar_mca
6 Replies
pmadm(1M)																 pmadm(1M)

NAME
pmadm - port monitor administration SYNOPSIS
pmadm -a [-p pmtag | -t type] -s svctag -i id -m pmspecific -v ver [ -f xu] [-y comment] [-z script] pmadm -r -p pmtag -s svctag pmadm -e -p pmtag -s svctag pmadm -d -p pmtag -s svctag pmadm -l [-t type | -p pmtag] [-s svctag] pmadm -L [-t type | -p pmtag] [-s svctag] pmadm -g -p pmtag -s svctag [-z script] pmadm -g -s svctag -t type -z script pmadm is the administrative command for the lower level of the Service Access Facility hierarchy, that is, for service administration. A port may have only one service associated with it although the same service may be available through more than one port. In order to uniquely identify an instance of a service, the pmadm command must identify both the port monitor or port monitors through which the ser- vice is available (-p or -t) and the service (-s). See . pmadm performs the following functions: o adds or removes a service o enables or disables a service o installs or replaces a per-service configuration script o prints requested service information Any user on the system may invoke pmadm to request service status (-l or -L) or to print per-service configuration scripts (-g without the -z option). pmadm with other options may be executed only by a privileged user. The following options are supported: -a Add a service. pmadm adds an entry for the new service to the port monitor's administrative file. Because of the complexity of the options and arguments that follow the -a option, it may be convenient to use a command script or the menu system to add services. -d Disable a service. Add x to the flag field in the entry for the service svctag in the port monitor's administrative file. This is the entry used by port monitor pmtag. See the -f option, below, for a description of the flags available. -e Enable a service. Remove x from the flag field in the entry for the service svctag in the port monitor administrative file. This is the entry used by port monitor pmtag. See the -f option, below, for a description of the flags available. -f xu The -f option specifies one or both of the following two flags which are then included in the flag field of the entry for the new service in the port monitor's administrative file. If the -f option is not included, no flags are set and the default conditions prevail. By default, a new service is enabled and no utmpx entry is created for it. An -f option without a following argument is illegal. x Do not enable the service svctag available through port monitor pmtag. u Create a utmpx entry for service svctag available through port monitor pmtag. -g Print, install, or replace a per-service configuration script. The -g option with a -p option and a -s option prints the per-service configuration script for service svctag available through port monitor pmtag. The -g option with a -p option, a -s option, and a -z option installs the per-service configuration script contained in the file script as the per-service configuration script for service svctag available through port monitor pmtag. The -g option with a - s option, a -t option, and a -z option installs the file script as the per-service configuration script for service svctag available through any port monitor of type type. Other combinations of options with -g are invalid. -i id id is the identity that is to be assigned to service svctag when it is started. id must be an entry in /etc/passwd. -l The -l option requests service information. Used by itself and with the options described below, it provides a filter for extracting information in several different groupings. -l By itself, the -l option lists all services on the system. -l -p pmtag Lists all services available through port monitor pmtag. -l -s svctag Lists all services with tag svctag. -l -p pmtag-ssvctag Lists service svctag. -l -t type Lists all services available through port monitors of type type. -l -t type-ssvctag Lists all services with tag svctag available through a port monitor of type type. Other combinations of options with -l are invalid. -L The -L option is identical to the -l option except that output is printed in a condensed format. -m pmspecific pmspecific is the port monitor-specific portion of the port monitor administrative file entry for the service. -p pmtag Specifies the tag associated with the port monitor through which a service (specified as -s svctag) is available. -r Remove a service. When pmadm removes a service, the entry for the service is removed from the port monitor's administrative file. -s svctag Specifies the service tag associated with a given service. The service tag is assigned by the system administrator and is part of the entry for the service in the port monitor's administrative file. -t type Specifies the port monitor type. -v ver Specifies the version number of the port monitor administrative file. The version number may be given as -v 'pmspec -V` where pmspec is the special administrative command for port monitor pmtag. This special command is ttyadm for ttymon and nlsadmin for listen. The version stamp of the port monitor is known by the command and is returned when pmspec is invoked with a -V option. -y comment Associate comment with the service entry in the port monitor administrative file. -z script Used with the -g option to specify the name of the file that contains the per-service configuration script. Modifying a configuration script is a three-step procedure. First a copy of the existing script is made (-g alone). Then the copy is edited. Finally, the copy is put in place over the existing script (-g with -z). Options that request information write the requested information to the standard output. A request for information using the -l option prints column headers and aligns the information under the appropriate headings. In this format, a missing field is indicated by a hyphen. A request for information in the condensed format using the -L option prints the information in colon-separated fields; missing fields are indicated by two successive colons. # is the comment character. Example 1: Adding a Service to a Port Monitor with the Tag pmtag The following command adds a service to a port monitor with tag pmtag and gives the service the tag svctag. The port monitor-specific information is generated by specpm. The service defined by svctag will be invoked with identity root. pmadm -a -p pmtag -s svctag -i root -m `specpm -a arg1 -b arg2`-v `specpm -V` Example 2: Adding a Service with Service Tab svctag The following command adds a service with service tag svctag, identity guest, and port monitor-specific information generated by specpm to all port monitors of type type: pmadm -a -s svctag -i guest -t type -m `specpm -a arg1 -b arg2`-v `specpm -V` Example 3: Removing a Service The following command removes the service svctag from port monitor pmtag: pmadm -r -p pmtag -s svctag Example 4: Enabling a Service The following command enables the service svctag available through port monitor pmtag: pmadm -e -p pmtag -s svctag Example 5: Disabling a Service The following command disables the service svctag available through port monitor pmtag: pmadm -d -p pmtag -s svctag Example 6: Listing Status Information The following command lists status information for all services: pmadm -l Example 7: Listing Status Information The following command lists status information for all services available through the port monitor with tag ports: pmadm -l -p ports Example 8: Listing Status Information in Condensed Format The following command lists the status information for all services available through the port monitor with tag ports in condensed format: pmadm -L -p ports Example 9: Listing Status Information for All Services List status information for all services available through port monitors of type listen: pmadm -l -t listen Example 10: Printing the per-service Configuration The following command prints the per-service configuration script associated with the service svctag available through port monitor pmtag: pmadm -g -p pmtag -s svctag The following exit values are returned: 0 Successful operation. >0 Operation failed. /etc/saf/pmtag/_config /etc/saf/pmtag/svctag /var/saf/pmtag/* See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |Availability |SUNWcsu | +-----------------------------+-----------------------------+ sac(1M), sacadm(1M), doconfig(3NSL), attributes(5) 10 Nov 1998 pmadm(1M)
All times are GMT -4. The time now is 06:27 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy