17.7. Fixed-Width Text Converter¶
The fixed-width text converter handles text files that follow a fixed format. To use the fixed-width
converter, specify type = "fixed-width"
in your converter definition.
17.7.1. Configuration¶
fields
in a fixed-width converter support two additional attributes, start
and width
. These
define the offset and length of each field in relation to the entire record.
17.7.2. Transform Functions¶
The transform
element supports referencing the fixed-width substring through $0
. Each column will initially
be a string, so further transforms may be necessary to create the correct type. See Transformation Function Overview for
available functions.
17.7.3. Example Usage¶
Suppose you have a SimpleFeatureType
that consists of a sole geometry: *geom:Point:srid=4326
. Your
input data is a fixed-width file where the latitude and longitude are defined as 2 digit numbers, following
a single digit prefix:
14555
16565
The following Typesafe Config string defines an appropriate converter for taking this data and
transforming it into our SimpleFeatureType
:
geomesa.converters.example = {
type = "fixed-width",
id-field = "uuid()",
options = {
validators = []
}
fields = [
{ name = "lat", start = 1, width = 2, transform = "$0::double" },
{ name = "lon", start = 3, width = 2, transform = "$0::double" },
{ name = "geom", transform = "point($lon, $lat)" }
]
}