How to substrig delimited variable length fields

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Marley777
Premium Member
Premium Member
Posts: 316
Joined: Tue Jan 27, 2004 3:26 pm

How to substrig delimited variable length fields

Post by Marley777 »

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.
ankursaxena.2003
Participant
Posts: 96
Joined: Mon May 14, 2012 1:30 pm

Post by ankursaxena.2003 »

You can use field or Index function in Transformer.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

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

"You can never have too many knives" -- Logan Nine Fingers
Post Reply