Extracting value from an input

sumesh.abraham · Post by **sumesh.abraham** » Thu Apr 05, 2007 12:56 am

Hi All,

I've an input value which is numeric. I want to check whether the third digit of the input is 1 or not using the derivation. Which DataStage function can be used for this. As per my knowledge, DataStage has many string functions, but how to work with a numeric input.

Thanks,
Sumesh

smrutiranjannayak · Post by **smrutiranjannayak** » Thu Apr 05, 2007 2:57 am

Hi ,

Let suppose you have :

Columnname Data
Emp_id 1234567

As per ur qs you need the third number from left and want to check whther that is 3 or not ?

Use this :

If Substrings(Emp_id,3,1) = "3" Then x Else y .

Cheers

sumesh.abraham · Post by **sumesh.abraham** » Thu Apr 05, 2007 4:42 am

It worked!! Thanks Smruti.

chulett · Post by **chulett** » Thu Apr 05, 2007 6:29 am

It worked because everything is a string under the covers in Server.

smrutiranjannayak · Post by **smrutiranjannayak** » Thu Apr 05, 2007 7:14 am

Can you just guide me how we can handle this scenarion in px since i worked in server only......

Thanks n cheers

ray.wurlod · Post by **ray.wurlod** » Thu Apr 05, 2007 7:41 am

Exactly the same logic, but you need to convert the integer to a string before using the substring function.

DSXchange

Extracting value from an input

Extracting value from an input

You can use the below mentioned functions

Hey Hullett....