Convert comma text file to Column in html format


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Convert comma text file to Column in html format
# 1  
Old 03-30-2009
Convert comma text file to Column in html format

I am trying to generate a report with below file :

File1 :

EQADM,edrtere9-phys,8122caef0,gpatmon,/bin/ksh,nuten Erick
EQADM,edrtere11-phys,8227caef0,gpatmon,/bin/ksh,nuten Erick
EQADM,edrtere3-phys,822caef0,gpatmon,/bin/ksh,nuten Erick

can you help me convert it to html and add columns in places where there is comma ?

Thanks
# 2  
Old 03-30-2009
This could be achieved with a one liner awk script ... Using your example of File1 ...

Code:
% awk -F, 'BEGIN {print "<table>"} ; {  print "<tr><td>" $1 "</td><td>" $2 "</td><td>" $3 "</td><td>" $4 "</td><td>" $5 "</td><td>" $6 "</td></tr>"} ; END { print "</table>"}' File1

would result in the following output:


Code:
<table>
<tr><td>EQADM</td><td>edrtere9-phys</td><td>8122caef0</td><td>gpatmon</td><td>/bin/ksh</td><td>nuten Erick</td></tr>
<tr><td>EQADM</td><td>edrtere11-phys</td><td>8227caef0</td><td>gpatmon</td><td>/bin/ksh</td><td>nuten Erick</td></tr>
<tr><td>EQADM</td><td>edrtere3-phys</td><td>822caef0</td><td>gpatmon</td><td>/bin/ksh</td><td>nuten Erick </td></tr>
</table>

# 3  
Old 03-30-2009
Question Is this what you are trying to do?

Code:
> inv="EQADM,edrtere9-phys,8122caef0,gpatmon,/bin/ksh,nuten Erick"
> echo $inv | awk -F"," '{printf("%15s%15s%15s%15s%15s%15s\n",$1,$2,$3,$4,$5,$6)}'
          EQADM  edrtere9-phys      8122caef0        gpatmon       /bin/ksh    nuten Erick

or
Code:
> echo $inv | awk -F"," '{printf("%-15s%-15s%-15s%-15s%-15s%-15s\n",$1,$2,$3,$4,$5,$6)}'
EQADM          edrtere9-phys  8122caef0      gpatmon        /bin/ksh       nuten Erick

# 4  
Old 03-31-2009
Code:
echo "EQADM,edrtere9-phys,8122caef0,gpatmon,/bin/ksh,nuten Erick " | sed -e 's/^/<tr><td>/' -e 's/,/<\/td><td>/g' -e 's/$/<\/td><\/tr>/'

# 5  
Old 03-31-2009
Try...
Code:
awk 'BEGIN{
        FS=","
        print "<HTML><BODY><TABLE>"
     }
     {
        printf "<TR>"
        for(i=1;i<=NF;i++)
          printf "<TD>%s</TD>", $i
        print "</TR>"
     }
     END{
        print "</TABLE></BODY></HTML>"
     }
     ' file1.csv > file2.html

# 6  
Old 03-31-2009
Hi Ygor,
If the number of columns are more than 100, the above convert to html is not working.
Any solution if the columns are more than 100?

Thanks.
# 7  
Old 03-31-2009
Use nawk

Use nawk instead of awk to support beyond 100 columns.

Srini
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Convert listner.log to csv format with comma seperated

Hi All, I am new to shell scripting i am trying to convert the listner.log to csv which can be inturn converted to excel for easy reading. i used this command awk '/SID=/ && /HOST=/ && /PORT=/ && /USER=/ { i=match($0,"SID="); i=i+RLENGTH; h0=substr($0,i); i=match(h0,")");... (6 Replies)
Discussion started by: skoshekay
6 Replies

2. Shell Programming and Scripting

Loop to convert text output in the HTML format

Hello Everyone, I have a sample file raw.txt as shown below : Drive Bays Bay Name : SD-2C Number of Standby Power Supplies : 4 Number of Drive Enclosures : 12 Summary Status of Contained Modules All... (6 Replies)
Discussion started by: rahul2662
6 Replies

3. Shell Programming and Scripting

Format text file to html

Hi Experts, Anybody out there figure out on how to achieve in shell scripts or tools. I have done googling to find solutions but no luck. I have thousands of .txt files to batch process, please see the below sample text content after -------- start here --------. What I want to achieve is to... (10 Replies)
Discussion started by: lxdorney
10 Replies

4. Shell Programming and Scripting

Convert text file to HTML tabular format.

Please provide script/commands to convert text file to HTML tabular format. No need of styles and colours, just output and a heading in table is required. Output file will be send via email and will be seen from outlook. (script required without using awk). output file content: (sar... (7 Replies)
Discussion started by: Veera_V
7 Replies

5. Shell Programming and Scripting

Convert the date format from mdy to ymd in column of file

The date format in the delimited file for one column '6/27/2011 12:00:00 AM' Is it possible o change it to '2011-06-27 12:00:00 AM' for all the records.. Thanks in advance..... (8 Replies)
Discussion started by: infernalhell
8 Replies

6. UNIX for Dummies Questions & Answers

How to convert a text file into tab delimited format?

I have a text file that made using text editor in Ubuntu. However the text file is not being recognized as space or tab delimited, the formatting seems to be messed up. How can I convert the text file into tab delimited format? (3 Replies)
Discussion started by: evelibertine
3 Replies

7. Shell Programming and Scripting

How to format file into comma separated text file?

Hi Guys, I have text file which is tab/space separated but I want it to re-format into a comma separated and trim the spaces in between. Can someone spare me a perl or sed script that can do the job? INPUT FILE: 500010245623 500 21-APR-11 05.58.21 PM ... (14 Replies)
Discussion started by: pinpe
14 Replies

8. Shell Programming and Scripting

Is it possible to convert text file to html table using perl

Hi, I have a text file say file1 having data like ABC c:/hm/new1 Dir DEF d:/ner/d sd ...... So i want to make a table from this text file, is it possible to do it using perl. Thanks in advance Sarbjit (1 Reply)
Discussion started by: sarbjit
1 Replies

9. UNIX for Advanced & Expert Users

Urgent! need help! how to convert this file into comma delimited format

Hi experts, I need urget help! I have the a text file with this format: Types of fruits Name of fruits 1,1 Farm_no,1 apple,1 pineapple,1 grapes,1 orange,1 banana,1 2,2--->this is the record seperator Farm_no,2 apple,1 pineapple,1 grapes,3 orange,2 banana,1 3,3--->this is the... (2 Replies)
Discussion started by: natalie23
2 Replies

10. Shell Programming and Scripting

how to convert this file into comma delimited format

Hi experts, I need urget help! I have the a text file with this format: Types of fruits Name of fruits 1,1 Farm_no,1 apple,1 pineapple,1 grapes,1 orange,1 banana,1 2,2--->this is the record seperator Farm_no,2 apple,1 pineapple,1 grapes,3 orange,2 banana,1 3,3--->this is the... (1 Reply)
Discussion started by: natalie23
1 Replies
Login or Register to Ask a Question