VCSVOP

VisionX V4

NAME

vcsvop − operations on csv files

SYNOPSIS

vcsvop [if=<infile>] [ig=infile2] [of=<outfile>] [d=] [c=] [v=] [n=] [k=] [ki=] [-h] [-s] [-di] [-dn] [-j] [-g] [-sc] [-ic] [-iw] [-sa] [-sd] [-sda] [-sdd] [-v] [-d]

DESCRIPTION

Vcsvop is a general purpose command to manipulate csv files. See also vciop for other useful operations on SIMBA csv files.

OPTIONS

if=<infile>

The primary csv file to be processed

ig=<infile>

The second csv file for two operand processing

	of=		The output file
	d=<list>		Delete columns: the argument is a comma separated numeric list of columns to be deleted. The first column is 0.

c=<column>

Specify a column for selecting (retaining) rows. The argument specifies a column that is to be examined for row selection. See v= and n= below

cn=<column-name>

Specify a column for selecting (retaining) rows.

The value to be tested when the c= option is specified. The value in that column must exactly match the text string value of the v= option for that row to be retained.

n=<expression>

The conditional mathematical expression to be evaluated in order for a row to be retained. Example: "> 5"

	k=		Keep the columns listed by column-names separated by commas. The order of the columns is as specified by the list.
	ki=		Keep the columns listed by index separated by commas (first column is 0). The order of the columns is as specified by the list.
	-sc		Select rows from file1 that have a first column match to file2
	-di		Delete incomplete rows
	-dn		Delete rows with any null values
	-sa		Sort the list according to the c= column ( default column 0) in ascending order
	-sd		Sort the list according to the c= column ( default column 0) in descending order
	-sda		Sort the list according to the c= column ( default column 0) in dictionary ascending order
	-sdd		Sort the list according to the c= column ( default column 0) in dictionary descending order
	-sna		Sort the list according to the c= column ( default column 0) in numerical ascending order
	-snd		Sort the list according to the c= column ( default column 0) in numerical descending order
	-h		This option specifies that the input file does not have a header row
	-ic		print the number of rows and number of columns in the file to standard out
	-sw		print in wish format stats about the selected (by c=) numerical column.
	pct=		sets a custom percentile value for the -sw option
	-cw		print in wish format categorical stats about the selected (by c=) column.
	-iw		print the number of rows and number of columns in the file in wish format
	-c		Concatenate two files.
	-v		verbose mode
	-d		debug mode

operations on two files

	-j		Join two files on a row by row basis. (no checks no deletions)
	-g		generalized two operand join operation on the first two columns. For each first column in the if= find a matching first column in the second and join (delete the first column of second found in the second ig= list.

AUTHOR

A. P. Reeves

SEE ALSO

vcciop(1)