Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: reply amount to another format
Top Forums Shell Programming and Scripting reply amount to another format Post 302110404 by mona on Monday 12th of March 2007 10:41:58 PM
Old 03-12-2007
Hope this helps

Code:
$ awk -F"," '{gsub(/ .00/,"0.00",$7);gsub(/ .00/,"0.00",$8);print $1","$2","$3","$4","$5","$6","$7","$8}' tmp.txt
RECORD ID,CLIENT,CUSTOMER NAME,2883,12:05,8, 16.39, 191.34
RECORD ID,CLIENT,CUSTOMER NAME,2879,00:00,0,0.00,0.00
RECORD ID,CLIENT,CUSTOMER NAME,2873,00:00,0,0.00,0.00
RECORD ID,CLIENT,CUSTOMER NAME,2871,00:00,0,0.00,0.00
RECORD ID,CLIENT,CUSTOMER NAME,2865,00:00,0,0.00,0.00
RECORD ID,CLIENT,CUSTOMER NAME,2858,00:00,0,0.00,0.00
RECORD ID,CLIENT,CUSTOMER NAME,2876,00:00,0,0.00,0.00
RECORD ID,CLIENT,CUSTOMER NAME,2863,00:00,0,0.00,0.00
RECORD ID,CLIENT,CUSTOMER NAME,2868,00:00,0,0.00,0.00
RECORD ID,CLIENT,CUSTOMER NAME,2866,00:00,0,0.00,0.00
RECORD ID,CLIENT,CUSTOMER NAME,2864,00:00,0,0.00,0.00
RECORD ID,CLIENT,CUSTOMER NAME,2882,07:65, 11, 13.77, 160.80
RECORD ID,CLIENT,CUSTOMER NAME,2880,01:72,2,5.63, 65.76
RECORD ID,CLIENT,CUSTOMER NAME,2877,00:00, 18,4.63, 54.00
RECORD ID,CLIENT,CUSTOMER NAME,2874,00:00,2, .51,6.00
RECORD ID,CLIENT,CUSTOMER NAME,2870,01:65,1, .39,4.60
$ sed 's/ \.00/0.00/g' tmp.txt
RECORD ID,CLIENT,CUSTOMER NAME,2883,12:05,8, 16.39, 191.34
RECORD ID,CLIENT,CUSTOMER NAME,2879,00:00,0,0.00,0.00
RECORD ID,CLIENT,CUSTOMER NAME,2873,00:00,0,0.00,0.00
RECORD ID,CLIENT,CUSTOMER NAME,2871,00:00,0,0.00,0.00
RECORD ID,CLIENT,CUSTOMER NAME,2865,00:00,0,0.00,0.00
RECORD ID,CLIENT,CUSTOMER NAME,2858,00:00,0,0.00,0.00
RECORD ID,CLIENT,CUSTOMER NAME,2876,00:00,0,0.00,0.00
RECORD ID,CLIENT,CUSTOMER NAME,2863,00:00,0,0.00,0.00
RECORD ID,CLIENT,CUSTOMER NAME,2868,00:00,0,0.00,0.00
RECORD ID,CLIENT,CUSTOMER NAME,2866,00:00,0,0.00,0.00
RECORD ID,CLIENT,CUSTOMER NAME,2864,00:00,0,0.00,0.00
RECORD ID,CLIENT,CUSTOMER NAME,2882,07:65, 11, 13.77, 160.80
RECORD ID,CLIENT,CUSTOMER NAME,2880,01:72,2,5.63, 65.76
RECORD ID,CLIENT,CUSTOMER NAME,2877,00:00, 18,4.63, 54.00
RECORD ID,CLIENT,CUSTOMER NAME,2874,00:00,2, .51,6.00
RECORD ID,CLIENT,CUSTOMER NAME,2870,01:65,1, .39,4.60
$

 

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How to get amount of memory installed.

Hi! I'm not a UNIX fanatic but I like using it for the Oracle database since it's not stable in the Windows NT environment (what is?). Problem: Is there any command to show me the amount of installed physical-memory in the machine? Is there some other way to show the processes which uses... (4 Replies)
Discussion started by: elgholm
4 Replies

2. UNIX for Dummies Questions & Answers

Amount of RAM (Memory)

How do i check/get the total amount of RAM, on a machine running UNIX? (4 Replies)
Discussion started by: samudimu
4 Replies

3. UNIX for Dummies Questions & Answers

amount of memory in my server

Hi all, is there any command that i can execute to find out the size of the harddisk and RAM on my server? Because i am not the SA, i do not have access to such infomation. (2 Replies)
Discussion started by: new2ss
2 Replies

4. UNIX for Dummies Questions & Answers

count amount of accounts?

Hi, I am relatively new to Unix and trying to understand as much as I can. I would like to know if it's possible to count the total number of Unix accounts? If so, can the count be done from any working directory or does it have to be specific to where the accounts are based? Thanks! (4 Replies)
Discussion started by: Trogan
4 Replies

5. Shell Programming and Scripting

How to format a character to look like an amount -solved

Hi All, I want to format the retrieved varchar2 value in the database to $9,999,999,990.00 but remained as a character value. Is it possible? Example: 378273.23 to $378,273.23 below is the code i want to implement: sqlplus -s ${USERNAME}/${PASSWORD}@${ORACLE_SID} << END1 >> $LOGFILE... (0 Replies)
Discussion started by: ryukishin_17
0 Replies

6. Shell Programming and Scripting

How to format sql result as amount - ksh

I am currently returning an sql result with a number value that I want to format as an amount. The sql runs smoothly on its own, but when run inside my ksh script an error is encountered: ERROR at line 3: ORA-01481: invalid number format model My sql is -- select distinct ... (6 Replies)
Discussion started by: avillanueva
6 Replies

