org.das2.qds.util.AsciiParser
Class for reading ASCII tables into a QDataSet. This parses a file by breaking
it up into records, and passing the record off to a delegate record parser.
The record parser then breaks up the record into fields, and each field is
parsed by a delegate field parser. Each column of the table has a Unit, field name,
and field label associated with it.
Examples of record parsers include
DelimParser, which splits the record by a delimiter such as a tab or comma,
RegexParser, which processes each record with a regular expression to get the fields,
and FixedColumnsParser, which splits the record by character positions.
Example of field parsers include DOUBLE_PARSER which parses the value
as a double, and UNITS_PARSER, which uses the Unit attached to the column
to interpret the value.
When the first record with the correct number of fields is found but is not
parseable, we look for field labels and units.
The skipLines property tells the parser to skip a given number of header lines
before attempting to parse the record. Also, commentPrefix identifies lines to be
ignored. In either the header or in comments, we look for propertyPattern, and
if a property is matched, then the builder property
is set. Two Patterns are provided NAME_COLON_VALUE_PATTERN and
NAME_EQUAL_VALUE_PATTERN for convenience.
Adapted to QDataSet model, Jeremy, May 2007.
AsciiParser( )
Creates a new instance. This is created and then
configured before any files can be parsed.
NAME_COLON_VALUE_PATTERN
pattern for name:value.
NAME_EQUAL_VALUE_PATTERN
pattern for name=value.
PROPERTY_FIELD_NAMES
PROPERTY_FILE_HEADER
PROPERTY_FIRST_RECORD
PROPERTY_FIELD_PARSER
DELIM_COMMA
DELIM_TAB
DELIM_WHITESPACE
UNIT_UTC
Convenient unit for parsing UTC times.
PROP_HEADERDELIMITER
DOUBLE_PARSER
parses the field using Double.parseDouble, Java's double parser.
UNITS_PARSER
delegates to the unit object set for this field to parse the data.
ENUMERATION_PARSER
uses the EnumerationUnits for the field to create a Datum.
PROP_VALIDMIN
PROP_VALIDMAX
addPropertyChangeListener
addPropertyChangeListener( java.beans.PropertyChangeListener l ) → void
Adds a PropertyChangeListener to the listener list.
Parameters
l - The listener to add.
Returns:
void (returns nothing)
[search for examples]
[view on GitHub]
[view on old javadoc]
[view source]
getDelimParser
getDelimParser( int fieldCount, String delim ) → DelimParser
provide more control to external codes by providing a way to assert that
an N-column delim parser should be used.
Parameters
fieldCount - an int
delim - the delimiter pattern, such as "," or "\s+"
Returns:
the DelimParser.
[search for examples]
[view on GitHub]
[view on old javadoc]
[view source]
getFieldCount
getFieldCount( ) → int
return the number of fields in each record. Note the RecordParsers
also have a fieldCount, which should be equal to this. This allows them
to be independent of the parser.
Returns:
an int
[search for examples]
[view on GitHub]
[view on old javadoc]
[view source]
getFieldIndex
getFieldIndex( String string ) → int
returns the index of the field. Supports the name, or field0, or 0, etc.
returns -1 when the column is not identified.
Parameters
string - the label for the field, such as "field2" or "time"
Returns:
-1 or the index of the field.
[search for examples]
[view on GitHub]
[view on old javadoc]
[view source]
getFieldLabels
getFieldLabels( ) → String[]
return the labels found for each field. If a label wasn't found,
then the name is returned.
Returns:
a java.lang.String[][]
[search for examples]
[view on GitHub]
[view on old javadoc]
[view source]
getFieldNames
getFieldNames( ) → String[]
return the name of each field. field0, field1, ... are the default names when
names are not discovered in the table. Changing the array will not affect
internal representation.
Returns:
a java.lang.String[][]
[search for examples]
[view on GitHub]
[view on old javadoc]
[view source]
getFieldUnits
getFieldUnits( ) → String[]
return the units that were associated with the field. This might also be
the channel label for spectrograms.
In "field0(str)" or "field0[str]" this is str.
elements may be null if not found.
Returns:
a java.lang.String[][]
[search for examples]
[view on GitHub]
[view on old javadoc]
[view source]
getFillValue
getFillValue( ) → double
return the fillValue. numbers that parse to this value are considered
to be fill. Note validMin and validMax may be used as well.
Returns:
Value of property fillValue.
[search for examples]
[view on GitHub]
[view on old javadoc]
[view source]
getHeaderDelimiter
getHeaderDelimiter( ) → String
get the header delimiter
Returns:
the header delimiter.
[search for examples]
[view on GitHub]
[view on old javadoc]
[view source]
getRecordParser
getRecordParser( ) → RecordParser
Getter for property recordParser.
Returns:
Value of property recordParser.
[search for examples]
[view on GitHub]
[view on old javadoc]
[view source]
getRegexForFormat
getRegexForFormat( String format ) → String
Convert FORTRAN (F77) style format to C-style format specifiers.
Parameters
format - for example "%5d%5d%9f%s"
Returns:
for example "d5,d5,f9,a"
See Also:
org.autoplot.metatree.MetadataUtil#normalizeFormatSpecifier
[search for examples]
[view on GitHub]
[view on old javadoc]
[view source]
getRegexParser
getRegexParser( String regex ) → RegexParser
return a regex parser for the given regular expression. Groups are used
for the fields, for example getRegexParser( 'X (\d+) (\d+)' ) would
parse lines like "X 00005 00006".
Parameters
regex - a String
Returns:
the regex parser
[search for examples]
[view on GitHub]
[view on old javadoc]
[view source]
getRegexParserForFormat
getRegexParserForFormat( String format ) → RegexParser
see private TimeParser(String formatString, Map fieldHandlers),
which is very similar.
- "%5d%5d%9f%s"
- "d5,d5,f9,a"
Parameters
format - a String
Returns:
an org.das2.qds.util.AsciiParser.RegexParser
See Also:
org.das2.datum.TimeParser
[search for examples]
[view on GitHub]
[view on old javadoc]
[view source]
getRichFields
getRichFields( ) → Map
returns the high rank rich fields in a map from NAME to LABEL.
NAME:>fieldX< or NAME:>fieldX-fieldY<
Returns:
the high rank rich fields in a map from NAME to LABEL.
[search for examples]
[view on GitHub]
[view on old javadoc]
[view source]
getUnits
getUnits( int index ) → Units
Indexed getter for property units.
Parameters
index - Index of the property.
Returns:
Value of the property at index
.
[search for examples]
[view on GitHub]
[view on old javadoc]
[view source]
getValidMax
getValidMax( ) → double
get the maximum value for any field.
Returns:
the validMax
[search for examples]
[view on GitHub]
[view on old javadoc]
[view source]
getValidMin
getValidMin( ) → double
get the minimum valid value for any field.
Returns:
validMin
[search for examples]
[view on GitHub]
[view on old javadoc]
[view source]
guessDelimParser
guessDelimParser( String line ) → DelimParser
Parameters
line - a String
Returns:
org.das2.qds.util.AsciiParser.DelimParser
[search for examples]
[view on GitHub]
[view on old javadoc]
[view source]
guessDelimParser( String line, int lineNumber ) → DelimParser
guessFieldCount
guessFieldCount( String filename ) → int
return the field count that would result in the largest number of records parsed. The
entire file is scanned, and for each line the number of decimal fields is counted. At the end
of the scan, the fieldCount with the highest record count is returned.
Parameters
filename - the file name, a local file opened with a FileReader
Returns:
the apparent field count.
[search for examples]
[view on GitHub]
[view on old javadoc]
[view source]
guessLengthForFormat
guessLengthForFormat( String format ) → int
return the length of the format specifier. %30d -> 30 %30d%5f -> 35.
TODO: consider String.format(format,1) or String.format(format,1.0).
Parameters
format - a String
Returns:
an int
[search for examples]
[view on GitHub]
[view on old javadoc]
[view source]
guessSkipAndDelimParser
guessSkipAndDelimParser( String filename ) → DelimParser
read in records, allowing for a header of non-records before
guessing the delim parser. This will return a reference to the
DelimParser and set skipLines. DelimParser header field is set as well.
One must set the record parser explicitly.
Parameters
filename - a String
Returns:
the record parser to use, or null if no records are found.
[search for examples]
[view on GitHub]
[view on old javadoc]
[view source]
guessSkipLines
guessSkipLines( String filename, org.das2.qds.util.AsciiParser.RecordParser recParser ) → int
try to figure out how many lines to skip by looking for the line where
the number of fields becomes stable.
Parameters
filename - a String
recParser - an AsciiParser.RecordParser
Returns:
an int
[search for examples]
[view on GitHub]
[view on old javadoc]
[view source]
isHeader
isHeader( int iline, String lastLine, String thisLine, int recCount ) → boolean
returns true if the line is a header or comment.
Parameters
iline - the line number in the file, starting with 0.
lastLine - the last line read.
thisLine - the line we are testing.
recCount - the number of records successfully read.
Returns:
true if the line is a header line.
[search for examples]
[view on GitHub]
[view on old javadoc]
[view source]
isIso8601Time
isIso8601Time( String s ) → boolean
quick-n-dirty check to see if a string appears to be an ISO8601 time.
minimally 2000-002T00:00, but also 2000-01-01T00:00:00Z etc.
Note that an external code may explicitly indicate that the field is a time,
This is just to catch things that are obviously times.
Parameters
s - a String
Returns:
true if this is clearly an ISO time.
[search for examples]
[view on GitHub]
[view on old javadoc]
[view source]
isKeepFileHeader
isKeepFileHeader( ) → boolean
Getter for property keepHeader.
Returns:
Value of property keepHeader.
[search for examples]
[view on GitHub]
[view on old javadoc]
[view source]
isRichHeader
isRichHeader( String header ) → boolean
return true if the header appears to contain JSON code which could be
interpreted as a "Rich Header" (a.k.a. JSONHeadedASCII). This is
a very simple test, simply looking for #{
and #}
with a colon contained within.
Parameters
header - string containing the commented header.
Returns:
true if parsing as a Rich Header should be attempted.
See Also:
https://github.com/JSONheadedASCII/examples
[search for examples]
[view on GitHub]
[view on old javadoc]
[view source]
isRichHeader( ) → boolean
newParser
newParser( int fieldCount ) → AsciiParser
creates a parser with @param fieldCount fields, named "field0,...,fieldN"
Parameters
fieldCount - the number of fields
Returns:
the file parser
[search for examples]
[view on GitHub]
[view on old javadoc]
[view source]
newParser( java.lang.String[][] fieldNames ) → AsciiParser
readFile
readFile( String filename, ProgressMonitor mon ) → WritableDataSet
Parse the file using the current settings.
Parameters
filename - the file to read
mon - a monitor
Returns:
a rank 2 dataset.
[search for examples]
[view on GitHub]
[view on old javadoc]
[view source]
readFirstParseableRecord
readFirstParseableRecord( String filename ) → String
returns the first record that the record parser parses successfully. The
recordParser should be set and configured enough to identify the fields.
If no records can be parsed, then null is returned.
The first record should be in the first 1000 lines.
Parameters
filename - a String
Returns:
the first parseable line, or null if no such line exists.
[search for examples]
[view on GitHub]
[view on old javadoc]
[view source]
readFirstRecord
readFirstRecord( String filename ) → String
return the first record that the parser would parse. If skipLines is
more than the total number of lines, or all lines are comments, then null
is returned.
Parameters
filename - a String
Returns:
the first line after skip lines and comment lines.
[search for examples]
[view on GitHub]
[view on old javadoc]
[view source]
readFirstRecord( java.io.BufferedReader reader ) → String
readStream
readStream( java.io.Reader in, ProgressMonitor mon ) → WritableDataSet
Parse the stream using the current settings.
Parameters
in - the input stream
mon - a ProgressMonitor
Returns:
an org.das2.qds.WritableDataSet
[search for examples]
[view on GitHub]
[view on old javadoc]
[view source]
readStream( java.io.Reader in, String firstRecord, ProgressMonitor mon ) → WritableDataSet
readString
readString( String str, ProgressMonitor mon ) → WritableDataSet
Parameters
str - the data, encoded in a UTF-8 string
mon - null or a progress monitor
Returns:
the data
[search for examples]
[view on GitHub]
[view on old javadoc]
[view source]
removePropertyChangeListener
removePropertyChangeListener( java.beans.PropertyChangeListener l ) → void
Removes a PropertyChangeListener from the listener list.
Parameters
l - The listener to remove.
Returns:
void (returns nothing)
[search for examples]
[view on GitHub]
[view on old javadoc]
[view source]
setCommentPrefix
setCommentPrefix( String comment ) → void
Records starting with this are not processed as data, for example "#".
This is initially "#". Setting this to null disables this check.
Parameters
comment - the prefix
Returns:
void (returns nothing)
[search for examples]
[view on GitHub]
[view on old javadoc]
[view source]
setDelimParser
setDelimParser( String filename, String delimRegex ) → DelimParser
The DelimParser splits each record into fields using a delimiter like ","
or "\\s+".
Parameters
filename - filename to read in.
delimRegex - the delimiter, such as "," or "\t" or "\s+"
Returns:
the record parser that will split each line into fields
[search for examples]
[view on GitHub]
[view on old javadoc]
[view source]
setDelimParser( String line, String delimRegex, int expectedColumnCount ) → DelimParser
setDelimParser( java.io.Reader in, String delimRegex ) → DelimParser
setFieldParser
setFieldParser( int field, org.das2.qds.util.AsciiParser.FieldParser fp ) → void
set the special parser for a field.
Parameters
field - the field number, 0 is the first column.
fp - the parser
Returns:
void (returns nothing)
[search for examples]
[view on GitHub]
[view on old javadoc]
[view source]
setFillValue
setFillValue( double fillValue ) → void
numbers that parse to this value are considered to be fill.
Parameters
fillValue - New value of property fillValue.
Returns:
void (returns nothing)
[search for examples]
[view on GitHub]
[view on old javadoc]
[view source]
setFixedColumnsParser
setFixedColumnsParser( String filename, String delim ) → FixedColumnsParser
looks at the first line after skipping, and splits it to calculate where
the columns are. The FixedColumnsParser is the fastest of the three parsers.
Parameters
filename - filename to read in.
delim - regex to split the initial line into the fixed columns.
Returns:
the record parser that will split each line.
[search for examples]
[view on GitHub]
[view on old javadoc]
[view source]
setFixedColumnsParser( java.io.Reader in, String delim ) → FixedColumnsParser
setFixedColumnsParser( int[][] columnOffsets, int[][] columnWidths, org.das2.qds.util.AsciiParser.FieldParser[][] parsers ) → FixedColumnsParser
setHeaderDelimiter
setHeaderDelimiter( String headerDelimiter ) → void
set the delimiter which explicitly separates header from the data.
For example "-------" could be used. Normally the parser just looks at
the number of fields and this is sufficient.
Parameters
headerDelimiter - a String
Returns:
void (returns nothing)
[search for examples]
[view on GitHub]
[view on old javadoc]
[view source]
setKeepFileHeader
setKeepFileHeader( boolean keepHeader ) → void
Setter for property keepHeader. By default false but if true, the file header
ignored by skipLines is put into the property PROPERTY_FILE_HEADER.
Parameters
keepHeader - New value of property keepHeader.
Returns:
void (returns nothing)
[search for examples]
[view on GitHub]
[view on old javadoc]
[view source]
setPropertyPattern
setPropertyPattern( java.util.regex.Pattern propertyPattern ) → void
specify the Pattern used to recognize properties. Note property
values are not parsed, they are provided as Strings. This is a regular
expression with two groups for the property name and value.
For example, (.+)=(.+)
Parameters
propertyPattern - regular expression Pattern with two groups.
Returns:
void (returns nothing)
[search for examples]
[view on GitHub]
[view on old javadoc]
[view source]
setRecordCountLimit
setRecordCountLimit( int recordCountLimit ) → void
limit the number of records read. parsing will stop once this number of
records is read into the result. This is Integer.MAX_VALUE by default.
Parameters
recordCountLimit - an int
Returns:
void (returns nothing)
[search for examples]
[view on GitHub]
[view on old javadoc]
[view source]
setRecordParser
setRecordParser( org.das2.qds.util.AsciiParser.RecordParser recordParser ) → void
Setter for property recordParser.
Parameters
recordParser - New value of property recordParser.
Returns:
void (returns nothing)
[search for examples]
[view on GitHub]
[view on old javadoc]
[view source]
setRecordStart
setRecordStart( int recordStart ) → void
set the number of records to skip before accumulating the result.
Parameters
recordStart - an int
Returns:
void (returns nothing)
[search for examples]
[view on GitHub]
[view on old javadoc]
[view source]
setRegexParser
setRegexParser( java.lang.String[][] fieldNames ) → RecordParser
The regex parser is a slow parser, but gives precise control.
Parameters
fieldNames - a java.lang.String[]
Returns:
the parser for each record.
[search for examples]
[view on GitHub]
[view on old javadoc]
[view source]
setSkipLines
setSkipLines( int skipLines ) → void
skip a number of lines before trying to parse anything. This can be
set to point at the first valid line, and the RecordParser will be
configured using that line.
Parameters
skipLines - an int
Returns:
void (returns nothing)
[search for examples]
[view on GitHub]
[view on old javadoc]
[view source]
setUnits
setUnits( int index, Units units ) → void
Indexed setter for property units. This now sets the field parser for
the field to be a UNITS_PARSER if it is the default DOUBLE_PARSER.
Parameters
index - Index of the property.
units - New value of the property at index
.
Returns:
void (returns nothing)
[search for examples]
[view on GitHub]
[view on old javadoc]
[view source]
setUnits( org.das2.datum.Units[][] u ) → void
setValidMax
setValidMax( double validMax ) → void
set the maximum value for any field. Values above this are to be
considered invalid.
Parameters
validMax - a double
Returns:
void (returns nothing)
[search for examples]
[view on GitHub]
[view on old javadoc]
[view source]
setValidMin
setValidMin( double validMin ) → void
set the minimum valid value for any field. Values less than
this are to be considered invalid.
Parameters
validMin - a double
Returns:
void (returns nothing)
[search for examples]
[view on GitHub]
[view on old javadoc]
[view source]
setWhereConstraint
setWhereConstraint( String sparm, String op, String sval ) → void
allow constraint for where condition is true. This doesn't
need the data to be interpreted for "eq", string equality is checked
for nominal data. Note sval is compared after trimming outside spaces.
Parameters
sparm - column name, such as "field4"
op - constraint, one of eq gt ge lt le ne
sval - String value. For nominal columns, String equality is used.
Returns:
void (returns nothing)
[search for examples]
[view on GitHub]
[view on old javadoc]
[view source]