Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: format csv file using shell script
Top Forums UNIX for Advanced & Expert Users format csv file using shell script Post 302123791 by raosurya on Wednesday 27th of June 2007 08:30:44 AM
Old 06-27-2007
No. absolutely NOT. some body gave me answer for this question which is not working. i posted reply in other post. but, NO body replied to me last week.thats why i asked the question again. I am sorry that. still i did n't get the answer yet. pl see code bellow. when i put this code the i am getting empty file.but, i must get the results.file should never be empty.

this is code replied to me:
Code:
awk 'BEGIN{
FS=","
print "<HTML><BODY><TABLE>"
}
{
printf "<TR>"
for(i=1;i<=NF;i++)
printf "<TD>%s</TD>", $i
print "</TR>"
}
END{
print "</TABLE></BODY></HTML>"
}
'Report.csv > Report11.xls

i understand every body's help. I am looking for answer.
i appreciate that.pl help me.
thx,N
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Shell script to format a .CSV data

Hi There I needed to write a Unix shell script which will pick up the data from a .CSV file and reformat it as per the requirement and write it to another .CSV file. Currently I am in the proess of Data Import to "Remedy System" (A one kind of incident mangement Application) and this... (8 Replies)
Discussion started by: Uday1982
8 Replies

2. UNIX for Dummies Questions & Answers

Unix script to convert .csv file to.xls format

I have a .csv file in Unix box i need a UNIX script to convert the.csv files to.xls format. Its very urgent please help me. (1 Reply)
Discussion started by: moon_friend
1 Replies

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

4. UNIX for Advanced & Expert Users

shell script to format .CSV data

Hi all, I have written a shell script to search a specified directory (e.g. /home/user) for a list of specific words (shown as ${TMPDIR}/wordlist below). The script works well enough, but I was wondering if there was a way to display the line number that the word is found on? Thanks! cat... (1 Reply)
Discussion started by: tmcmurtr
1 Replies

5. Shell Programming and Scripting

Is there any script which convert binary file to CSV format

Dear guys; I have a binary file and I need to convert its data to csv format ...appreciating your help. Best Regards (14 Replies)
Discussion started by: ahmad.diab
14 Replies

6. Programming

awk script to convert a text file into csv format

hi...... thanks for allowing me to start a discussion i am collecting usb usage details of all users and convert it into csv files so that i can export it into some database.. the input text file is as follows:- USB History Dump by nabiy (c)2008 (1) --- Kingston DataTraveler 130 USB... (2 Replies)
Discussion started by: certteam
2 Replies

7. Shell Programming and Scripting

Conversion of below Tabs Tex file into CSV format file : shell script needed

Request if some one could provide me shell script that converts the below "input file" to "CSV format file" given Name Domain Contact Phone Email Location ----------------------- ------------------------------------------------ ------- ----- ---------------------------------... (7 Replies)
Discussion started by: sreenath1037
7 Replies

8. Shell Programming and Scripting

Need perl or shell script to sort vertical lines to horizontal line in csv format

Need perl or shell script to sort vertical lines to horizontal line in csv format My file like below ------------------------- ================================================================================ PATH PINKY1000#I1-1-ZENTA1000-2#I7-1-ASON-SBR-UP-943113845 ... (4 Replies)
Discussion started by: sreedhargouda.h
4 Replies

9. Shell Programming and Scripting

Format CSV file from a shell script

I have a shell script which creates a CSV files. there are 3 fields, field1, field2 and comp. I will generates the values for field1 and field2 and Want to compare both. If field1>filed2 then comp should be success written in green in CSV file, else it should fail in red color. How can I change the... (5 Replies)
Discussion started by: sauravrout
5 Replies

10. Programming

Python or Shell script to Grep strings from input file and output in csv format

Hi Experts, I am writing a python script to grep string from file and display output in csv file as in attached screenshot https://drive.google.com/file/d/1gfUUdfmQma33tz65NskThYDhkZUGQO0H/view Input file(result_EPFT_config_device) Below is the python script i have prepared as of... (1 Reply)
Discussion started by: as7951
1 Replies

LEARN ABOUT DEBIAN

purity-ng

PURITY-NG(6)							   Games Manual 						      PURITY-NG(6)

NAME

       purity-ng - general purpose purity testing software

SYNOPSIS

       purity-ng [OPTION]...  list|FILE|TESTNAME

DESCRIPTION

       Purity  is  an  interactive purity test program with a simple, user interface and datafile format.  For each test, questions are printed to
       the your terminal, and you are prompted for an answer to the current question.  At a prompt, these are your choices:

	      y      Answer "yes" to the question.
	      n      Answer "no" to the question.
	      b      Backup  one  question, if you answered it incorrectly, or someone is watching you take the test, and you don't (or do) want to admit a different answer.
	      s      Print your current score on the test you are taking.
	      q      Quit the test, and print the current score.
	      ?      Print a help screen for the current prompt.

       At the end of the test, your score is printed out.  For most purity tests, lower scores denote more "experience" of the test material.

OPTIONS

       --version
	      print current version of purity-ng

       -h, --help
	      show the help message and exit

       -p     print the test without prompting for answers.

       -r     decrypt the test using the Rot 13 algorithm.

       To get a list of all purity tests available globally on your system, run purity-ng list.

AUTHORS

       purity was originally written by Eric Lechner in 1989.  purity-ng is a reimplementation of purity in Python for modern systems, written	by
       Simon Fondrie-Teitler and Luke Faraone.

       This manual page was written by Luke Faraone.

BUGS

       If you find bugs in the application, please report these to <https://bugs.launchpad.net/purity-ng> or to your distribution's distributor.

SEE ALSO

       purity(6)

       Running purity-ng format provides documentation about the datafile format.

       Additional documentation is available online at <http://packages.python.org/purity-ng>.

								  January 7, 2011						      PURITY-NG(6)
All times are GMT -4. The time now is 05:20 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy