Firstly one of my mysql queries will yeild following output
+-------+---------------------+-------------------+----------------------------------------------------------------------------+
| ID | PLATFORM | SORT_NAME | DESCRIPTION |
+-------+---------------------+-------------------+----------------------------------------------------------------------------+
| 11312 | ccm113 | LINUX | |
+-------+---------------------+-------------------+----------------------------------------------------------------------------+
when i redirect it to one file, the tabluar format is not retained. Any idea how to retain the tabluar format even after retaining?? (or to provide a custom tabular format while redirecting?)
as of now i redirected it to one file it comes in below format witth mismatched spacing and indentation
cat output1.txt
ID PLATFORM SORT_NAME DESCRIPTION
11312 ccm113 LINUX
i have output of another script, its output is for respective ID of above mysql query, is as below
cat output2.txt
Availability: GREEN
Availability: RED
Availability: GREEN
Availability: RED
Availability: RED
now i want to merge output2.txt with output1.txt as additional column and still retain initial column or provide similiar column of mysql output.
is it feasible? any help is deeply appreciated.. thanks
PS: i want to achiveve finial output as below in a file
[CODE]+-------+---------------------+-------------------+----------------------------------------------------------------------------+--------------+
| ID | PLATFORM | SORT_NAME | DESCRIPTION | AVAILABILITY |
+-------+---------------------+-------------------+----------------------------------------------------------------------------+--------------+
| 11312 | ccm113 | LINUX | | GREEN |