DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
Marley777



Group memberships:
Premium Members

Joined: 27 Jan 2004
Posts: 311

Points: 2765

Post Posted: Tue Jul 24, 2012 12:33 pm Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: Parallel
OS: Unix
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



Joined: 14 May 2012
Posts: 88

Points: 619

Post Posted: Tue Jul 24, 2012 1:11 pm Reply with quote    Back to top    

You can use field or Index function in Transformer.
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 39347
Location: Denver, CO
Points: 200968

Post Posted: Tue Jul 24, 2012 1:27 pm Reply with quote    Back to top    

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

_________________
-craig

The moments seemed lost in all the noise, a snow storm, a stimulating voice
Of warmth of the sky, of warmth when you die
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours