|
|
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 SUNOS
shells
shells(4) File Formats shells(4) NAME
shells - shell database SYNOPSIS
/etc/shells DESCRIPTION
The shells file contains a list of the shells on the system. Applications use this file to determine whether a shell is valid. See getuser- shell(3C). For each shell a single line should be present, consisting of the shell's path, relative to root. A hash mark (#) indicates the beginning of a comment; subsequent characters up to the end of the line are not interpreted by the routines which search the file. Blank lines are also ignored. The following default shells are used by utilities: /bin/bash, /bin/csh, /bin/jsh, /bin/ksh, /bin/pfcsh, /bin/pfksh, /bin/pfsh, /bin/sh, /bin/tcsh, /bin/zsh, /sbin/jsh, /sbin/sh, /usr/bin/bash, /usr/bin/csh, /usr/bin/jsh, /usr/bin/ksh, /usr/bin/pfcsh, /usr/bin/pfksh, /usr/bin/pfsh, and /usr/bin/sh, /usr/bin/tcsh, /usr/bin/zsh. Note that /etc/shells overrides the default list. Invalid shells in /etc/shells may cause unexpected behavior (such as being unable to log in by way of ftp(1)). FILES
/etc/shells lists shells on system SEE ALSO
vipw(1B), ftpd(1M), sendmail(1M), getusershell(3C), aliases(4) SunOS 5.10 4 Jun 2001 shells(4)