Insert Decimal

[shrey3a]

Hi,

I've data from source file coming as
05500
04500

I need to insert the decimal place as 05.500 Iwas thinking of splitting the
column as Arg1[1,2]:'.':Arg1[3,3] is there is any built in or better way of doing it, I tried selecting scale in the plugin stage but it makes the data as 05500.000 ...looked in FMT function also but no help from there.

Regards,

[Raghumreddy]

Divide the number by 1000

Ans = Arg1/1000

Hope this helps.
Raghu

Hi,

I've data from source file coming as
05500
04500

I need to insert the decimal place as 05.500 Iwas thinking of splitting the
column as Arg1[1,2]:'.':Arg1[3,3] is there is any built in or better way of doing it, I tried selecting scale in the plugin stage but it makes the data as 05500.000 ...looked in FMT function also but no help from there.

Regards,

[kcbland]

Search the forum for OCONV. It has the necessary options for implied decimal conversion and rounding.

[chulett]

As does the FMT command.