09-24-2008
Vijay,
The following is the output.
$ sed 's/\",/|/g' sample.dat | sed 's/\"//g'
I|+2007,SANDA, 20, MARTIN PLACE|SANDA 20MARTIN
D|+2008,RANDA, 22, MARTIN PLACE|RANDA 22MARTIN
Not exactly the expected...
Thank you.
Ram
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have a comma delimited file that sometimes has addresses details in. The problem is that the address detail can be seen as:
"Sample House, Sample Road". When I run a script specifying the file is comma delimited I would like it to ignore comma's that are in between speech marks.
Is this... (2 Replies)
Discussion started by: dbrundrett
2 Replies
2. Shell Programming and Scripting
Hi,
Can anyone let me know on how to convert a Tab delimited file to Comma delimited file in Unix
Thanks!! (22 Replies)
Discussion started by: charan81
22 Replies
3. Shell Programming and Scripting
I need to delete a set of files in certain directories if there're older than a certain number of days. So I have a text file, with each line containing the directory & number of days.
The format is like this:
dirA,5
dirB,7
How do I write script to iteratively parse this text file & delete... (5 Replies)
Discussion started by: chengwei
5 Replies
4. UNIX for Dummies Questions & Answers
Hi All,
I have output of sql saved in comma separated file.
Now i need to read line by line this file
and assign word to a unix variable for further processing
Eg:
Test file
world, 1, 3, 4
earth,2,3,4,5
moon,1,2,3,4
Output should be
word1= world
word2=1
echo " first word... (7 Replies)
Discussion started by: gwrm
7 Replies
5. Shell Programming and Scripting
Hello,
I need to read a csv file and I am trying to replace a comma with a text DSEE?DSEE.
Example
Input
"Chapter","NewTrains, "oldTrains","Delayed",10,"London"
"Chapter","Newbuses,oldbuses","On Time",20,"London"
Output
"Chapter","NewTrainsDSEE?DSEE... (5 Replies)
Discussion started by: venkatvani
5 Replies
6. UNIX for Dummies Questions & Answers
I have a flat file whose contents are comma delimited and there are 84 columns in total, so everytime I try to view the contents, things get over lapped it becomes diffcult to read through the result set.
Is there a command / what would be the best way...if I want to view the results alligned... (4 Replies)
Discussion started by: priya33184
4 Replies
7. Shell Programming and Scripting
Question about how to change the first & last name in column one & two so that the names have a capital letter for just the first letter. Example:
asdf@asdf.com,asdf,asdfasdf,176.23.22.345,4/12/2012
changed to:
asdf@asdf.com,Asdf,Asdfasdf,176.23.22.345,4/12/2012
Thank you kindly,
Nick (2 Replies)
Discussion started by: nickytcom
2 Replies
8. Shell Programming and Scripting
Hi All,
I need a unix script to convert .csv files to .skv files (changing a comma delimited file to a semi colon delimited file). I am a unix newbie and so don't know where to start. The script will be scheduled using cron and needs to convert each .csv file in a particular folder to a .skv... (4 Replies)
Discussion started by: CarpKing
4 Replies
9. Shell Programming and Scripting
Hi,
I am wanting to create a script that will construct a SQL statement based on a a space delimited string that it read from a config file.
Example of the SQL will be
For example, it will read a string like "AAA BBB CCC" and assign to a variable named IN_STRING.
I then concatenate... (2 Replies)
Discussion started by: newbie_01
2 Replies
10. Shell Programming and Scripting
Hi Experts,
Please support
I have below data in file in comma seperated, but 4th column is containing comma in between numbers, bcz of which when i tried to parse the file the column 6th value(5049641141) is being removed from the file and value(222.82) in column 5 becoming value of column6.
... (3 Replies)
Discussion started by: as7951
3 Replies
LEARN ABOUT SUSE
html::parse
HTML::Parse(3) User Contributed Perl Documentation HTML::Parse(3)
NAME
HTML::Parse - Deprecated, a wrapper around HTML::TreeBuilder
SYNOPSIS
See the documentation for HTML::TreeBuilder
DESCRIPTION
Disclaimer: This module is provided only for backwards compatibility with earlier versions of this library. New code should not use this
module, and should really use the HTML::Parser and HTML::TreeBuilder modules directly, instead.
The "HTML::Parse" module provides functions to parse HTML documents. There are two functions exported by this module:
parse_html($html) or parse_html($html, $obj)
This function is really just a synonym for $obj->parse($html) and $obj is assumed to be a subclass of "HTML::Parser". Refer to
HTML::Parser for more documentation.
If $obj is not specified, the $obj will default to an internally created new "HTML::TreeBuilder" object configured with
strict_comment() turned on. That class implements a parser that builds (and is) a HTML syntax tree with HTML::Element objects as
nodes.
The return value from parse_html() is $obj.
parse_htmlfile($file, [$obj])
Same as parse_html(), but pulls the HTML to parse, from the named file.
Returns "undef" if the file could not be opened, or $obj otherwise.
When a "HTML::TreeBuilder" object is created, the following variables control how parsing takes place:
$HTML::Parse::IMPLICIT_TAGS
Setting this variable to true will instruct the parser to try to deduce implicit elements and implicit end tags. If this variable is
false you get a parse tree that just reflects the text as it stands. Might be useful for quick & dirty parsing. Default is true.
Implicit elements have the implicit() attribute set.
$HTML::Parse::IGNORE_UNKNOWN
This variable contols whether unknow tags should be represented as elements in the parse tree. Default is true.
$HTML::Parse::IGNORE_TEXT
Do not represent the text content of elements. This saves space if all you want is to examine the structure of the document. Default
is false.
$HTML::Parse::WARN
Call warn() with an apropriate message for syntax errors. Default is false.
REMEMBER!
HTML::TreeBuilder objects should be explicitly destroyed when you're finished with them. See HTML::TreeBuilder.
SEE ALSO
HTML::Parser, HTML::TreeBuilder, HTML::Element
COPYRIGHT
Copyright 1995-1998 Gisle Aas, 1999-2004 Sean M. Burke, 2005 Andy Lester, 2006 Pete Krawczyk.
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
This program is distributed in the hope that it will be useful, but without any warranty; without even the implied warranty of
merchantability or fitness for a particular purpose.
AUTHOR
Currently maintained by Pete Krawczyk "<petek@cpan.org>"
Original authors: Gisle Aas, Sean Burke and Andy Lester.
perl v5.12.1 2006-08-06 HTML::Parse(3)