DSXchange

Hi, thanks for reading.

Anyone know how to substring delimited variable length fields.

Want to do this in a transaformer

field1: '-' :field2: '-' :field3 = new field

all 3 fields are variable length. How can I in a down stream job pull just "field1"?


any help is greatly appreciated.

You can use field or Index function in Transformer.

Don't worry about Index(), the Field() function is there to do exactly what you need.