Content-type: text/html; charset=UTF-8 Man page of CEDUTILS

CEDUTILS

Section: User Commands (1)
Updated: 2023-06-25
Index Return to Main Contents

 

NAME

cedutils - spreadsheet utilities  

SYNOPSIS

cedutils [ OPTION ]...  

DESCRIPTION

mtCedUtils is a collection of command line functions for manipulating TSV or CSV spreadsheet text. These functions can be executed using cedutils or the function names directly as listed in the SEE ALSO section.  

OPTIONS

--version

Output version information and exit.

-anti

Rotate clockwise (default).

-case

Case sensitive search.

-clock

Rotate clockwise (default).

-col

cedappend - Place the following files horizontally. cedcut - Cut column(s). cedflip - Flip columns horizontally. cedinsert - Insert column(s). cedsort - Sort columns.

-com STRING

Change command (with or without ced prefix). Available commands: cedappend, cedclear, cedcut, ceddiff, cedeval, cedfind, cedflip, cedinsert, cedls, cedpaste, cedrotate, cedset, cedsort, cedtranspose

-csv

The following input file is CSV.

-dest STRING

Paste to this section of the sheet (default = r1c1:r1c1 ). When a single cell, paste whole of input. Otherwise truncate or repeat input data to fill the dest range.

-i STRING

Load this input file. "-" loads from stdin.

-num

Find numerical value.

-o STRING

Save current sheet to this file (immediately). "-" prints to stdout.

-otype STRING

Output format of file (use 'list' to list types, default=TSV content).

-range STRING

cedclear - Clear these cells (default = r1c1:r_c_ ). cedfind - Search in this range (default = r1c1:r_c_ ). cedpaste - Paste from this section of the input file (default = r1c1:r_c_ ). cedfuzzmap - Set range for the following file.

-recalc INTEGER

Recalculate the sheet this many times (top-bottom, bottom-top).

-row

cedappend - Place the following files vertically (default). cedcut - Cut row(s) (default). cedlip - Flip rows vertically (default). cedinsert - Insert row(s) (default). cedsort - Sort rows (default)

-start INTEGER

cedcut - Start cutting at this row or column (default = 1). cedinsert - Start inserting at this row or column (default = 1). cedsort - First row/column to sort from (default = 1).

-total INTEGER

cedcut - Total number of rows or columns to cut (default = 1). cedinsert - Total number of rows or columns to insert (default = 1). cedsort - Total rows/colums to sort (default = 1 = all).

-tsv

The following input file is TSV (default).

-v

Verbose. cedfind - Output the cell content as well as the address.

-wildcard

* and ? characters are wildcards.
 

SEE ALSO

cedappend(1), cedclear(1), cedcut(1), ceddiff(1), cedeval(1), cedfind(1), cedflip(1), cedfuzzmap(1), cedinsert(1), cedls(1), cedpaste(1), cedrotate(1), cedset(1), cedsort(1), cedtranspose(1)  

HOMEPAGE

https://www.marktyler.org/  

AUTHOR

Mark Tyler


 

Index

NAME
SYNOPSIS
DESCRIPTION
OPTIONS
SEE ALSO
HOMEPAGE
AUTHOR

This document was created by man2html, using the manual pages.
Time: 08:25:03 GMT, June 25, 2023