Re: cannot get rid of decimal point

[Grant Chappell <gchappell@CARRERACONSULTING.COM>]

Use a text editor like Textpad, block highlight the column and so a search
and replace on the decimal.

At 04:41 PM 10/28/98 -0400, you wrote:
>Hi everyone,
>
>I am using Oracle and SQR.
>
>I m trying to create a flat file with values from the PeopleSoft table. One
>of the fields is numeric. I want it to look like 9(7)V99
>i.e without any decimal points and it should be left padded with zeros.(
>e.g 12.54 should look like 000001254)
>Then I move it to a character variable so that i can write it to the flat
>file.
>
>I tried using move #var to $var 0999999V99 but it gives me a decimal point
>and right pads it with zeros i.e
>12.54 looks like 12.5400000
>
>If any of you have suggestions, I would greatly appreciate it.
>
>Thanks in advance -Charu


GRANT CHAPPELL
CCG PeopleSoft Technical Consultant
CARRERA CONSULTING GROUP
PeopleSoft Global Alliance Partner
VOICE MAIL / PAGER (A/N)
(916) 328-2323
OFFICE
(916) 456-3300
FAX
(916) 456-3306
E-MAIL
gchappell@carreraconsulting.com <mailto:gchappell@carreraconsulting.com>
COMPANY WEBSITE
www.carreraconsulting.com <http://www.carreraconsulting.com>