Need to create a report using paste or with awk


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Need to create a report using paste or with awk
# 1  
Old 08-07-2019
Need to create a report using paste or with awk

Input file will be

Code:
Name: serve1
has disk :Yes
dev (8):
Name: serve2
has disk :No
dev (8):
Name: serve3
has disk :No
Name: serve4
has disk :Yes
dev (8):

Need output like that. I was using pate -d, - - - . But that need all the line in same format in this some server it has only two line without device. My goal is i need to filter all the server which has no device

Code:
Name: serve1,has disk :Yes,dev (8):
Name: serve2,has disk :No,dev (8):
Name: serve3,has disk :No
Name: serve4,has disk :Yes,dev (8):


Last edited by ranjancom2000; 08-07-2019 at 08:21 AM..
# 2  
Old 08-07-2019
Code:
$ awk -v RS="\nName:" -v OFS="," -v FS="\n" -v ORS="\nName:" ' { print $1 OFS $2 ($3 ? OFS $3 : "") } ' file
Name: serve1,has disk :Yes,dev (8):
Name: serve2,has disk :No,dev (8):
Name: serve3,has disk :No
Name: serve4,has disk :Yes,dev (8):

These 2 Users Gave Thanks to anbu23 For This Post:
# 3  
Old 08-07-2019
thanks great it was working fine
# 4  
Old 08-07-2019
Code:
sed -n '1{h;b}; /Name/! {H;$!b}; x;s/\n/,/gp' file

This User Gave Thanks to nezabudka For This Post:
# 5  
Old 08-07-2019
Code:
awk '{printf ((/Name/ && c++) ? RS : (d++? ",":_)) $0} END {print RS}' ORS=  infile

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Create and paste two file into one

Hello i want to create this list: 2a05:b80:0:235::9f/1159 2a05:b80:0:235::a0/1160 2a05:b80:0:235::a1/1161 2a05:b80:0:235::a2/1162 2a05:b80:0:235::a3/1163 so write this shell as well: #Global VAR STR=159 END=200 #INI NET IPV6 PART SUM1=`expr $END - $STR` for ((i=STR;i<=END;++i)); do... (6 Replies)
Discussion started by: nimafire
6 Replies

2. Shell Programming and Scripting

awk to create variables to pass into a bash loop to create a download link

I have created one file that contains all the necessary info in it to create a download link. In each of the lines /results/analysis/output/Home/Auto_user_S5-00580-6-Medexome_67_032/plugin_out/FileExporter_out.67... (8 Replies)
Discussion started by: cmccabe
8 Replies

3. Shell Programming and Scripting

Use sed/awk to do like copy and paste

I have rrd file which is have the gaps and I want to fill it out with some value , I've got 10 NaN record and I try to populate data from 10 records be for NaN to change instead of NaN :( <!-- 2016-05-19 14:10:00 CST / 1463638200 -->... (11 Replies)
Discussion started by: boobytrap
11 Replies

4. Shell Programming and Scripting

copy/paste with awk

Hi everybody, I have two XML files. I am working on a script that could copy and paste the contents of the first xml file to the desired location in the second xml file. Here is my first XML file. This is the second XML file. Finaly, I wnat to obtain something like that : ... (2 Replies)
Discussion started by: lsaas
2 Replies

5. Shell Programming and Scripting

cut and paste using awk

Hi i need a favour i have a file which has some trillions of records. The file is like this 11111000000000192831840914000000000000000000000000000 45789899090000000000000000011111111111111111111111111 I want to cut specific postions in each line like cut1-3 and assisgn it to a variable and... (5 Replies)
Discussion started by: richa2.m
5 Replies

6. Shell Programming and Scripting

appending several columns with awk and paste

Hello, I am trying to solve for a couple of hours now the following problem: I have n files and would like to add the third column of each file to a new file: temp1.txt 1 2 3 1 2 3 1 2 3 temp2.txt 1 2 4 1 2 4 1 2 4 1 2 4 temp3.txt (2 Replies)
Discussion started by: creamcheese
2 Replies

7. UNIX for Dummies Questions & Answers

cut and paste columns using awk

Hi, Let's say that I have a file called table, I know that if I need to see a the second column for exampls I use: awk ' {print $2}' table.txt Is there anyway to use awk to actually cut a column and put it somewhere else in the table?:confused: (8 Replies)
Discussion started by: cosmologist
8 Replies

8. Shell Programming and Scripting

awk with paste ... columnwise

Hi, I'm trying to plot some data using the awk to find and parse the data and then use gnuplot to plot it up. I'd like to plot one or more range cells (let the user decide!). I've been able to write up the code such that I can plot one range cell per plot, but I just can't see how to get more... (1 Reply)
Discussion started by: dpath2o
1 Replies

9. Shell Programming and Scripting

help with awk to create report

Hi, I am trying to create a report using the following syntax: #!/bin/awk -f #script name: users_report BEGIN { FS=":" ; OFS="\t" ; print "User\tGID\tUser Name\tHome Dir\t" { print $1 , $3 , $5 , $6 } END { print "\n End of Report \n" } $> user_report /etc/passwd the output of... (5 Replies)
Discussion started by: ghazi
5 Replies

10. UNIX for Dummies Questions & Answers

awk or sed or paste

i have a file and i need the text to line up currently the file looks like so job scheduled complete 12 12:00 wendsday 13 1:00 wednsday its a text file but not sure how to manipulate the file for it to line up (3 Replies)
Discussion started by: leprichaun
3 Replies
Login or Register to Ask a Question