html to csv conversion


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting html to csv conversion
# 1  
Old 05-09-2011
html to csv conversion

thanks for allowing me to join your forum

i have a html file with three columns ------------Last visit date , URL and link,,,,,,,, how can i convert the same into csv so that i can output into database... the mechine is linux...i made a little googling and got idea that there is ways for conversion using bash and perl./....but dont know how to.........

any ideas please
thanks in advaance
ayyappan

i m here by attaching my html file

Last edited by certteam; 05-09-2011 at 04:10 AM.. Reason: attachment is wrong
# 2  
Old 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";
}

the code above will do it, though if this is an assignment there will be a few questions on that regex Smilie
# 3  
Old 05-10-2011
html to csv conversion

thanks for the reply

but when i tried to run the script , it is showing error

Code:
line 4: use: command not found
 line 5: use: command not found
 line 7: syntax error near unexpected token `my'
line 7: `open (my $file, "<", $ARGV[0]);

any help please

---------- Post updated at 05:55 AM ---------- Previous update was at 04:21 AM ----------

sorry it was my mistake.......... i forgot to save the file as .pl.........

now its wking fine

thanks a lot

Last edited by pludi; 05-10-2011 at 06:39 AM..
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Conversion of Binary csv file

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

2. UNIX for Dummies Questions & Answers

.xlxs to .csv conversion

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

3. Shell Programming and Scripting

HTML Conversion of text file

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

4. Shell Programming and Scripting

Conversion of a text file to html

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

5. Shell Programming and Scripting

perl : number to date conversion in CSV file

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

6. Shell Programming and Scripting

text to csv conversion

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

7. Shell Programming and Scripting

conversion of spaces into CSV format file

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

8. Shell Programming and Scripting

Shell script for CSV conversion

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

9. Shell Programming and Scripting

Flat file to csv conversion

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

10. Shell Programming and Scripting

.xls to .csv conversion

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
Login or Register to Ask a Question