Split a file based on number sum at the second column and the third column. Post: 303044693

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...

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. 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|.........

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...

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...

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...

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

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 ...

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...

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

LEARN ABOUT CENTOS

crontabs

CRONTABS(4)						      Crontabs users' Manual						       CRONTABS(4)

NAME

       crontabs - configuration and scripts for running periodical jobs

SYNOPSIS

       run-parts [--list|--test]<directory>

DESCRIPTION

       Crontabs  is  a historical name for the run-parts script and the system crontab. The run-parts script runs all executables in the specified
       directory.  Run-parts runs all executables in the specified directory.  The execution of files can be allowed or denied	by  creating  file
       jobs.allow or jobs.deny which worked similar as other allow/deny config files. The file must be created in the specified directory.

       --list print names of all files (not limited to executables), but don't run them. This option can't be used with test option.

       --test print names of files, which would be run.

	      Randomization  of  jobs  can  be configured in the /etc/sysconfig/run-parts file. To enable randomization of jobs, set the RANDOMIZE
	      parameter to 1 and set the RANDOM parameter to an integer which determines a random seed. Additionally, you may configure  the  RAN-
	      DOMTIME  parameter  (again,  by specifying an integer) to provide an additional level of randomization. Jobs are not randomized when
	      the RANDOM and RANDOMTIME parameters are set to 0. Values in these two parameters must be set to 1  or  larger  to  provide  a  good
	      enough randomization.

	      Randomization of cron jobs can be useful for shared networks, where multiple cron jobs executed at once can cause spikes in traffic,
	      especially during daily jobs. With randomized jobs, the workload is evenly distributed throughout the day.

EXAMPLE OF CONFIGURATION FILE

       RANDOMIZE=1
       RANDOM=4
       RANDOMTIME=8

       Historically the crontab file contained configuration which called run-parts on files  in  cron.{daily,weekly,monthly}  directories.  These
       jobs  are  now  run  indirectly	through  anacron  to prevent conflicts between cron and anacron.  That means the anacron package has to be
       installed if the jobs in these directories should be running. Refer to the anacron(8) how to limit the time of day of the job execution.

EXAMPLE

       /etc/cron.daily/jobs.deny could contain for example 0logwatch which forbid execution of this script.

SEE ALSO

       anacron(8), crontab(5)

Marcela Malaova 						    2012-08-29							       CRONTABS(4)