Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: awk command to manipulate csv file in UNIX
Top Forums Shell Programming and Scripting awk command to manipulate csv file in UNIX Post 302965836 by RudiC on Wednesday 3rd of February 2016 01:07:57 PM
Old 02-03-2016
Difficult to believe. The proposal was tested with your sample in post#1 before posted with the given result, and a repeated test now yields the same.
So - the difference must lie in
- the awk version - which is yours?
- the input file / file structure
- correctness of copy and paste the program
Please post the conditions that you ran the program in.

---------- Post updated at 19:07 ---------- Previous update was at 19:07 ----------

One suspicion: an empty line in (at the end of?) the input file. Result with an empty line:
Code:
col1,Sum of col4,Sum of col5
223,10,13
227,7,2
228,12,34
,0,0

 

10 More Discussions You Might Find Interesting

1. Filesystems, Disks and Memory

manipulate csv file to add columns

Hi, I have a csv file with a key composed by 3 columns and some other numeric fields and I need to obtain the partial amounts by some part of the key. This may be some difficult to understand, so better see an example, where my input file is: name,surname,department,y2004,y2005,y2006... (6 Replies)
Discussion started by: oscarmon
6 Replies

2. Shell Programming and Scripting

Using awk command for .csv file

Hi , I have .csv file with value separated by ";". 1. Using awk how to extract perticular colums and store in to array 2. For some columns I needs to extract last value of the column How to do same please help me ASAP Thanks and Regards, Sushma (9 Replies)
Discussion started by: sushmab82
9 Replies

3. UNIX for Dummies Questions & Answers

Question on how to manipulate a SIMPLE text file (using awk?)

I have a simple txt files that looks something like this (The title is a part of the text file) Student Grades --------------- 1 Tim Purser 89 2 John Wayne 56 3 Jenn Hawkins 95 4 Harry Potter 75 Here are my questions: How would I ONLY print the names of students... (2 Replies)
Discussion started by: ninjagod123
2 Replies

4. UNIX for Dummies Questions & Answers

xml to csv using sed and awk command

Hi Guys, Can you help me in creating shell script using sed,awk etc commands to generate csv file using xml file. (5 Replies)
Discussion started by: sbk
5 Replies

5. Shell Programming and Scripting

UNIX command output in csv format

I'm just wondering is there any way to capture the output of a unix command in a csv format. df -h gives the result of filesystem,free space,Used space, use %,mounted on. Is there a way to capture the command output and format it as comma sparated or fixed length file. (3 Replies)
Discussion started by: anita81
3 Replies

6. Shell Programming and Scripting

Manipulate a CSV File

Hello, How do i manipulate .csv file to this format? Thank you very much. Source: john,5 marco,7 john,4 paul,3 marco,8 Output: john,9 marco,15 (5 Replies)
Discussion started by: tara123
5 Replies

7. Shell Programming and Scripting

awk command to manipulate csv file in UNIX

Hi, I am new to awk/unix and am trying to put together a script to manipulate the date column in a csv file. I have file1.csv with the following contents: Date,ID,Number,Amount,Volume,Size 01-Apr-2014,WERFG,998,105873.96,10873.96,1342.11 01-Apr-2014,POYFR,267,5681.44,5681.44,462.96 I... (2 Replies)
Discussion started by: Prit Siv
2 Replies

8. Shell Programming and Scripting

Manipulate the text file in UNIX

Hi All, I have a file like below and i have 2 questions on this (They are 3 lines starts with 01 , 02 and 03. but is 01abc333644554 234 2334535 34534535355353 sfsdf345455 353 4543 jgkg tty 7676 02cdesdfsdfsdf 234 wesdfsdf 345345 234234 234234 2342342 dfgdfg sdfgg dgdgdg fgvfs... (6 Replies)
Discussion started by: siva.pitchai
6 Replies

9. UNIX for Beginners Questions & Answers

awk command to retrieve record 23 and 89 from UNIX file

Hi Everyone, I am looking for awk command to retrieve only the record number 23 and record number 89 from a unix file? Please let me know what is the awk command for this? Regards Rakesh (1 Reply)
Discussion started by: rakeshp
1 Replies

10. Homework & Coursework Questions

awk command to retrieve record 23 and 89 from UNIX file

Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted! 1. The problem statement, all variables and given/known data: I am looking for awk command to retrieve only the record number 23 and record number 89 from a unix file?... (6 Replies)
Discussion started by: rakeshp
6 Replies

LEARN ABOUT FREEBSD

pgmtexture

pgmtexture(1)						      General Commands Manual						     pgmtexture(1)

NAME

       pgmtexture - calculate textural features on a portable graymap

SYNOPSIS

       pgmtexture [-d d] [pgmfile]

DESCRIPTION

       Reads  a  portable graymap as input.  Calculates textural features based on spatial dependence matrices at 0, 45, 90, and 135 degrees for a
       distance d (default = 1).  Textural features include:

	      (1) Angular Second Moment,
	      (2) Contrast,
	      (3) Correlation,
	      (4) Variance,
	      (5) Inverse Difference Moment,
	      (6) Sum Average,
	      (7) Sum Variance,
	      (8) Sum Entropy,
	      (9) Entropy,
	      (10) Difference Variance,
	      (11) Difference Entropy,
	      (12, 13) Information Measures of Correlation, and
	      (14) Maximal Correlation Coefficient.

       Algorithm taken from:
       Haralick, R.M., K. Shanmugam, and I. Dinstein. 1973. Textural features for image classification.  IEEE Transactions on  Systems,  Man,  and
       Cybertinetics, SMC-3(6):610-621.

BUGS

       The  program  can  run incredibly slow for large images (larger than 64 x 64) and command line options are limited.  The method for finding
       (14) the maximal correlation coefficient, which requires finding the second largest eigenvalue of a matrix Q, does not always converge.

REFERENCES

       IEEE Transactions on Systems, Man, and Cybertinetics, SMC-3(6):610-621.

SEE ALSO

       pgm(5), pnmcut(1)

AUTHOR

       Copyright (C) 1991 by Texas Agricultural Experiment Station, employer for hire of James Darrell McCauley.

								    22 Aug 1991 						     pgmtexture(1)
All times are GMT -4. The time now is 06:46 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy