SubStr Function

sampitke1 · Post by **sampitke1** » Tue Jul 15, 2008 7:09 pm

Hi

Can you please let me know which function in DataStage is like SUBSTR function in ORACLE?

Requirement: Source and Target is Sequential File

Input Data : 123456.1234578
Output Data: 456.12

Logic Cut String from 4th Character to 10th Character (including Decimal)

Can you please let me know how can I achieve this in DataStage?

Thanks
Sameer

ray.wurlod · Post by **ray.wurlod** » Tue Jul 15, 2008 7:20 pm

It's done with square bracket notation if you are using a Transformer stage. Syntax is string[start,length] so, in your case,

Code: Select all

InLink.TheString[4,6]

There is also a substring function for the Modify stage if you are preferring to use that. Beware, though, that counting in the Modify stage is zero-based whereas in the Transformer stage it is one-based.

sampitke1 · Post by **sampitke1** » Wed Jul 16, 2008 7:41 am

Thanks Ray.I tried the String Function however it is not working.
I am not able to see your email completely.

Please let me know if there is any function / workaround for this.

chulett · Post by **chulett** » Wed Jul 16, 2008 8:11 am

There's no "string" function - you use the square brackets with your string field to substring it.

sampitke1 · Post by **sampitke1** » Wed Jul 16, 2008 8:36 am

Thanks chulett for your reply. This challenge has been resolved now.

sampitke1 · Post by **sampitke1** » Wed Jul 16, 2008 8:37 am

Thanks chulett for your reply. This challenge has been resolved now.

DSXchange

SubStr Function

SubStr Function

SubStr : Cut String