org.pentaho.di.trans.steps.fieldsplitter.FieldSplitter Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of kettle-engine Show documentation
Container pom for Pentaho Data Integration modules
The newest version!
/*! ******************************************************************************
 *
 * Pentaho Data Integration
 *
 * Copyright (C) 2002-2017 by Hitachi Vantara : http://www.pentaho.com
 *
 *******************************************************************************
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with
 * the License. You may obtain a copy of the License at
 *
 *    http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 *
 ******************************************************************************/

package org.pentaho.di.trans.steps.fieldsplitter;

import org.pentaho.di.core.Const;
import org.pentaho.di.core.exception.KettleException;
import org.pentaho.di.core.exception.KettleValueException;
import org.pentaho.di.core.row.RowDataUtil;
import org.pentaho.di.core.row.ValueMetaInterface;
import org.pentaho.di.i18n.BaseMessages;
import org.pentaho.di.trans.Trans;
import org.pentaho.di.trans.TransMeta;
import org.pentaho.di.trans.step.BaseStep;
import org.pentaho.di.trans.step.StepDataInterface;
import org.pentaho.di.trans.step.StepInterface;
import org.pentaho.di.trans.step.StepMeta;
import org.pentaho.di.trans.step.StepMetaInterface;

/**
 * Split a single String fields into multiple parts based on certain conditions.
 *
 * @author Matt
 * @since 31-Okt-2003
 * @author Daniel Einspanjer
 * @since 15-01-2008
 */
public class FieldSplitter extends BaseStep implements StepInterface {
  private static Class PKG = FieldSplitterMeta.class; // for i18n purposes, needed by Translator2!!

  private FieldSplitterMeta meta;
  private FieldSplitterData data;

  public FieldSplitter( StepMeta stepMeta, StepDataInterface stepDataInterface, int copyNr, TransMeta transMeta,
                        Trans trans ) {
    super( stepMeta, stepDataInterface, copyNr, transMeta, trans );
  }

  private Object[] splitField( Object[] r ) throws KettleException {
    if ( first ) {
      first = false;
      // get the RowMeta
      data.previousMeta = getInputRowMeta().clone();

      // search field
      data.fieldnr = data.previousMeta.indexOfValue( meta.getSplitField() );
      if ( data.fieldnr < 0 ) {
        throw new KettleValueException( BaseMessages.getString(
          PKG, "FieldSplitter.Log.CouldNotFindFieldToSplit", meta.getSplitField() ) );
      }

      // only String type allowed
      if ( !data.previousMeta.getValueMeta( data.fieldnr ).isString() ) {
        throw new KettleValueException( ( BaseMessages.getString(
          PKG, "FieldSplitter.Log.SplitFieldNotValid", meta.getSplitField() ) ) );
      }

      // prepare the outputMeta
      //
      data.outputMeta = getInputRowMeta().clone();
      meta.getFields( data.outputMeta, getStepname(), null, null, this, repository, metaStore );

      // Now create objects to do string to data type conversion...
      //
      data.conversionMeta = data.outputMeta.cloneToType( ValueMetaInterface.TYPE_STRING );

      data.delimiter = environmentSubstitute( meta.getDelimiter() );
      data.enclosure = environmentSubstitute( meta.getEnclosure() );
    }

    // reserve room
    Object[] outputRow = RowDataUtil.allocateRowData( data.outputMeta.size() );

    int nrExtraFields = meta.getFieldID().length - 1;

    System.arraycopy( r, 0, outputRow, 0, data.fieldnr );
    System.arraycopy( r, data.fieldnr + 1, outputRow, data.fieldnr + 1 + nrExtraFields,
      data.previousMeta.size() - ( data.fieldnr + 1 ) );

    // OK, now we have room in the middle to place the fields...
    //

    // Named values info.id[0] not filled in!
    final boolean selectFieldById = ( meta.getFieldID().length > 0 )
      && ( meta.getFieldID()[ 0 ] != null )
      && ( meta.getFieldID()[ 0 ].length() > 0 );

    if ( log.isDebug() ) {
      if ( selectFieldById ) {
        logDebug( BaseMessages.getString( PKG, "FieldSplitter.Log.UsingIds" ) );
      } else {
        logDebug( BaseMessages.getString( PKG, "FieldSplitter.Log.UsingPositionOfValue" ) );
      }
    }

    String valueToSplit = data.previousMeta.getString( r, data.fieldnr );
    boolean removeEnclosure = Boolean.valueOf( System.getProperties().getProperty( Const.KETTLE_SPLIT_FIELDS_REMOVE_ENCLOSURE, "false" ) );
    String[] valueParts = Const.splitString( valueToSplit, data.delimiter, data.enclosure, removeEnclosure );
    int prev = 0;
    for ( int i = 0; i < meta.getFieldsCount(); i++ ) {
      String rawValue = null;
      if ( selectFieldById ) {
        for ( String part : valueParts ) {
          if ( part.startsWith( meta.getFieldID()[ i ] ) ) {
            // Optionally remove the id
            if ( meta.getFieldRemoveID()[ i ] ) {
              rawValue = part.substring( meta.getFieldID()[ i ].length() );
            } else {
              rawValue = part;
            }

            break;
          }
        }

        if ( log.isDebug() ) {
          logDebug( BaseMessages.getString( PKG, "FieldSplitter.Log.SplitInfo" ) + rawValue );
        }
      } else {
        rawValue = ( valueParts == null || i >= valueParts.length ) ? null : valueParts[ i ];
        prev += ( rawValue == null ? 0 : rawValue.length() ) + data.delimiter.length();

        if ( log.isDebug() ) {
          logDebug( BaseMessages
            .getString( PKG, "FieldSplitter.Log.SplitFieldsInfo", rawValue, String.valueOf( prev ) ) );
        }
      }

      Object value;
      try {
        ValueMetaInterface valueMeta = data.outputMeta.getValueMeta( data.fieldnr + i );
        ValueMetaInterface conversionValueMeta = data.conversionMeta.getValueMeta( data.fieldnr + i );

        if ( rawValue != null && valueMeta.isNull( rawValue ) ) {
          rawValue = null;
        }
        value =
          valueMeta.convertDataFromString( rawValue, conversionValueMeta, meta.getFieldNullIf()[ i ],
            meta.getFieldIfNull()[ i ], meta.getFieldTrimType()[ i ] );
      } catch ( Exception e ) {
        throw new KettleValueException( BaseMessages.getString(
          PKG, "FieldSplitter.Log.ErrorConvertingSplitValue", rawValue, meta.getSplitField() + "]!" ), e );
      }
      outputRow[ data.fieldnr + i ] = value;
    }

    return outputRow;
  }

  public synchronized boolean processRow( StepMetaInterface smi, StepDataInterface sdi ) throws KettleException {
    meta = (FieldSplitterMeta) smi;
    data = (FieldSplitterData) sdi;

    Object[] r = getRow(); // get row from rowset, wait for our turn, indicate busy!
    if ( r == null ) {
      // no more input to be expected...
      setOutputDone();

      return false;
    }

    Object[] outputRowData = splitField( r );
    putRow( data.outputMeta, outputRowData );

    if ( checkFeedback( getLinesRead() ) ) {
      if ( log.isBasic() ) {
        logBasic( BaseMessages.getString( PKG, "FieldSplitter.Log.LineNumber" ) + getLinesRead() );
      }
    }

    return true;
  }

  public boolean init( StepMetaInterface smi, StepDataInterface sdi ) {
    meta = (FieldSplitterMeta) smi;
    data = (FieldSplitterData) sdi;

    return super.init( smi, sdi );
  }
}