DSXchange

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.

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)

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

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.