Sponsored Content
Top Forums Shell Programming and Scripting Sar -u generates multiple column headers in csv file Post 302791949 by ahamed101 on Tuesday 9th of April 2013 01:16:55 PM
Old 04-09-2013
Try this... not tested...
Code:
#!/bin/bash

hdr=1
while true; do
  sar -u 15 1 |  awk '/user/{if(hdr){print $1,$2,$4,$6,$7};next} /^[0-9]/{print $1,$2,$4,$6,$7}' OFS=, hdr=$hdr >> /sar_cpu_EBS_`date +%m%d%y`.csv
  sleep 5
  hdr=0
done

--ahamed

Last edited by ahamed101; 04-09-2013 at 02:42 PM..
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Option in sql script to include column headers when spooling file to .csv format

Can anyone help me how to include COLUMN HEADER when spooling file to .CSV format through SQL statement. Thanks, Akbar (4 Replies)
Discussion started by: s1a2m3
4 Replies

2. Shell Programming and Scripting

Merging of files with different headers to make combined headers file

Hi , I have a typical situation. I have 4 files and with different headers (number of headers is varible ). I need to make such a merged file which will have headers combined from all files (comman coluns should appear once only). For example - File 1 H1|H2|H3|H4 11|12|13|14 21|22|23|23... (1 Reply)
Discussion started by: marut_ashu
1 Replies

3. Shell Programming and Scripting

Combine Multiple text or csv files column-wise

Hi All I am trying to combine columns from multiple text files into a single file using paste command but the record length being unequal in the different files the data is running over to the closest empty cell on the left. Please see below. What can i do to resolve this ? File 1 File... (15 Replies)
Discussion started by: venky_ibm
15 Replies

4. Shell Programming and Scripting

Multiple headers in a file

Hi , I have a .txt file in which I have multiple headers, the header record starts with $ symbol...like the first column name is $Account. I have to keep the header in the first line and delete all the remaining headers which are in the file. I tried using sort adc.txt | uniq -u , but my... (7 Replies)
Discussion started by: gaur.deepti
7 Replies

5. UNIX for Dummies Questions & Answers

Using sed command to remove multiple instances of repeating headers in one file?

Hi, I have catenated multiple output files (from a monte carlo run) into one big output file. Each individual file has it's own two line header. So when I catenate, there are multiple two line headers (of the same wording) within the big file. How do I use the sed command to search for the... (1 Reply)
Discussion started by: rebazon
1 Replies

6. Shell Programming and Scripting

Insterting column in csv from multiple files

Hello, I have a spec file that contains a lot of strings that looks like this: PC DELL OptiPlex 3010MT i3 3220/2GB/500GB/DVD-RW/FREE DOS / 5Y NBD Intel i3 3220 (Dual Core, 3.30GHz, 3MB, w/ HD2500 Graphics), 2GB (1x2GB) DDR3 PC3-1600MHz, 500GB HDD SATA III 7200rpm, DVD+/-RW (16x),... (9 Replies)
Discussion started by: g9100
9 Replies

7. Shell Programming and Scripting

Checking data in csv file after headers

I had a requirement to check if data exists after headers (typically row 2 & so on) in csv file. please help how we can check through shellscript in linux. Thank you !! (1 Reply)
Discussion started by: chandu123
1 Replies

8. Shell Programming and Scripting

Compare 2 files of csv file and match column data and create a new csv file of them

Hi, I am newbie in shell script. I need your help to solve my problem. Firstly, I have 2 files of csv and i want to compare of the contents then the output will be written in a new csv file. File1: SourceFile,DateTimeOriginal /home/intannf/foto/IMG_0713.JPG,2015:02:17 11:14:07... (8 Replies)
Discussion started by: refrain
8 Replies

9. Shell Programming and Scripting

Row bind multiple csv files having different column headers

All, I guess by this time someone asked this kind of question, but sorry I am unable to find after a deep search. Here is my request I have many files out of which 2 sample files provided below. File-1 (with A,B as column headers) A,B 1,2 File-2 (with C, D as column headers) C,D 4,5 I... (7 Replies)
Discussion started by: ks_reddy
7 Replies

10. UNIX for Beginners Questions & Answers

How do I extract specific column in multiple csv files?

file1: Name,Threshold,Curr Samples,Curr Error%,Curr ART GETHome,100,21601,0.00%,47 GETregistry,100,21592,0.00%,13 GEThomeLayout,100,30466,0.00%,17 file2: Name,Threshold,Curr Samples,Curr Error%,Curr ART GETHome,100,21601,0.00%,33 GETregistry,100,21592,0.00%,22... (6 Replies)
Discussion started by: Raghuram717
6 Replies
FIELDCOMB(1)						      General Commands Manual						      FIELDCOMB(1)

NAME
fieldcomb - combine two or more field frames for video animation SYNOPSIS
fieldcomb [ -e|-o ][ -r ] [ -f combined.hdr ] field0.hdr field1.hdr .. DESCRIPTION
Fieldcomb combines two or more field frames into half as many final video frames for field-based animations. Normally, the even scanlines in the output are given over to the first, third, fifth, etc. pictures given on the input, and the odd scanlines are given over to the sec- ond, fourth, sixth, etc. pictures on the input. This behavior corresponds to the -e option, which is set by default. To reverse this ordering, the -o option must be specified. Normally, fieldcomb will name output frames by dividing the numbers on the input field file names by 2, inserting a 'C' right before the number, adding leading zeroes to make it always four digits. For example, the command: fieldcomb anim12.hdr anim13.hdr anim14.hdr anim15.hdr will produce two output pictures: animC0006.hdr & animC0007.hdr If an odd number of input files is given on the command line, the last file is held over and used as the first file in the next invocation of fieldcomb in the same directory. In this way, the program works well with the "TRANSFER" facility of ranimate(1), which does not guar- antee an even number of frames will be passed every time. If only two input files are given, the -f option may be used to specify a different output name of the user's choosing. If the -r option is specified, then the input files will be removed once they have been combined. AUTHOR
Greg Ward ACKNOWLEDGEMENT
Work on this program was sponsored by Iebele Abel. SEE ALSO
getinfo(1), pcomb(1), pfilt(1), phisto(1), ran2tiff(1), ranimate(1), rpict(1) RADIANCE
9/6/2005 FIELDCOMB(1)
All times are GMT -4. The time now is 06:20 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy