Remove leading zero before decimal point

jarretj1 · Post by **jarretj1** » Tue Jul 30, 2013 12:10 am

I am having an issue after splitting a query into 2 ODBC stages that the result is now displaying -0.01 instead of -.01.

The same for 0.1 insead of .1

How can I remove the leading zero in front of the negative value as the TRIM is not working ???

ray.wurlod · Post by **ray.wurlod** » Tue Jul 30, 2013 12:14 am

Welcome aboard. The first question is "why?" The values are identical.

You can probably apply the Fmt() function to achieve what you require - read about this function in on-line Help or in the DataStage BASIC manual.

SURA · Post by **SURA** » Tue Jul 30, 2013 12:15 am

Consider the data type.

ray.wurlod · Post by **ray.wurlod** » Tue Jul 30, 2013 4:33 am

SURA wrote:Consider the data type.

There are no genuine data types in server jobs.

MrBlack · Post by **MrBlack** » Tue Jul 30, 2013 9:40 am

I would think all you would have to do is specific the data type as a Decimal and that would take care of your problem.

Other than that you'd have to do some fancy substringing to determine if there is only one character to the left of the decimal and if that character is a zero and if so then substring.

ray.wurlod · Post by **ray.wurlod** » Tue Jul 30, 2013 4:29 pm

What happens if you add 0 to the value? As a general rule DataStage BASIC returns the shortest possible string as the result of an arithmetic operation.

jarretj1 · Post by **jarretj1** » Tue Jul 30, 2013 5:04 pm

adding a zero did not work, Substringing technique of course is succesfull, and about to try the FMT command.

Thanks for the help

DSXchange

Remove leading zero before decimal point

Remove leading zero before decimal point

Re: Remove leading zero before decimal point

Re: Remove leading zero before decimal point