Convert Negative number in round braces ()

[satheesh_color]

Hi All,

I have to convert the negative numbers into positive value with braces [()].

Eg:1

Input Output
-13.90 <13.90>

Eg2:

Input Output
<-13.90> (13.90)

Please let me know you thoughts on this.


Thanks,
Satheesh

[Sainath.Srinivasan]

That appears more a presentation requirement. aka reporting.

[ray.wurlod]

Check out the "MD" conversions for Iconv() and Oconv() in the DataStage BASIC manual. They can manage these kinds of conversion, though I might observe that having a "-" inside angle brackets is very unusual.

[battaliou]

if index(StageVar,'-',1) > 0 then '(' :Convert(StageVar,'()','') :')' else StageVar