Substring function problem

[kaushal.kumar@igate.com]

Hi,

I am not able to use SUBSTR(DSLink149.INTFC_FILE_CATG,1,4).it seems we don't have substring function in 8.1.
I have to take first 4 char of INTFC_FILE_CATG field in my transformer stage.
Please advice which function i can use to get first 4 char from a field .

Thanks
Kaushal

[cherry]

Try this DSLink149.INTFC_FILE_CATG[1,4]

Regards
Cherry

[ray.wurlod]

Or Left(DSLink149.INTFC_FILE_CATG, 4) which is beautifully self-documenting.

[abhijain]

There is no SUBSTR function in Datastage 8.1

It is -DSLink149.INTFC_FILE_CATG[1,4]

[kaushal.kumar@igate.com]

thanku

[chulett]

You could always try using the substring operators - the square brackets - like so:

DSLink149.INTFC_FILE_CATG[1,4]

[ArndW]

I think one could use

Code: Select all

DSLink149.INTFC_FILE_CATG[1,4]

, too.

[ray.wurlod]

I still prefer to use the Left() function, for reasons already stated.

[armekal]

DSLink149.INTFC_FILE_CATG[1,4]