Menu
I have a file with an arbitrary number of non-aligned columns separated with whitespace.
I would like to align the columns of the file.
I've looked at the col command, and it doesn't seem appropriate.
I could write an AWK script, but it seems like a more obvious command should exist.
379
In the Format Cells dialog box that appears, go to the Number tab and select one of the Date options under Category. Then, click on the OK button. Once you have selected how you want your columns to be aligned, you can click on the Finish button in the Text Import Wizard or close out of the Format Cells dialog box.
On the Home tab, click Paragraph, and then click Align. Select the Align with option and then select the paragraph tag pertaining to the column one paragraph. Click OK.
Whitespace — this is a tab, newline, vertical tab, form feed, carriage return, or space. Bash uses whitespace to determine where words begin and end. The first word is the command name and additional words become arguments to that command.
You might want the column command, usually with --table / -t to produce basic tabular output:
From the man page:
-t, --tableDetermine the number of columns the input contains and create a table. Columns are delimited with whitespace, by default, or with the charac‐ters supplied using the --output-separator option. Table output is useful for pretty-printing.
column -t [file] # or from stdin cat file | column -t # For a quick demonstration, format the output of mount mount | column -t column has a lot of other complex options. man column for details.
155
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
