Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: help!!!!!! in creating csv report
Top Forums Shell Programming and Scripting help!!!!!! in creating csv report Post 302141168 by summer_cherry on Thursday 18th of October 2007 03:01:09 AM
Old 10-18-2007
awk
Hi,
This one should be ok. The main idea is:
put all of the element in 7 different array, after finishing scan the whole file, out put them from the array.

code:

Code:
nawk 'BEGIN{flag=0;num=1}
/^contact/ 
{
	contact[num]=substr($0,length($1)+1,length($0)-length($1))
}
/^user_id/ 
{
	user[num]=substr($0,length($1)+1,length($0)-length($1))
}
/^display_name/ 
{
	display[num]=substr($0,length($1)+1,length($0)-length($1));
}
/^comments/
{
	flag=1
	next
}
flag {  tmp=tmp$0  }
/^description/ 
{
	description[num]=substr($0,length($1)+1,length($0)-length($1))
	comments[num]=tmp
	tmp=""
	flag=0
}
/^account_no/ 
{
	account[num]=substr($0,length($1)+1,length($0)-length($1))
}
/^email/ 
{
	email[num]=substr($0,length($1)+1,length($0)-length($1));num++
}
END{
for (i=1;i<=num-1;i++)
	print contact[i]","user[i]","display[i]","description[i]","account[i]","email[i]","comments[i]
}' filename

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

creating a csv file in awk

Hi All I am trying to create a csv file in the korn shell and the script segment is as follows: if then # NEED TO ADD INFO TO THE EMAIL FILE ABOUT THE DRIVE THAT'S FILLING UP echo "$drive $percent% $space "|\ awk '{printf("%d/t"|"%d/t"|"%d/t\n",... (6 Replies)
Discussion started by: Segwar
6 Replies

2. UNIX for Advanced & Expert Users

Creating multiple worksheets in CSV file

Hello, I've been tasked with sending 3 types of data (file size, row count, and file name) to a csv file every month for various vendors. I have been asked to put this in one csv or xls file with each vendor being a different tab (or worksheet). Until now, we have been finding and emailing... (4 Replies)
Discussion started by: tekster757
4 Replies

3. UNIX for Dummies Questions & Answers

Creating CSV Files

I have a requiremnt to create one CSV file with initial 5 lines as blank rows. From 5th row onwards the file is to be created from a list of varibales which gets evaluated. Say A,B,C,D,E are 5 varibales with some value associated with each of them and data type is string. So the 6th row should... (1 Reply)
Discussion started by: dr46014
1 Replies

4. UNIX for Dummies Questions & Answers

creating a CSV file for past 7 days

I have a requirement which will select the files with a specific naming convention which got created in past 7 days in a specific directory.Lets say the directory is /data/XYZ and the file names follow the below nomenclature like Daily_File*.txt I just need to create one CSV file which will... (12 Replies)
Discussion started by: dr46014
12 Replies

5. Shell Programming and Scripting

Creating CSV files

hi, Need a lil help experts. i have a sh file and its calling one SQL file. i need the dataset returned by that SQL file in a CSV format. Can you plz help me out at the earliest. waiting eagerly .. :confused: Thanks.. (10 Replies)
Discussion started by: onlyniladri
10 Replies

6. UNIX for Dummies Questions & Answers

Creating a report from csv file.

Hi Gurus, I need your help in transforming the CSV file into some what a report format. My source file looks like below Date,ProdID,TimeID,LevelID 2010-08-31,200,M,1 2010-08-31,201,Q,2 2010-08-31,202,Y,1 2010-08-31,203,M,5 Output required is ... (9 Replies)
Discussion started by: naveen.kuppili
9 Replies

7. Shell Programming and Scripting

creating a csv file from this 1 liner?

I'm trying to create a csv file by running awk and sed on a number of xml files in a directory; I'm using this below: hostname; grep "BuildDate" /dir/ABCD/configuration/*/*.xml | awk -F"/" '{ print $5 }' > /tmp/tempfile.txt; grep "BuildDate" /dir/ABCD/configuration/*/*.xml | awk -F\" '{ print $2... (2 Replies)
Discussion started by: rich@ardz
2 Replies

8. UNIX for Dummies Questions & Answers

Problem in creating CSV file

Hi guys, I am not experienced with Unix, so please dont mind if the question seem to be irrelevant. I have written a simple script, that connects DB & fetches few records from a table. I wanted to get those details as file in .CSV format via mail. -I stored the query o/p in a file. -I... (6 Replies)
Discussion started by: sumitburnwal88
6 Replies

9. UNIX for Dummies Questions & Answers

Creating a csv file with header in UNIX

I have a flat file that contains dynamic list of variables like a=1 b=2 c=3 . .. z=26 I need to convert the above into a csv file having the format below: a,b,c,..,z 1,2,3,..,26 Please note, I do not want a comma separating the last variable. I tried to refer the post... (4 Replies)
Discussion started by: vkumbhakarna
4 Replies

10. Shell Programming and Scripting

Need help for creating the report

Hi, I have a file that contains below information: provider APESD APESD Annual Turn $67000 Provider XXXX Annual Turn $92000 Provider FERHG FERHG Annual Turn $56700 Provider ABXX Annual Turn $99000 These are just sample rows out of some 5000. I want to create a tabular report as... (5 Replies)
Discussion started by: juzz4fun
5 Replies

LEARN ABOUT DEBIAN

powertop

POWERTOP(8)							  powertop manual						       POWERTOP(8)

NAME

       powertop - a power consumption and power management diagnosis tool.

SYNOPSIS

       powertop [ options ]

DESCRIPTION

       powertop  is  a	program that helps to diagnose various issues with power consumption and power management. It also has an interactive mode
       allowing one to experiment with various power management settings. When invoking powertop without arguments powertop starts in  interactive
       mode.

OPTIONS

       --csv[=FILENAME]
	      generate	a  CSV report. If a filename is not specified then the default name "powertop.csv" is used. The CSV report can be used for
	      reporting and data analysis.

       --calibrate
	      runs powertop in calibration mode. When running on battery, powertop can track power consumption as well as  system  activity.  When
	      there  are  enough  measurements,  powertop  can	start to report power estimates. One can get more accurate estimates by using this
	      option to enable a calibration cycle. This will cycle through various display levesl and USB device activities and workloads.

       --debug
	       run in "debug" mode.

       --extech=devnode
	      use the Extech Power Analyzer for measurements. This allows one to specify the serial device node of the serial to USB adaptor  con-
	      necting to the Extech Power Analyzer, for example /dev/ttyUSB0.

       --help
	       show the help message.

       --html[=FILENAME]
	      generate	an  HTML report. If a filename is not specified then the default name "powertop.html" is used. The HTML report can be sent
	      to others to help diagnose power issues.

       --iteration[=iterations]
	      number of times to run each test.

       --time[=seconds]
	      generate a report for a specified number of seconds.

       --version
	      print version information and exit.

BUGS

       Send bug reports to <powertop@lists.01.org>

SEE ALSO

       The program is more fully described at https://01.org/powertop

AUTHOR

       powertop was written by	Arjan  van  de	Ven  <arjan@linux.intel.com>,  and  is	currently  maintained  by  Chris  E  Ferron  <chris.e.fer-
       ron@linux.intel.com>.

Linux								   June 1, 2012 						       POWERTOP(8)
All times are GMT -4. The time now is 01:54 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy