Re: right justify left zero fill



On Wed, 2 Nov 2005 13:24:02 -0800, Stan wrote:

>Hugo,
>If you don't mind, I have a variation on the last question. I have the same
>type field (decimal 9(15,2)) and the recipient of a conversion .txt file want
>to see just the meaningful digits, no decimals, no zero fill but does want to
>see a trailing minus sign for negative numbers. So they want to see 550.45
>as 55045 and -45.25 as 4525-.
>Should I be sending things like this or should I do a re-post?
>Thanks for understanding.

Hi Stan,

Sending like this is fine, though a repost might attract more eyes.
Generally, if the subject really changes, post a new message. If it's a
variation on the question, use a reply.

I see that Steve has already answered the question. I trust that his
reply is what you wanted.

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)
.



Relevant Pages

  • Re: Primary and secondary stress in pt-PT
    ... Zero! ... realised as a central vowel, which I assume is what you mean by "barred". ... Notice I'm proposing it as in variation with u. ... Except for I and the variant of u ...
    (sci.lang)
  • Re: appearance of a value arrived at by using CONCATENATE and ROUND
    ... A variation of this formula is used on other rows and I would the amounts ... line up in a column and all have one decimal, even if it is zero. ... the result of the above formula when rounded to 1 digit is $46M; ...
    (microsoft.public.excel.worksheet.functions)
  • Re: appearance of a value arrived at by using CONCATENATE and ROUN
    ... CONCATENATE("$",ROUND('G:\AOMBudget\Daily RFSR\DAILY RFSR ... A variation of this formula is used on other rows and I would the ... line up in a column and all have one decimal, even if it is zero. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: remove left-hand zeros
    ... >how can i remove leading zero in an char-field. ... Hi Robert, ... Best, Hugo ...
    (microsoft.public.sqlserver.programming)
  • Re: UDF and SQL2000 - Why doesnt this work?
    ... my marketing skills are way below zero. ... And yes - I do enjoy solving SQL problems. ... Best, Hugo ... (Remove _NO_ and _SPAM_ to get my e-mail address) ...
    (microsoft.public.sqlserver.programming)