Format a negative number

Post by **admin** » Thu Aug 23, 2001 10:43 am

I have a source system that gives me a negative value like: 22122-

There is in DataStage, any function/format to convert this value in -22122?

Thanks in Advance,

NP

Post by **admin** » Thu Aug 23, 2001 11:06 am

Try something like

Iconv(input,"ML0M")

I havent tested this, but if it isnt quite right, check ou the help on Iconv

-----Original Message-----
From: Nuno Pimenta [mailto:nuno.pimenta@tmn.pt]
Sent: Thursday, 23 August 2001 8:43 PM
To: LIST-DataStage (E-mail)
Subject: Format a negative number

I have a source system that gives me a negative value like: 22122-

There is in DataStage, any function/format to convert this value in -22122?

Thanks in Advance,

NP

Post by **admin** » Thu Aug 23, 2001 10:00 pm

Iconv(number, "MD0-") will do it.

The "MD" conversion (see BASIC Reference Guide) also handles other forms of negative number, such as appended "CR" or "DB", or notation.

-----Original Message-----
From: Nuno Pimenta [mailto:nuno.pimenta@tmn.pt]
Sent: Thursday, 23 August 2001 20:43
To: LIST-DataStage (E-mail)
Subject: Format a negative number

I have a source system that gives me a negative value like: 22122-

There is in DataStage, any function/format to convert this value in -22122?

Thanks in Advance,

NP