Convert String to Number or Integer format

[nikhilchandra]

Hi Experts

May i know which function to use to convert string value in to Integer or Number format?

[nikhilchandra]

@Mizső  but i am getting null output, as the input value is a string.

[krzysztof_hoja]

toLong() conversion function , but the string being parameter needs to be a valid number, otherwise you will get null

data 
  record(s="1"),
  record(s="1.2"),
  record(s="a")
| fieldsAdd i=toLong(s), d=toDouble(s)