RuG/L04

Manuals

sssplit

Description

split spreadsheet for processing by RuG/L04

Synopsis

sssplit [-c|-t] [-d directory] [-s] inputfile

Options

-c
set input delimiter to comma (default: autodetect)
-t
set input delimiter to tab (default: autodetect)
-d directory
Destination
-s
safe output filenames

Purpose

Split a single spreadsheet in a set of files that can be processed by leven and giw.

All output files will be stored in the directory specified by the option -d, or in directory out otherwise. The directory must exist. No existing files will be overwritten.

A label file will be saved as _LABELS_.LBL

The spreadsheet must be saved as a comma-delimited file or as a tab-delimited file. The use of comma and tab may not be mixed.
Each column must be the data for one location. Column headers are required.
Each row must be the data for one word. Row labels are optional.

Examples of allowed spreadsheet formats:

place1 place2 place3
wrd1 data data data
wrd2 data data data
wrd3 data data data

  place1 place2 place3
wrd1 data data data
wrd2 data data data
wrd3 data data data

place1 place2 place3
data data data
data data data
data data data

Data cells can be empty.
Data cells can have several word forms, separated by a semicolon.
Word forms can be enclosed in double quotes.
Comma and semicolon can be escaped with a backslash, to make it ordinary characters, or they can be used in word forms within double quotes.

Examples of valid data in a single cell:

example data explanation
itemone item: item
" item "one item: item
it; emtwo items: it and em
"it; em"one item: it; em
"it, em"one item: it, em
it\; emone item: it; em
it\, emone item: it, em
it\\emone item: it\em
it\"emone item: it"em
" "no items
(empty) no items