Hello,
i've got a script based on queries which generates this output into a file
cat cron_S-PostGres-ncc_license_Simpel_ActSub_per_Product
201502-b31s31i10 | MVNO | 114751 | 2017-07-19
201502-b31s31i10R60-60 | MVNO | 62115 | 2017-07-19
201511-b31s31i15 | MVNO | 311970 | 2017-07-19
Simpel PostPay | MVNO | 59 | 2017-07-19
Simpel PrePay | MVNO | 10254 | 2017-07-19
I'm finding it a bit hard in order to try to do another script which opens this file and present the output in the following format:
201502-b31s31i10 - 114751 (2017-07-19), 201502-b31s31i10R60 - 62115 (2017-07-19), ...
I tried to play a bit with grep and awk, but i don't want to specifically grep any string from the first row since they may increase by time, making the grep static (i.e. by time the script needs to be altered to add the new string in grep.
can you kindly shed some light?