4.91 sign - Sign

Format : sign( $num$ )

Determine the sign of $num$ . Returns 0 if zero, 1 if positive, -1 if negative.

Example

Example 1: Basic Example

$ more dat1.csv
id,val
1,5
2,-5
3,
4,0
$ mcal c='sign(${val})' a=rsl i=dat1.csv o=rsl1.csv
#END# kgcal a=rsl c=sign(${val}) i=dat1.csv o=rsl1.csv
$ more rsl1.csv
id,val,rsl
1,5,1
2,-5,-1
3,,
4,0,0