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
Extracting value from an input
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 153
- Joined: Thu May 11, 2006 1:52 am
- Location: Bangalore
-
- Participant
- Posts: 22
- Joined: Mon Apr 02, 2007 4:02 am
- Location: MUMBAI
- Contact:
You can use the below mentioned functions
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
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
Smrutiranjan Nayak
-
- Participant
- Posts: 153
- Joined: Thu May 11, 2006 1:52 am
- Location: Bangalore
-
- Participant
- Posts: 22
- Joined: Mon Apr 02, 2007 4:02 am
- Location: MUMBAI
- Contact:
Hey Hullett....
Can you just guide me how we can handle this scenarion in px since i worked in server only......
Thanks n cheers
Thanks n cheers
Smrutiranjan Nayak
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: