I am facing issue with UNZONE function
My Input value is "123N" and the Output should be "-1235"
So i have taken the input field as Number Zoned and Sign Yes and Output i have taken as Number Integer and sign Yes
And in the output field mapping rule i mapped like
But its returing the output like 1235 its not returing the output with signed symbol
Any one please let me know how can i get the exact output
Re: UNZONE FUNCTION2012-10-08T06:15:36ZThis is the accepted answer. This is the accepted answer.Hi,
Take ur input as Text and output as Number type integer with Sign leading(-).Then try the unzone function in the output u will get the result as expected "-1235".
Re: UNZONE FUNCTION2012-10-12T06:07:21ZThis is the accepted answer. This is the accepted answer.
- SystemAdmin 110000D4XK
thanks for reply.
suppose my input is -123 and now the output should return -123
will this scenario works
and i have one more scenario
This is the input "123N" and the output is -12.35
how can i do this thanks