Sponsored Content
Top Forums UNIX for Beginners Questions & Answers Copy columns from one file into another and get sum of column values and row count Post 303020321 by Tahir_M on Monday 16th of July 2018 09:48:23 PM
Old 07-16-2018
Yes UTF-8 does exist in the file.
The Date Column should have the current date values: example

Code:
DATE                           Sum_Amount     RECORD_COUNT

07/15/2018                      29039.44         

07/15/2018                     314038.03         

07/15/2018                      41424.75         

07/15/2018                      90314.27         

07/15/2018                      66416.22         

07/15/2018                       2013.55         

07/15/2018                       1172.35         

Total:                             544418.61        51

All the amounts are in same currency i.e USD.

Last edited by Tahir_M; 07-16-2018 at 10:50 PM.. Reason: adding proper code tags
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to check Null values in a file column by column if columns are Not NULLs

Hi All, I have a table with 10 columns. Some columns(2nd,4th,5th,7th,8th and 10th) are Not Null columns. I'll get a tab-delimited file and want to check col by col and generate seperate error code for each col eg:102 if 2nd col value is NULL and 104 if 4th col value is NULL so on... I am a... (7 Replies)
Discussion started by: Mandab
7 Replies

2. Shell Programming and Scripting

print unique values of a column and sum up the corresponding values in next column

Hi All, I have a file which is having 3 columns as (string string integer) a b 1 x y 2 p k 5 y y 4 ..... ..... Question: I want get the unique value of column 2 in a sorted way(on column 2) and the sum of the 3rd column of the corresponding rows. e.g the above file should return the... (6 Replies)
Discussion started by: amigarus
6 Replies

3. Shell Programming and Scripting

Sum of values coming in a row

Hi, my requirement is to sum values in a row. eg: input is: sum,value1,value2,value3,.....,value N Required Output: sum,<summation of N values> Please help me... (5 Replies)
Discussion started by: MrGopal666
5 Replies

4. Shell Programming and Scripting

Copy values from columns matching in those in second file.

Hi All, I have two sets of files. Set 1: 100 text files with extension .txt with names like 1.txt, 2.txt, 3.txt until 100.txt Set 2: One big file with extension .dat The text files have some records in columns like this: 0.7316431 82628 0.7248189 82577 0.7248182 81369 0.7222999... (1 Reply)
Discussion started by: shoaibjameel123
1 Replies

5. UNIX for Dummies Questions & Answers

Count on grep for more than two values in a row of fixed length file

I want to get count on number of records in a few folders by running grep command for more than two columns in a row of fixed length file. suppose if i have a fixed length file has 5 columns and I want to see the record counts for country =can and province = bc and time stamp <= 12 feb 2013... (14 Replies)
Discussion started by: princetd001
14 Replies

6. Shell Programming and Scripting

Sum specified values (columns) per row

Hello out there, file.txt: comp51820_c1_seq1 42 N 0:0:0:0:0:0 1:0:0:0:0:0 0:0:0:0:0:0 3:0:0:0:0:0 0:0:0:0:0:0 comp51820_c1_seq1 43 N 0:0:0:0:0:0 0:1:0:0:0:0 0:0:0:0:0:0 0:3:0:0:0:0 0:0:0:0:0:0 comp51820_c1_seq1 44 N 0:0:4:0:3:1 0:0:1:9:0:0 10:0:0:0:0:0 0:3:3:2:2:6 2:2:2:5:60:3... (16 Replies)
Discussion started by: pathunkathunk
16 Replies

7. UNIX for Dummies Questions & Answers

Unique values in a row sum the next column in UNIX

Hi would like to ask you guys any advise regarding my problem I have this kind of data file.txt 111111111,20 111111111,50 222222222,70 333333333,40 444444444,10 444444444,20 I need to get this file1.txt 111111111,70 222222222,70 333333333,40 444444444,30 using this code I can... (6 Replies)
Discussion started by: reks
6 Replies

8. Shell Programming and Scripting

Add sum of columns and max as new row

Hi, I am a new bie i need some help with respect to shell onliner; I have data in following format Name FromDate UntilDate Active Changed Touched Test 28-03-2013 28-03-2013 1 0.6667 100 Test2 28-03-2013 03-04-2013 ... (1 Reply)
Discussion started by: gangaraju6
1 Replies

9. Shell Programming and Scripting

Sum values of specific column in multiple files, considering ranges defined in another file

I have a file (let say file B) like this: File B: A1 3 5 A1 7 9 A2 2 5 A3 1 3 The first column defines a filename and the other two define a range in that specific file. In the same directory, I have also three more files (File A1, A2 and A3). Here is 10 sample lines... (3 Replies)
Discussion started by: Bastami
3 Replies

10. Shell Programming and Scripting

Do replace operation and awk to sum multiple columns if another column has duplicate values

Hi Experts, Please bear with me, i need help I am learning AWk and stuck up in one issue. First point : I want to sum up column value for column 7, 9, 11,13 and column15 if rows in column 5 are duplicates.No action to be taken for rows where value in column 5 is unique. Second point : For... (12 Replies)
Discussion started by: as7951
12 Replies
tbl(1)							      General Commands Manual							    tbl(1)

Name
       tbl - format tables for nroff or *roff

Syntax
       tbl [files...]

Description
       The  preprocessor  is used for formatting tables for or The input files are copied to the standard output, except for lines between .TS and
       .TE command lines, which are assumed to describe tables and are reformatted.

Options
       -TX     Produces output without fractional line motions.  Use when the destination output device or printer or  post-filter  cannot  handle
	       fractional line motions.

       -ms     Reads in macros prior to table formatting.

       -mm     Reads in the macros prior to table formatting, if your system has the macros installed.

Examples
       As an example, letting 	 represent a tab (which should be typed as a genuine tab) the input

	      .TS
	      c s s
	      c c s
	      c c c
	      l n n.
	      Household Population
	      Town	Households
	      	Number	Size
	      Bedminster	789	3.26
	      Bernards Twp.	3087	3.74
	      Bernardsville	2018	3.30
	      Bound Brook	3425	3.04
	      Branchburg	1644	3.49
	      Bridgewater	7897	3.81
	      Far Hills	240	3.19
	      .TE

       yields

		  Household Population
		  Town	       Households
			      Number   Size
	      Bedminster	789    3.26
	      Bernards Twp.    3087    3.74
	      Bernardsville    2018    3.30
	      Bound Brook      3425    3.04
	      Branchburg       1644    3.49
	      Bridgewater      7897    3.81
	      Far Hills 	240    3.19

       If  no  arguments are given, reads the standard input, so it may be used as a filter.  When is used with or the command should be first, to
       minimize the volume of data passed through pipes.

See Also
       nroff(1)
       "Tbl - A Program to Format Tables," ULTRIX Supplementary Documents, Vol. I:General User

																	    tbl(1)
All times are GMT -4. The time now is 02:59 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy