Find String
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 11
- Joined: Mon Mar 17, 2008 3:14 pm
Find String
I have the input coloumn data as 24100.500,I need to change this coloumn as 24100 i.e i need to get only the characters that are before . symbol.can any body tell me what string function do we need use to get this.
-
- Participant
- Posts: 467
- Joined: Tue Mar 20, 2007 6:36 am
- Location: Chennai
- Contact:
The 'Field' function should be able to do this. I don't remember the syntax, But it has the delimiter, the field number and the input string as its arguments.
Field(ip.string,'.',1)
Field(ip.string,'.',1)
Minhajuddin
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
You can also use the Function. you may need to handle the possibility of nulls in input field.
You can keep the output column as data type Integer.
You can also use a modify stage with conversion specification using
Code: Select all
AsInteger
You can keep the output column as data type Integer.
You can also use a modify stage with conversion specification using
Code: Select all
int32_from_decimal()
-
- Participant
- Posts: 11
- Joined: Mon Mar 17, 2008 3:14 pm
Re: Find String
Thanks Minhajuddin it is working.
ppavani_km wrote:I have the input coloumn data as 24100.500,I need to change this coloumn as 24100 i.e i need to get only the characters that are before . symbol.can any body tell me what string function do we need use to get this.