Shell Programming and Scripting

Hi Franklin52,

I've tried to play around with the given solution, but with limited knowledge in this area, I'm unable to solve it.

That's why I need help from more experience users.

Thanks.


Regards,
Peter

---------- Post updated at 04:48 AM ---------- Previous update was at 04:46 AM ----------

Hi ygemici,

The result is still the same for more entries, however, I had been given other solution that works.

Thanks for your help.


Regards,
Peter

---------- Post updated at 05:09 AM ---------- Previous update was at 04:48 AM ----------

Hi zaxxon,

I found your method is quite interesting and have been trying to understand what does it mean and how it works.

Code:

awk -F "B" '{gsub(/ +/," "); printf "%14s%1s%14s%1s%14s%1s%10s\n", $1, FS, $2, FS, $3, FS, $4}' infile

Could you advice what does this section mean?

Code:

awk -F "B" '{gsub(/ +/," ")

When I tried your method with more entries, the alignment is out. But, this does not happen with fewer entries. The first column is OK, not the second and third. Could not understand why.

Code:

       28.12 GB         0.02 GB         28.10 GB        0%
        0.48 GB         0.29 GB         0.19 GB         60%
        0.48 GB         0.29 GB         0.19 GB         60%
      228.90 GB         89.47 GB        139.42 GB       39%
      228.76 GB         72.37 GB        156.39 GB       31%

Appreciate for any help and advice.

Thanks.


Regards,
Peter

Sure. Since your input file has no real usable field separator, I decided to use the B of GB (that's the awk -F "B") as field separator.
Between the fields is sometimes 1 blank and sometimes many more than 1 blank separating them. So I tell awk to globallysubstitute, every 2 or more blanks with a single blank. If not doing that, it happens that the sometimes plentyful blanks in your lines just push the fields further apart so that a formatting with printf is kinda ugly and not possible.

So if you check what happens when you just use the code above without the long printf, you get this:

Code:

awk -F "B" '{gsub(/ +/," "); print}' infile
0.48 GB 0.29 GB 0.19 GB 60%
0.48 GB 0.29 GB 0.19 GB 60%
228.90 GB 89.47 GB 139.42 GB 39%
228.76 GB 72.37 GB 156.39 GB 31%

This a much more tidy base to start from, using "B" as field seprator. All those different amounts of spaces pushing fields apart are gone and sowith do not disturb using printf.

Hi zaxxon,

Thanks a lot for your detailed explanation.


Regards,
Peter