Find String

[ppavani_km]

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.

[Minhajuddin]

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)

[rameshrr3]

You can also use the

Code: Select all

AsInteger

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

int32_from_decimal()

[ppavani_km]

Thanks Minhajuddin it is working.

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.