vxltovf − Convert an excel file to VisionX feature vector format

vxltovf [if=infile] [of=ofile] [-f] [-v] [-i] [-t]

Vxltovf converts a comma separated text file (csv) or tab separated text file into a set of feature vectors and vice versa. The first row of the text file must be the name of the data elements. Subsequent rows contain real valued feature vectors. If the inverse operation is requested, the output text file will follow this format.

If the first element in the row is is labeled "id" then this is taken to be an integer valued vector identifier. If the first element is labeled "class" then this value is taken as the integer valued class of the vector. If the last element is labeled "description" then this value is taken as the description for the vector. Note, in the case of both an id and a class, the id must appear first. In performing the inverse operation, if the vector file contains vector identifiers, these will become the first element in each row. If the vector file contains class information, the class will be either the first or second element in each row, depending on the presence of the vector identifiers. If the file contains description information, the description will be added to each row after the values of the feature vectors. The header information will reflect the presence of these tags.

-f

The -f flag inserts frame markers

-v

The -v flag selects the verbose option.

-i

The -i flag performs the inverse operation (converts vector file to excel format)

-t

The -t flag, when the inverse operation is selected, generates a tab separated file instead of the default CSV file. If the -i flag is not specified, this does nothing.

if=input file

The input file is either a text table as generated by excel using the csv or tab separated records output option, or a VisionX vector file.

of=

The of= parameter specifies the output file which is a set of feature vectors containing optional id, class, and description flags, or a comma or tab separated file.

A. P. Reeves and A. Jirapatnakul

vclasf(1), vfvcat(1), vfvpick(1),