====== Sandbox ======
===== Developpment =====
# cat tsm_substitutions.txt
server;strict;TSMPRD1;PROD
fs;strict;/root;EXCH
fs;grep;/usr;SYS
$DSMADMC $OPT_COMMA $OPT_DATAONLY "select o.node_name,n.DOMAIN_NAME,o.FILESPACE_NAME,o.FILESPACE_ID,o.PHYSICAL_MB,o.LOGICAL_MB,o.REPORTING_MB,f.FILESPACE_TYPE,f.CAPACITY,f.PCT_UTIL,TO_CHAR(CHAR(f.BACKUP_START),'YYYY-MM-DD HH24:MI:SS') as BACKUP_START,TO_CHAR(CHAR(f.BACKUP_END),'YYYY-MM-DD HH24:MI:SS') as BACKUP_END,TO_CHAR(CHAR(f.LAST_BACKUP_COMPLETE),'YYYY-MM-DD HH24:MI:SS') as LAST_BACKUP_COMPLETE from occupancy o,filespaces f,nodes n where o.node_name=n.node_name and o.node_name=f.node_name and o.FILESPACE_ID=f.FILESPACE_ID" | sed "s/^/$server,/" >> $tmplog/tsm_output.csv
===== End =====
Original Table
^ Year ^ Location|
| 2004| Athens, Greece|
| 2008| Beijing, China|
| 2012| London, United Kingdom  |
| 2016| Rio de Janeiro, Brazil|
prettytables Table
^  Year  ^         Location         |
|  2004  |      Athens, Greece      |
|  2008  |      Beijing, China      |
|  2012  |  London, United Kingdom  |
|  2016  |  Rio de Janeiro, Brazil  |
tablewidth
|< 100% 50px - 5em 10em 10% >|
^ A  ^  B  ^  C  ^  D  ^  E  ^
| 1  |  2  |  3  |  4  |  5  |
If there are more columns in the table than there are values in the width specification, the width willbe applied to the columns from left to right:
|< 50em 20% >|
^ 20%              ^ 80%                          ^
| Specified width  | The rest of the table width  |
==== color ====
text
text
text
text
text
text
text
text
text
text
text
text