Re^4: Format, empty vars, and fixed-width records

You could handle number overflow like Excel does:

sub format_num { 
   my $s = sprintf('%5.2f', $_[0]);
   return length($s) > 5 ? 'XXXXX' : $s;
}
[download]

Comment on Re^4: Format, empty vars, and fixed-width records Download Code

Replies are listed 'Best First'.
Re^5: Format, empty vars, and fixed-width records by BrowserUk (Patriarch) on Apr 22, 2008 at 03:32 UTC
I guess that depends upon what the receiving program is expecting under those circumstances. Maybe something like '#Inf ' or '#-Inf' makes sense? Examine what is said, not who speaks -- Silence betokens consent -- Love the truth but pardon error. "Science is about questioning the status quo. Questioning authority". In the absence of evidence, opinion is indistinguishable from prejudice. "Too many [] have been sedated by an oppressive environment of political correctness and risk aversion."	[reply]

Replies are listed 'Best First'.

I guess that depends upon what the receiving program is expecting under those circumstances.

Maybe something like '#Inf ' or '#-Inf' makes sense?

Examine what is said, not who speaks -- Silence betokens consent -- Love the truth but pardon error.

"Science is about questioning the status quo. Questioning authority".

In the absence of evidence, opinion is indistinguishable from prejudice.