Number Formatting

JezT · Post by **JezT** » Fri May 19, 2006 5:24 am

I am needing to convert two type of numbers within a DS Server job.

Firstly, I need to convert a number (e.g. 5.5) to the following format - NNNN.NNNN (in other words 5.5 would equal 0005.5000.

Secondly, I need to convert a number (e.e. 15.50) to the following format - NNNNNNNNNNNNNNNNNN (in other words 15.50 would equal 000000000000001550.

And finally, if my number is negative, how do I ensure that the '-' sign appears at the front ? I other words, -5.5 appears as -0005.5000 and not 000-5.5000.

Any suggestions ?

kumar_s · Post by **kumar_s** » Fri May 19, 2006 6:23 am

You are talking about the data type Decimal and Integer for you two cases in the order.

sb_akarmarkar · Post by **sb_akarmarkar** » Fri May 19, 2006 6:26 am

Use field and Concatenation

Thanks,
Anupam

kumar_s · Post by **kumar_s** » Fri May 19, 2006 6:29 am

Decimal has first bit as sign bit.

chulett · Post by **chulett** » Fri May 19, 2006 6:46 am

You can use the FMT function, check your online help. Off the top of my head there may not be a formatting option for a leading minus sign. If not, simply check if your value is < 0 and concatenate it on the front of your output field if so.

chulett · Post by **chulett** » Fri May 19, 2006 6:47 am

Forgot to mention that 'FMT' will handle both of your examples: the zero padding and the 'descaling' of the decimal point.

JezT · Post by **JezT** » Fri May 19, 2006 8:22 am

Thanks for the advice.

Have managed to sort out the 18 character field removing the decimal point but am having problems with the other issue.

Basically how to convert a value such as 72.19 to 0072.1900 or 0.03 to 0000.0300.

DSguru2B · Post by **DSguru2B** » Fri May 19, 2006 8:24 am

Use field along with the fmt function. Basically strip the contents before and after the decimal point, format it using the fmt function and then concatenate it back together. Not a very sleek solution but will get your things rolling.

chulett · Post by **chulett** » Fri May 19, 2006 8:27 am

Why not just 'format' it twice, inline the two calls? Seems like that would work...

JezT · Post by **JezT** » Fri May 19, 2006 8:59 am

I have used the following:

Code: Select all

Field(ResultsWrite2.LGD_CALC_VAL, ".", 1, 1)

and

Code: Select all

Field(ResultsWrite2.LGD_CALC_VAL, ".", 2, 1)

And for a value of 79.12 this gives me two values : 79 and 12.

When I then do

Code: Select all

Fmt(LGDFirst, "R'0'4")

where LGD is the StageVariable name for the first bit of code above, I get the following output :

'''''

And I was hoping to see 0079
Any ideas ?

DSguru2B · Post by **DSguru2B** » Fri May 19, 2006 9:33 am

the fmt code is

Code: Select all

Fmt(LGDFirst, "4'0'R")

chulett · Post by **chulett** » Fri May 19, 2006 10:04 am

Code: Select all

Fmt(Fmt(ResultsWrite2.LGD_CALC_VAL,"7'0'R"),"9'0'L")

kumar_s · Post by **kumar_s** » Sat May 20, 2006 5:07 am

Hi,
Is it not possible to read those numbers as decimal so that N.N will be automatically converted to NNNN.NNNN or whatever??

chulett · Post by **chulett** » Sat May 20, 2006 6:37 am

No. Remember the 'Server is typeless' mantra. And that the zeroes are not significant. So you need to explicitly 'format' them into a character field in order to preserve them.