extract csv value

CSV Value Extractor

Version: 17.07

Supported Since: 17.07

What is CSV Value Extractor Processor?

CSV Value Extractor processing element can be used to extract a value in the CSV payload with the given zero-based row and column indexes. This processing element gives the functionality to extract the value by type String, Integer, or Double.

The CSV payload is expected to be in the RFC 4180 standard format.

In order to use this processing element, you must first select the CSV Message dependency from the processor list when you are creating an empty Ultra project. If you have already created a project, you can add this dependency via Component Registry. From Tools menu, select Ultra Studio → Component Registry and from the Processors list, select the CSV Message dependency

csv extract value outports

Out Ports

Next

The message will be sent to this outport if the payload transformation is completed successfully

On Exception

The message will be sent to this outport if the processing element failed to transform the payload due to some reason

Parameters

Row *

Basic

Zero-based index of the row

Column *

Basic

Zero-based index of the column

Variable Name *

Basic

Variable name to store extracted value from the message

Return Type

Basic

The return type of the value. CSV payload’s value can be converted to the following types,

  • STRING - Column values will be converted to String format.

  • INTEGER - Column values will be converted to Integer format.

  • DOUBLE - Column values will be converted to Integer

Sample Use Case

In the following use case, the requirement is to read a CSV file from a NIO File Ingress Connector extract a value from the CSV message payload and pass it to a custom processing element, perform some custom processing using the extracted value and finally deliver the message to a backend service via NIO HTTP Egress Connector

csv value extractor flow
In this topic
In this topic
Contact Us