7. UNIX for Dummies Questions & Answers

Is it possible to grep a certain amount of characters?

I have a file similar to the following filler filler filler car 6 mazda filler filler filler filler car civic honda car rav 4 toyota filler filler If i do a "grep -i car file.txt" the output would be car 6 mazda car civic honda car rav 4 toyota however, i want to have the... (4 Replies)
Discussion started by: jl487
4 Replies

8. UNIX for Dummies Questions & Answers

Sum of an amount columns

Hi Friends.. I'm completely new to Unix and I need to write a program / script to sum amount columns in a .DAT file by using a configuration file to read the position of the columns. Could someone pls. help me on how to proceed? I've never written a program to read a configuration file and... (3 Replies)
Discussion started by: davinds
3 Replies

9. Shell Programming and Scripting

Max amount of parameter

Hello everyone, I am trying to write a ksh script to accept user amount of parameters. so far I have written the following but, when I run the script it gives me the "i" back instead of the parameter's value. can anyone please tell me what I'm doing wrong. Thank you in advance:):) ... (9 Replies)
Discussion started by: Joveini
9 Replies

LEARN ABOUT CENTOS

locale::recodedata::iso_2033_1983

Locale::RecodeData::ISO_2033_1983(3)			User Contributed Perl Documentation		      Locale::RecodeData::ISO_2033_1983(3)

NAME

       Locale::RecodeData::ISO_2033_1983 - Conversion routines for ISO_2033_1983

SYNOPSIS

       This module is internal to libintl.  Do not use directly!

DESCRIPTION

       This module is generated and contains the conversion tables and routines for ISO_2033-1983.

COMMENTS

       The following comments have been extracted from the original charmap:

	version: 1.0
	repertoiremap: mnemonic,ds
	 source: ECMA registry
	alias ISO-IR-98
	alias E13B

       Please note that aliases listed above are not necessarily valid!

CHARACTER TABLE

       The following table is sorted in the same order as the original charmap.  All character codes are in hexadecimal.  Please read 'ISO-10646'
       as 'ISO-10646-UCS4'.

	Local | ISO-10646 | Description
       -------+-----------+-------------------------------------------------
	   00 |  00000000 | NULL (NUL)
	   01 |  00000001 | START OF HEADING (SOH)
	   02 |  00000002 | START OF TEXT (STX)
	   03 |  00000003 | END OF TEXT (ETX)
	   04 |  00000004 | END OF TRANSMISSION (EOT)
	   05 |  00000005 | ENQUIRY (ENQ)
	   06 |  00000006 | ACKNOWLEDGE (ACK)
	   07 |  00000007 | BELL (BEL)
	   08 |  00000008 | BACKSPACE (BS)
	   09 |  00000009 | CHARACTER TABULATION (HT)
	   0A |  0000000A | LINE FEED (LF)
	   0B |  0000000B | LINE TABULATION (VT)
	   0C |  0000000C | FORM FEED (FF)
	   0D |  0000000D | CARRIAGE RETURN (CR)
	   0E |  0000000E | SHIFT OUT (SO)
	   0F |  0000000F | SHIFT IN (SI)
	   10 |  00000010 | DATALINK ESCAPE (DLE)
	   11 |  00000011 | DEVICE CONTROL ONE (DC1)
	   12 |  00000012 | DEVICE CONTROL TWO (DC2)
	   13 |  00000013 | DEVICE CONTROL THREE (DC3)
	   14 |  00000014 | DEVICE CONTROL FOUR (DC4)
	   15 |  00000015 | NEGATIVE ACKNOWLEDGE (NAK)
	   16 |  00000016 | SYNCHRONOUS IDLE (SYN)
	   17 |  00000017 | END OF TRANSMISSION BLOCK (ETB)
	   18 |  00000018 | CANCEL (CAN)
	   19 |  00000019 | END OF MEDIUM (EM)
	   1A |  0000001A | SUBSTITUTE (SUB)
	   1B |  0000001B | ESCAPE (ESC)
	   1C |  0000001C | FILE SEPARATOR (IS4)
	   1D |  0000001D | GROUP SEPARATOR (IS3)
	   1E |  0000001E | RECORD SEPARATOR (IS2)
	   1F |  0000001F | UNIT SEPARATOR (IS1)
	   20 |  00000020 | SPACE
	   30 |  00000030 | DIGIT ZERO
	   31 |  00000031 | DIGIT ONE
	   32 |  00000032 | DIGIT TWO
	   33 |  00000033 | DIGIT THREE
	   34 |  00000034 | DIGIT FOUR
	   35 |  00000035 | DIGIT FIVE
	   36 |  00000036 | DIGIT SIX
	   37 |  00000037 | DIGIT SEVEN
	   38 |  00000038 | DIGIT EIGHT
	   39 |  00000039 | DIGIT NINE
	   3A |  00002446 | OCR BRANCH BANK IDENTIFICATION
	   3B |  00002447 | OCR AMOUNT OF CHECK
	   3C |  00002448 | OCR DASH
	   3D |  00002449 | OCR CUSTOMER ACCOUNT NUMBER
	   7F |  0000007F | DELETE (DEL)

AUTHOR

       Copyright (C) 2002-2009, Guido Flohr <guido@imperia.net>, all rights reserved.  See the source code for details.

       This software is contributed to the Perl community by Imperia (<http://www.imperia.net/>).

SEE ALSO

       Locale::RecodeData(3), Locale::Recode(3), perl(1)

POD ERRORS

       Hey! The above document had some coding errors, which are explained below:

       Around line 731:
	   =cut found outside a pod block.  Skipping to next block.

perl v5.16.3							    2014-06-10				      Locale::RecodeData::ISO_2033_1983(3)
All times are GMT -4. The time now is 12:45 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy