I saw a request on TechNet Forum on how to align column text so that the data looks very neat.
I always think that it is very difficult to achieve this on Windows Batch Scripting, so out of curiosity, I somehow successfully wrote this on Batch Script.
YLNotes Scripts File:
S1-1. Download Admin Scripts YLNotes_Batch_ColumnTextAlignment
Download YLNotes_Batch_ColumnTextAlignment (84)
S1-2. Unzip to the root of the drive
How It Works:
S2-1. The script will load CSV data file and parse with default delimiter (i.e. space) as shown with below sample data
S2-2. For each column, we need to set the column parameter on Text Alignment, Column Width and Padding Character. Call Library Script YLNOTES_COLUMN_TEXT_ALIGNMENT which will return result with text alignment.
S2-3. The result of text alignment is output as shown below
S2-4. If you execute the batch file, the output are as follows: