Login or Register to Ask a Question and Join Our Community


UNIX for Advanced & Expert Users

How to sum a column 2 and column 3

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums UNIX for Advanced & Expert Users How to sum a column 2 and column 3
# 29  
Old 02-23-2012
it is not space.

its the ascii value of 240 (Hypen)

try the below command.

take a backup of your file and issue the below commands.

Code:
 
cp input.txt input.txt.bk
tr -cd '\240' < input.txt > output.txt

# 30  
Old 02-23-2012
Hi itkamaraj,

When i use this command i get empty file as output.

Code:
# tr -cd '\240' < pipe.txt
                                                                                                                                                                                                                                                                                                                                                                                                                [root@olive #

# 31  
Old 02-23-2012
can you try this

the below code is to remove the non-printing characters

Code:
 
perl -lane '$_=~ tr/\x20-\x7f//cd;print $_' input.txt > output.txt

This User Gave Thanks to itkamaraj For This Post:
Paulwintech
# 32  
Old 02-23-2012
Code:
tr -sc '[:print:]\n' ' ' <input.txt >output.txt

This will replace any succession of non-printable caracter (including the \240) by a single space (\040) .


Code:
# printf "a\240\240\240\240\t\040\040  a\n"
a           a
# printf "a\240\240\240\240\t\040\040  a\n" | od -bc
0000000 141 240 240 240 240 011 040 040 040 040 141 012
          a 240 240 240 240  \t                   a  \n
0000014
# printf "a\240\240\240\240\t\040\040  a\n" | tr -sc '[:print:]\n' ' '
a a
# printf "a\240\240\240\240\t\040\040  a\n" | tr -sc '[:print:]\n' ' ' | od -bc
0000000 141 040 141 012
          a       a  \n
0000004

---------- Post updated at 10:27 AM ---------- Previous update was at 09:54 AM ----------

Quote:
Originally Posted by itkamaraj
it is not space.

its the ascii value of 240 (Hypen)

try the below command.

take a backup of your file and issue the below commands.

Code:
 
cp input.txt input.txt.bk
tr -cd '\240' < input.txt > output.txt

You should remove the -c option.

But instead of deleting it you may want to replace it.

Code:
tr -s '\240' ' ' <input.txt >output.txt

or more generic :

Code:
tr -s '\240[:blank:]' ' ' <input.txt >output.txt

This should do the work
Last edited by ctsgnb; 02-23-2012 at 05:17 AM..
This User Gave Thanks to ctsgnb For This Post:
itkamaraj
# 33  
Old 02-23-2012
Hi itkamaraj,

Perl script worked perfectly, thanks you so much....

Regards
Paulwintech
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

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

2. Shell Programming and Scripting

awk to Sum columns when other column has duplicates and append one column value to another with Care

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... (1 Reply)
Discussion started by: as7951
1 Replies

3. UNIX for Beginners Questions & Answers

Sum the values in the column using date column

I have a file which need to be summed up using date column. I/P: 2017/01/01 a 10 2017/01/01 b 20 2017/01/01 c 40 2017/01/01 a 60 2017/01/01 b 50 2017/01/01 c 40 2017/01/01 a 20 2017/01/01 b 30 2017/01/01 c 40 2017/02/01 a 10 2017/02/01 b 20 2017/02/01 c 30 2017/02/01 a 10... (6 Replies)
Discussion started by: Booo
6 Replies

4. UNIX for Dummies Questions & Answers

Match sum of values in each column with the corresponding column value present in trailer record

Hi All, I have a requirement where I need to find sum of values from column D through O present in a CSV file and check whether the sum of each Individual column matches with the value present for that corresponding column present in the trailer record. For example, let's assume for column D... (9 Replies)
Discussion started by: tpk
9 Replies

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

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

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

8. UNIX for Dummies Questions & Answers

How to sum rows in e.g. column 1 by a category in e.g. column 2

Hi, I've shown an example of what I would like to achieve below. In the example file, I would like to sum the values in column 2 for each distinct category in column 3 (presumably making an array?) and print the sum as well as the category name and length (note:length always corresponds with... (8 Replies)
Discussion started by: auburn
8 Replies

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

10. 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
Login or Register to Ask a Question