Visit Our UNIX and Linux User Community


Search in a file and convert in a table


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Search in a file and convert in a table
# 1  
Old 08-14-2019
Search in a file and convert in a table

Hi to all,

I have a file like that in attach, I need to create a table or csv with only this field:
Code:
"Barcode","Device Name", "ACSL".

I tried with grep with -B options but the number of lines are different for any block is different, there is a method with sed or awk to extract it.

Thanks a lot

Best Regards

Last edited by rbatte1; 08-14-2019 at 06:54 AM..
# 2  
Old 08-14-2019
Can you post expected output?
# 3  
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

Previous Thread | Next Thread
Test Your Knowledge in Computers #81
Difficulty: Easy
AT&T UNIX, SCO UnixWare, Sun Microsystems Solaris, HP-UX, IBM AIX, SGI IRIX and many big corporations who wanted license and profit from their own versions of Unix are not as common today as they were in the 1980s.
True or False?

8 More Discussions You Might Find Interesting

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

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

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

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

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

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

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

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

Featured Tech Videos