|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
html to csv conversion
Post 302520735 by Skrynesaver on Monday 9th of May 2011 05:26:39 AM
05-09-2011
Code:
#! /usr/bin/perl
use strict;
use warnings;
open (my $file, "<", $ARGV[0]);
my @lines=(<$file>);
my $lines = join ('' , @lines);
while ($lines =~ m{<tr>\s*<td[^>]*><br>\s*([^<]*)\s*</td>\s*<td[^>]*><br>\s*<A\s*HREF="([^"]*)">Click\shere\sto\sfollow</A>\s*</td>\s*<td[^>]*><br>\s*([^<]*)\s*</td>\s*</tr*>
}gx){
print "\"$1\",\"$2\",\"$3\"\n";
}
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi
Please can someone tell me how i can convert .xls file into .csv on both platforms, windows and unix.
many thanks,
neil (4 Replies)
Discussion started by: neil546
4 Replies
2. Shell Programming and Scripting
Hi Guy's can someone help me in converting the following
I have a flat text file which has several thousand lines which I need to convert to a csv it's got a consistent format but basically want every time it hit's txt to create a new line with the subsequent lines comma delimited for example
... (6 Replies)
Discussion started by: p1_ben
6 Replies
3. Shell Programming and Scripting
thanks for allowing me join your forum
i have an output of linux command "who"
which provides following details.....
CURRENT USER/ACCT INFO
17:31:36 up 4:49, 4 users, load average: 0.03, 0.04, 0.00
USER TTY FROM LOGIN@ IDLE JCPU PCPU WHAT
root :0 - 12:59 ?xdm? 4:54 0.02s /bin/sh /usr/bi... (1 Reply)
Discussion started by: ayyappancheta
1 Replies
4. Shell Programming and Scripting
INput file attached in thread : Column widths at 24,73,82,87,121 characters (sed 's/./,/24;s/./,/73;s/./,/81;s/./,/87;s/./,/121;s/ *, */,/g' fixedinputfile >output.csv
). The client wants instead of hard coding the column widths as they are not fixed .he has given the hint stating that ( ... (3 Replies)
Discussion started by: sreenath1037
3 Replies
5. Shell Programming and Scripting
Thank u every body ......just need a help so that a text file needs to be converted into CSV.............
my log file is as follows
Host scsi3: usb-storage
Vendor: Maxtor
Product: OneTouch III
Serial Number: 044303E5
Protocol: Transparent SCSI
Transport: Bulk
... (4 Replies)
Discussion started by: tangotango
4 Replies
6. Shell Programming and Scripting
I have a CSV file in the below format.
while generating CSV file from excel sheet , date in excel sheet(Format :Mon 8/28/2012) got converted into the below format with numbers 41148,41149 so on.
Could anyone please let me know how to the convert the numbers(41148,41149 so on.) to its actual... (2 Replies)
Discussion started by: giridhar276
2 Replies
7. Shell Programming and Scripting
hi i hav a file called focus. which is the output file. i want to convert this file to html file and mail it. help with code and explanatio. i am basic in unix (7 Replies)
Discussion started by: wasim999
7 Replies
8. Shell Programming and Scripting
Hi,
I have following text file. I want to convert it into the below HTML format. Kindly help.
Input Text File
Header 1
=======
Name:***
Age:***
Address:***
Work Phone:***
Email:***
Mobile:***
Country:***
City:***
Pincode:***
some text here **** (10 Replies)
Discussion started by: ctrld
10 Replies
9. UNIX for Dummies Questions & Answers
Hi
Please let me know the command to convert from .xlsx to .csv so that i will implement the same in the assignment of mine . (5 Replies)
Discussion started by: harry00514
5 Replies
10. UNIX for Beginners Questions & Answers
Hello,
I have a binary csv file that was created on 'Red Hat Enterprise Linux Server release 6.6'. Now we have transferred all files on Ubuntu 16.04.2 LTS/xenial
On opening the file in Ubuntu, there are special characters
... (8 Replies)
Discussion started by: nans
8 Replies
LEARN ABOUT CENTOS
processcsv.py
PROCESSCSV.PY(1) Virtualization Support PROCESSCSV.PY(1) NAME
processcsv.py - process virt-top CSV files SUMMARY
virt-top --csv data.csv processcsv.py < data.csv DESCRIPTION
virt-top is a top(1)-like utility for showing stats of virtualized domains. processcsv.py is a simple Python script that post-processes the output of "virt-top --csv". It is used like this: virt-top --csv data.csv processcsv.py < data.csv The second command will overwrite the following files in the current directory: "global.csv" This contains the global (host) statistics columns from the CSV file. "domainNN.csv" (multiple files) For each libvirt domain ID NN, a file is created containing the per-domain statistics from the CSV file. SEE ALSO
virt-top(1) AUTHORS
Richard W.M. Jones <rjones @ redhat . com> COPYRIGHT
(C) Copyright 2007-2012 Red Hat Inc., Richard W.M. Jones http://libvirt.org/ This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version. 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. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA. virt-top-1.0.8 2013-12-29 PROCESSCSV.PY(1)