Package adams.data.conversion

Class SpreadSheetSplitColumn

  • All Implemented Interfaces:
    AdditionalInformationHandler, CleanUpHandler, Destroyable, GlobalInfoSupporter, LoggingLevelHandler, LoggingSupporter, OptionHandler, QuickInfoSupporter, ShallowCopySupporter<AbstractConversion>, SizeOfHandler, Stoppable, Conversion, Serializable
    public class SpreadSheetSplitColumn
extends AbstractSpreadSheetConversion
    Splits the string representation of the cells of a column into multiple columns using a regular expression. 

    -logging-level <OFF|SEVERE|WARNING|INFO|CONFIG|FINE|FINER|FINEST> (property: loggingLevel)
    The logging level for outputting errors and debugging output.
    default: WARNING
 
    -column <adams.data.spreadsheet.SpreadSheetColumnIndex> (property: column)
    The column to split.
    default: first
    example: An index is a number starting with 1; column names (case-sensitive) as well as the following placeholders can be used: first, second, third, last_2, last_1, last; numeric indices can be enforced by preceding them with '#' (eg '#12'); column names can be surrounded by double quotes.
 
    -expression <java.lang.String> (property: expression)
    The regular expression used for splitting the column; \t\n\r\b\f get automatically 
    converted into their character counterparts.
    default: \\t
 
    -delimiter <DISCARD|APPEND|PREPEND> (property: delimiter)
    Defines what to do with the delimiters (= expression).
    default: DISCARD
    Version:
    $Revision$
    Author:
    fracpete (fracpete at waikato dot ac dot nz)
    See Also:
    Serialized Form

    • Field Detail

      • m_Expression

        protected String m_Expression
        the regular expression to use for splitting the string.

    • Constructor Detail

      • SpreadSheetSplitColumn

        public SpreadSheetSplitColumn()

    • Method Detail

      • setColumn

        public void setColumn​(SpreadSheetColumnIndex value)
        Sets the column to split.
        Parameters:
        value - the index

      • columnTipText

        public String columnTipText()
        Returns the tip text for this property.
        Returns:
        tip text for this property suitable for displaying in the GUI or for listing the options.

      • setExpression

        public void setExpression​(String value)
        Sets the regular expression used for splitting the string.
        Parameters:
        value - the expression

      • getExpression

        public String getExpression()
        Returns the regular expression for splitting the string.
        Returns:
        the expression

      • expressionTipText

        public String expressionTipText()
        Returns the tip text for this property.
        Returns:
        tip text for this property suitable for displaying in the GUI or for listing the options.

      • setDelimiter

        public void setDelimiter​(StringSplit.Delimiter value)
        Sets what to do with the delimiter (= expression).
        Parameters:
        value - the action

      • getDelimiter

        public StringSplit.Delimiter getDelimiter()
        Returns what to do with the delimiter (= expression).
        Returns:
        the action

      • delimiterTipText

        public String delimiterTipText()
        Returns the tip text for this property.
        Returns:
        tip text for this property suitable for displaying in the GUI or for listing the options.