Jan 3, 2012

Ordinal position to spreadsheet column

Keywords:  bash, spreadsheet, spreadsheet column, positional column, mapping, Excel, Libre Office
Depends on:  awk
Download:  ss_col

As a database engineer, I get data in different formats to ingest.  Many times it's in a spreadsheet with many columns:  200+.  During validation, I need to review certain columns.  I may have the column number which needs to be translated to a spreadsheet column (e.g. column number 26 maps to spreadsheet column `Z').

This script prints a column number and its corresponding spreadsheet column.  It's best to pipe the results to a pager such as less.

No comments:

Post a Comment