Sponsored Content
Top Forums Shell Programming and Scripting Search in a file and convert in a table Post 303037826 by rdrtx1 on Wednesday 14th of August 2019 10:02:33 AM
Old 08-14-2019
Code:
awk -v columns="Barcode,Device Name,ACSL" '
BEGIN {
  c=split(columns, headers, ",");
  for (i=1; i<=c; i++) labels[headers[i]]=headers[i];
}
{
 for (i=1; i<=NF; i++) {
    key=$i;
    sub("=.*", "", key);
    if (key in labels) {
       key=$i;
       sub("=.*", "", key);
       value=$i;
       sub(key "=", "", value);
       data[NR, key]=value;
    }
 }
}
END {
 print columns;
 for (i=1; i<=NR; i++) {
    line="";
    for (j=1; j<=c; j++) {
       line=line data[i, headers[j]] ",";
    }
    sub(",$", "", line);
    if (line ~ /..*,..*,..*/) print line;
 }
}
' FS="\n" RS="\n\n" file2.txt > file2.csv

# note: ex. excludes empty field lines
 

8 More Discussions You Might Find Interesting

1. 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

2. Shell Programming and Scripting

Convert file in csv or table

Hi there, i have a file like that in attachment (PLEVA3_280711_SAP.txt), i would extract some basic information from it and report in a new file or table like this: i try to use bash and i extract the single object in this way (see attach scriptino.sh), but i receive a strange... (5 Replies)
Discussion started by: alen192
5 Replies

3. Shell Programming and Scripting

Convert shell script output txt file to html table

Hi, I have script which generates the output as below: Jobname Date Time Status abc 12/9/11 17:00 Completed xyz 13/9/11 21:00 Running I have the output as a text file. I need to convert it into a HTML Table and sent it thru email ... (6 Replies)
Discussion started by: a12ka4
6 Replies

4. Shell Programming and Scripting

convert to uppercase in specific table

Hi All, I'm a newbie here, i'm just wondering is it possible to convert into uppercase the records in specific field? ex. table name = mytable field1 field2 field3 abd erfdF fdsfdsfsd how can i convert into uppercase the field2 using sybase? Please advise, ... (2 Replies)
Discussion started by: nikki1200
2 Replies

5. Shell Programming and Scripting

convert the output in table format

Hi All, I have a output like below values val1=test.com val2=10.26.208.11 val3=en1 val4=test-priv1.com val5=192.168.3.4 val6=en2 val7=test-priv2.com val8=192.168.4.4 val9=en3 val10=test-vip.com val11=10.26.208.9 val12=$val3 I want to convet this output values into below... (1 Reply)
Discussion started by: kamauv234
1 Replies

6. Shell Programming and Scripting

awk to convert table-by-row to matrix table

Hello, I need some help to reformat this table-by-row to matrix? infile: site1 A:o,p,q,r,s,t site1 C:y,u site1 T:v,w site1 -:x,z site2 A:p,r,t,v,w,z site2 C:u,y site2 G:q,s site2 -:o,x site3 A:o,q,s,t,u,z site3 C:y site3 T:v,w,x site3 -:p,routfile: SITE o p q r s t v u w x y... (7 Replies)
Discussion started by: yifangt
7 Replies

7. UNIX for Dummies Questions & Answers

Convert Txt file to HTML table and email

Hi all I need help converting a text file into a html table in bash and I need to email this table. The text file looks like the below. Two columns with multiple rows. Top row being header. Application Name Application Status Application 1 Open Application 2 ... (2 Replies)
Discussion started by: hitmanjd
2 Replies

8. Shell Programming and Scripting

Convert shell script output txt file to html table

My concnern related to the post -Convert shell script output txt file to html table, in this how to print the heading as color. awk 'BEGIN{print "<table>"} {print "<tr>";for(i=1;i<=NF;i++)print "<td>" $i"</td>";print "</tr>"} END{print "</table>"}' <filename> (8 Replies)
Discussion started by: sarajobmai
8 Replies
Barcode::NW7(3pm)					User Contributed Perl Documentation					 Barcode::NW7(3pm)

NAME
GD::Barcode::NW7 - Create NW7 barcode image with GD SYNOPSIS
ex. CGI use GD::Barcode::NW7; binmode(STDOUT); print "Content-Type: image/png "; print GD::Barcode::NW7->new('123456789012')->plot->png; with Error Check my $oGdBar = GD::Barcode::NW7->new('123456789E'); die $GD::Barcode::NW7::errStr unless($oGdBar); #Invalid Characters DESCRIPTION
GD::Barcode::NW7 is a subclass of GD::Barcode and allows you to create NW7 barcode image with GD. This module based on "Generate Barcode Ver 1.02 By Shisei Hanai 97/08/22". new $oGdBar = GD::Barcode::NW7->new($sTxt); Constructor. Creates a GD::Barcode::NW7 object for $sTxt. $sTxt has variable length string with (0-9, - $ / . + ABCD). plot() $oGd = $oGdBar->plot([Height => $iHeight, NoText => 0 | 1]); creates GD object with barcode image for the $sTxt specified at new method. $iHeight is height of the image. If NoText is 1, the image has no text image of $sTxt. ex. my $oGdB = GD::Barcode::NW7->new('123456789012'); my $oGD = $oGdB->plot(NoText=>1, Height => 20); # $sGD is a GD image with Height=>20 pixels, with no text. barcode() $sPtn = $oGdBar->barcode(); returns a barcode pattern in string with '1' and '0'. '1' means black, '0' means white. ex. my $oGdB = GD::Barcode::NW7->new('123456789012'); my $sPtn = $oGdB->barcode(); # $sPtn = ''; $errStr $GD::Barcode::NW7::errStr has error message. $text $oGdBar->{$text} has barcode text based on $sTxt specified in new method. AUTHOR
Kawai Takanori GCD00051@nifty.ne.jp COPYRIGHT
The GD::Barocde::NW7 module is Copyright (c) 2000 Kawai Takanori. Japan. All rights reserved. You may distribute under the terms of either the GNU General Public License or the Artistic License, as specified in the Perl README file. SEE ALSO
GD::Barcode perl v5.12.3 2003-05-29 Barcode::NW7(3pm)
All times are GMT -4. The time now is 09:13 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy