01-23-2007
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 ->
14333,VISWANADH VELAMURI
17020,VISWANADHA RAMA KRISHNA
The HTML option tags are to be removed alongwith the unwanted tabs and the empty lines in between. I have tried cut, awk, but I am not getting the correct combination. Can you please help me out, as I want to upload this data into a database table.
Thanks.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi guys
I have a text report that consists of text in some parts and data in some parts.
e.g
Report for changes in cashflows
No changes were found
Report for changes in Bills
deal_num deal_date trader maturity log_creator
DF_234 20-5-2008 tman 20-5-2009 tman... (2 Replies)
Discussion started by: magikminox
2 Replies
2. Shell Programming and Scripting
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
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
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
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
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
Hi All,
I need help for doing the following.
I have a input file like:
aaaaaaaaaabbbbbbbbbbbbbbbbbbbb
cccbbbbbaaaaaadddddaaaabbbbbbb
now I am trying to generate a output csv file where i will have for e.g.
0-3 chars of each line as the first column in the csv, 4-10 chars of the line as... (3 Replies)
Discussion started by: babom
3 Replies
8. Shell Programming and Scripting
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
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
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
LEARN ABOUT SUSE
pdbtxt2html
pdbtxt2html(1) General Commands Manual pdbtxt2html(1)
NAME
pdbtxt2html - Doc Text to HTML converter for Palm Pilots
SYNOPSIS
pdbtxt2html [ -t ] file.txt [ file.html ]
pdbtxt2html -v
DESCRIPTION
pdbtxt2html converts text converted from a Doc(4) file via txt2pdbdoc(1) to HTML. If no HTML filename is given, the generated HTML is sent
to standard output.
Document Title
The first line of the file is used for the HTML document title.
Bookmarks
The last line of the file is examined and, if it contains a string enclosed between < and >, that is taken to be the bookmark marker. The
entire file is then scanned looking for lines beginning with it (ignoring leading whitespace). These lines are converted to HTML headings.
The number of whitespace characters after the first bookmark marker is used for heading level 1. The level of subsequent headings is set
to the number of whitespace characters between the bookmark marker and the bookmark text minus the number for the first bookmark plus one.
Embedded URLs
Valid URLs (according to RFC 1630) embedded in the text are turned into hyperlinks. The ftp, gopher, http, https, mailto, news, telnet,
and wais URLs are recognized.
OPTIONS
-t Compile a table of contents and insert it between the first heading and the body.
-v Print the version number to standard output and exit.
EXAMPLE
To convert a Doc file to HTML:
txt2pdbdoc alice.pdb alice.txt
pdbtxt2html alice.txt alice.html
SEE ALSO
html2pdbtxt(1), txt2pdbdoc(1), doc(4), pdb(4)
Tim Berners Lee. Universal Resource Identifiers in WWW, Network Working Group of the Internet Engineering Task Force, June 1994.
http://info.internet.isi.edu/in-notes/rfc/files/rfc1630.txt
AUTHOR
Paul J. Lucas <pauljlucas@mac.com>
txt2pdbdoc January 21, 2005 pdbtxt2html(1)