awk command to manipulate csv file in UNIX Post: 302915374

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

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

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

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

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

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

8. Shell Programming and Scripting

awk command to manipulate csv file in UNIX

Hi, I am new to awk and unix programming and trying to manipulate a csv file. My current csv file looks like this: col1,col2,col3,col4,col5,col4,col5,col6,col7,col8 223,V,c,2,4,f,r,,y,z 223,V,c,3,2,f,r,,y,z 223,V,c,1,4,f,r,,y,z 223,V,c,4,3,f,r,,y,z 227,V,c,3,1,f,r,,y,z...

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

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

LEARN ABOUT MOJAVE

iofileb.d

iofileb.d(1m)							   USER COMMANDS						     iofileb.d(1m)

NAME

       iofileb.d - I/O bytes by file and process. Uses DTrace.

SYNOPSIS

       iofileb.d

DESCRIPTION

       This  prints  a	summary  of  requested	disk  activity	by pathname, providing totals of the I/O events in bytes. It is a companion to the
       iofile.d script - which prints in terms of I/O wait time, not bytes.  I/O wait time  is	a  better  metric  for	understanding  performance
       issues.	Both disk and NFS I/O are measured.

       Since this uses DTrace, only users with root privileges can run this command.

EXAMPLES

       Sample until Ctrl-C is hit then print report,
	      # iofileb.d

FIELDS

       PID    process ID

       CMD    process name

       KB     kilobytes of disk I/O

       FILE   file pathname

DOCUMENTATION

       See the DTraceToolkit for further documentation under the Docs directory. The DTraceToolkit docs may include full worked examples with ver-
       bose descriptions explaining the output.

EXIT

       iofileb.d will sample until Ctrl-C is hit.

SEE ALSO

       iofile.d(1M), iosnoop(1M), dtrace(1M)

version 1.00							   Feb 20, 2006 						     iofileb.d(1m)

10 More Discussions You Might Find Interesting

1. Filesystems, Disks and Memory

manipulate csv file to add columns

Discussion started by: oscarmon

2. Shell Programming and Scripting

Using awk command for .csv file

Discussion started by: sushmab82

3. UNIX for Dummies Questions & Answers

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

Discussion started by: ninjagod123

4. UNIX for Dummies Questions & Answers

xml to csv using sed and awk command

Discussion started by: sbk

5. Shell Programming and Scripting

UNIX command output in csv format

Discussion started by: anita81

6. Shell Programming and Scripting

Manipulate a CSV File

Discussion started by: tara123

7. Shell Programming and Scripting

Manipulate the text file in UNIX

Discussion started by: siva.pitchai

8. Shell Programming and Scripting

awk command to manipulate csv file in UNIX

Discussion started by: Prit Siv

9. UNIX for Beginners Questions & Answers

awk command to retrieve record 23 and 89 from UNIX file

Discussion started by: rakeshp

10. Homework & Coursework Questions

awk command to retrieve record 23 and 89 from UNIX file

Discussion started by: rakeshp

LEARN ABOUT MOJAVE

iofileb.d