Sponsored Content
Top Forums UNIX for Dummies Questions & Answers generate CSV file using AWK script Post 302204314 by sysgate on Wednesday 11th of June 2008 09:05:12 AM
Old 06-11-2008
Code:
awk '{print $1","$2","$3","$4","$5}' < /tmp/file.txt > /tmp/file.csv

If the report has fixed column number of 5, than this can work, just replace the paths.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Generate csv file

I have a file which has some thousand records in the following format File: input.txt -> <option value="14333">VISWANADH VELAMURI</option> <option value="17020">VISWANADHA RAMA KRISHNA</option> I want to generate a csv file from the above file as follows File: output.txt -> ... (4 Replies)
Discussion started by: rahulrathod
4 Replies

2. Shell Programming and Scripting

need help in Parsing a CSV file and generate a new output file

Hi Scripting Gurus, I am trying to parse a csv file and generate a new output file. The input file will be a variable length in turns of rows and columns. output file will have 8 columns. we have three columns from the header for each set. just to give little bit more clarification each row... (15 Replies)
Discussion started by: vkr
15 Replies

3. Shell Programming and Scripting

Need to generate .csv file

I have a csv file with the following data Please find the attachment - zip ... (6 Replies)
Discussion started by: vaas
6 Replies

4. Shell Programming and Scripting

to read a CSV file and generate SQL output

Friends, This is what I need: I will pass a CSV file as an input, and I want my shell to be reading that CSV file, and based on the parameters it should generate SQLs and write those SQL in a different file in the same location. I'm new to Shell scripting. I'm currently working on a... (1 Reply)
Discussion started by: Ram.Math
1 Replies

5. Shell Programming and Scripting

Read a CSV file and generate SQL output

Friends, This is what I need: I will pass a CSV file as an input, and I want my shell to be reading that CSV file, and based on the parameters it should generate SQLs and write those SQL in a different file in the same location. I'm new to Shell scripting. I'm currently working on a... (25 Replies)
Discussion started by: Ram.Math
25 Replies

6. Shell Programming and Scripting

Script to generate csv file

Hello; I need to generate a csv file that contains a list of all the files in a particular server (from the root directory ie: \) that have a permission stamp of 777. I would like to create the csv so that it contains the following: server name, file name, full path name where file exists,... (17 Replies)
Discussion started by: gvolpini
17 Replies

7. Shell Programming and Scripting

BASH script to parse XML and generate CSV

Hi All, Hope all you are doing good! Need your help. I have an XML file which needs to be converted CSV file. I am not an expert of awk/sed so your help is highly appreciated!! XML file looks like this: <l:event dateTime="2013-03-13 07:15:54.713" layerName="OSB" processName="ABC"... (2 Replies)
Discussion started by: bhaskar_m
2 Replies

8. Shell Programming and Scripting

Script to generate csv file

Dears, I am new in shell world and I need your help in this, I have to create a report based on the output file generated by another program. I want to write a shell script for this. The output file generated every 15 minutes but i can’t open it until the end of day so the script will get the... (3 Replies)
Discussion started by: abdul2020
3 Replies

9. Shell Programming and Scripting

Script to generate .csv file

Dears,I need your help in this, I have to create a report based on the output file generated by another program. I want to write a shell script for this. The output file generated every 15 minutes but i can’t open it until the end of day so the script will get the file as an input the file will be... (8 Replies)
Discussion started by: abdul2020
8 Replies

10. Shell Programming and Scripting

Generate .csv/ xls file report

There can be thousand of .ksh in a specific directory where sql files are called from ksh. Requirement is to loop through all the files content and generate a report like below: Jobname Type type sqlname gemd1970 sql daily tran01 gemw1971 sql weekly ... (6 Replies)
Discussion started by: vedanta
6 Replies
Devel::Cover::Report::Html_minimal(3pm) 		User Contributed Perl Documentation		   Devel::Cover::Report::Html_minimal(3pm)

NAME
Devel::Cover::Report::Html_minimal - Backend for HTML reporting of coverage statistics VERSION
version 0.89 SYNOPSIS
cover -report html_minimal DESCRIPTION
This module provides a HTML reporting mechanism for coverage data. It is designed to be called from the "cover" program. Based on an original by Paul Johnson, the output was greatly improved by Michael Carman (mjcarman@mchsi.com). OPTIONS
Options are specified by adding the appropriate flags to the "cover" program. This report format supports the following: outputfile Specifies the filename of the main output file. The default is coverage.html. Specify index.html if you just want to publish the whole directory. pod Includes POD (and blank lines) in the file report. This is on by default. It may be turned off with -nopod. data Includes text after the "__DATA__" or "__END__" tokens in the file report. By default, this text is trimmed. Note: If your POD is after an "__END__", you have to specify 'data' to include it, not 'pod'. The 'pod' option only applies to POD before the "__END__". unified Generates a "unified" report for each file. The detailed data that normally appears in the auxiliary reports (branch, condition, etc.) are placed in the file report, and the auxiliary reports are not generated. summarytitle Specify the title of the summary. The default is "Coverage Summary". SEE ALSO
Devel::Cover LICENCE
Copyright 2001-2012, Paul Johnson (paul@pjcj.net) This software is free. It is licensed under the same terms as Perl itself. The latest version of this software should be available from my homepage: http://www.pjcj.net perl v5.14.2 2012-06-16 Devel::Cover::Report::Html_minimal(3pm)
All times are GMT -4. The time now is 01:32 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy