 Tabular data handling toolkit |
.>> .TH xlcells(1) TDH "19-SEP-2003 TDH scg@jax.org" .SH NAME xlcells(1) .ig >> .>> .SH SYNOPSIS \fCcat tabdata | xlcells \fIoptions\fC \fIcell1\fR .. \fIcellN\fR .ig >> .>> .SH DESCRIPTION Extract "cells" by spreadsheet location from a spreadsheet export tab-delimited file. For example, it may be used to automatically retrieve certain fields from a collection of spreadsheet-exported files. .LP Examples of \fIcell\fR addresses are \fC1A\fR or \fC247AB\fR. The alpha portion may be upper or lower case. .LP Output is a tab-delimited row of requested values. .ig >> .>> .SH OPTIONS .LP \fB-b\fIsym\fR .IP \0 Set the blank symbol to \fIsym\fR. By default, blank cells are represented as a zero-length string. This option allows blank cells to be represented using the given \fIsym\fR. Example: \fC-b=\fR .ig >> .>> .SH LIMITATIONS Rows 1-5000 and cols A - JJ supported. .LP Max cell length 255. .LP Max input line length 5000 chars. .LP Max # of requested cells is 50. .ig >> .>> .SH EXAMPLE Example: \fCcat tabdata | xlcells 35c 32c 22b\fR .ig >> .>> .SH AUTHOR Steve Grubb .ig >> |
Tabular data handling toolkit Copyright Steve Grubb |