Formatting output for a bash script

Question

The output looks like this

bbnum,building,floor,cluster,row,position,namespaces

BBEG,BUILDEG,1,CLUsEG,5,19,namespaceEG

I would like to add spaces throughout, match up the top row with the bottom and delete cluster, row and namespaces (Delete the top and bottom part of the provided list)

Im trying to make it look something like this. Just trying to make it look neat

bbnum  building  floor  row  position

BBEG   BUILDEG    1          5     19

Any help would be greatly appreciated!!

The output of what? You should be able to do what you want with printf, you can specify the width of each field in the format satring. — Barmar
– Barmar, Commented Apr 3, 2020 at 21:01
Almost but not quite. awk -F, -v OFS='\t' '{$NF = ""; $1=$1}1' file.txt — Jetchisel
– Jetchisel, Commented Apr 3, 2020 at 21:17
Or ... command_with_output | awk -F, -v OFS='\t' '{$NF = ""; $1=$1}1' — Jetchisel
– Jetchisel, Commented Apr 3, 2020 at 21:24

mengmann · Accepted Answer · 2020-04-05 09:05:23Z

2

Edit: ~~remove comma with sed~~ and try piping your output to column -ts, command like this:

$ echo -e "bbnum,building,floor,cluster,row,position,namespaces\nBBEG,BUILDEG,1,CLUsEG,5,19,namespaceEG" | column -ts,
bbnum  building  floor  cluster  row  position  namespaces
BBEG   BUILDEG   1      CLUsEG   5    19        namespaceEG

edited Apr 5, 2020 at 9:05

answered Apr 3, 2020 at 21:10

mengmann

4167 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

dreamchaser1024 Over a year ago

That worked perfectly! Thank you so much for your time.

Quasímodo Over a year ago

@dreamchaser1024 Please have a look at <stackoverflow.com/help/someone-answers>

mengmann Over a year ago

@Quasímodo: there you go

Saboteur · Accepted Answer · 2020-04-03 22:54:09Z

0

while read; do
  printf "%10s %10s %10s %10s\n" $(echo "$REPLY"|cut -d "," --output-delimiter " " -f 1-3,6)
done < yourfile.txt

edited Apr 3, 2020 at 22:54

answered Apr 3, 2020 at 22:47

Saboteur

1,4328 silver badges13 bronze badges

Collectives™ on Stack Overflow

Formatting output for a bash script

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related