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

Previous Thread | Next Thread

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