Re: how to substitute ',' by '.' within awk script

From: Green, Simon (SGreen@KRAFTEUROPE.COM)
Date: Fri Jan 24 2003 - 04:46:08 EST


That would be better as it removes the need for extra processes to do the
translation, so it's more efficient.

Be aware that it may cause dates to be displayed differently; both the
default for the date command, and in ls -l output etc.

Simon Green
Philip Morris ITSC Europe

AIX-L Archive at http://marc.theaimsgroup.com/?l=aix-l&r=1&w=2
AIX FAQ at http://www.faqs.org/faqs/aix-faq/

N.B. Unsolicited email from vendors will seldom be appreciated.

> -----Original Message-----
> From: Jef Lee [mailto:jef.lee@ITVISION.COM.AU]
> Sent: 24 January 2003 01:17
> To: aix-l@Princeton.EDU
> Subject: Re: how to substitute ',' by '.' within awk script
>
>
> I think you LANG setting or NLS setting must be affecting
> this. I have read
> somewhere that in some places the decimal point is displayed
> as a comma.
> Perhaps in the shell script that runs the Awk script, you
> could put in:
>
> LANG=C
>
> which is my setting. I get the 0.25 result not 0,25 as you do.
>
>
> -----Original Message-----
> From: Jarzombek, Svend [mailto:Svend.Jarzombek@ALCOA.COM]
> Sent: Thursday, 23 January 2003 11:09 PM
> To: aix-l@Princeton.EDU
> Subject: how to substitute ',' by '.' within awk script
>
>
> Content of $4 is 0.500
> $4 *= 0.5 results in 0,25 and leads to an additional value in
> VALUES clause
> of INSERT statement (SQL).
> 0.25 is needed as result to INSERT into database correctly.



This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 22:16:31 EDT