Delimited Data Record Functions

Use delimited data record functions to process delimited data with the list root field type. If you configured an origin to process the delimited data with the list-map root field type, you can use standard record functions.

Not valid in Data Collector Edge pipelines. Do not use delimited data record functions in Data Collector Edge pipelines.

For more information about the delimited data root field types, see Delimited Data Root Field Type.

You can replace any argument with a literal or an expression that evaluates to the argument. String literals must be enclosed in single or double quotation marks.

The expression language provides the following delimited data record functions:

record:dExists(<header name>): Determines if the specified header name exists in the record.; Return type: Boolean.
record:dHasDupHeader(): Determines if the record has duplicate header names.; Return type: Boolean.
record:dIndex(<header name>): Returns the index associated with the specified header name. Use to find the position of a header in the record.; Return type: Integer, starting with 0 for the first position.
record:dIsDupHeader(<header name>): Determines if the specified header name is used more than once in a record.; Return type: Boolean.
record:dToMap(): Converts a record with a List root field to a List-Map root field. Use to convert delimited List records to List-Map to allow easier use with standard record functions. For more information about root field types, see Delimited Data Root Field Type.; Return type: Records with a List-Map root field.; To use record:dToMap(), use a slash as the root output field as follows:
record:dValue(<header name>): Returns the value associated with the specified header name.; Return type: String.
record:dValueAt(<header index>): Returns the value at the specified header index position.; Return type: String.