how to convert string to int in modifystage
Moderators: chulett, rschirm, roy
how to convert string to int in modifystage
required syntax to covert string to integer using modifystage
-
- Participant
- Posts: 222
- Joined: Tue Aug 30, 2005 2:07 am
- Location: pune
- Contact:
Function to convert String to Integer
Hi,
The function for converting int16 to string as follows :
NewColumn:int 16 = lookup_int16_from_string(Old Column:String)
In case of remaining Integer type the convesrion from string to integer would be default i.e. No function required to convert String to Integer.
Regards
Nagesh.
The function for converting int16 to string as follows :
NewColumn:int 16 = lookup_int16_from_string(Old Column:String)
In case of remaining Integer type the convesrion from string to integer would be default i.e. No function required to convert String to Integer.
Regards
Nagesh.
NageshSunkoji
If you know anything SHARE it.............
If you Don't know anything LEARN it...............
If you know anything SHARE it.............
If you Don't know anything LEARN it...............
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
Yep, the lookup functions translate a list of strings into a specified set of integer values, you are better off with Ray's list of conversion functions.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Is int32_from_string and int16_from_string still available? I do not find it documented in version 7.5.1.ray.wurlod wrote:I would have thought some of the simpler functions, such as int16_from_string or int32_from_string, or uint32_from_string, would have been more appropriate. ...
When i tried to use int32_from_string in the modify stage i get the following error:
Error in binding: Unknown conversion: int32_from_string