Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Need to change format of number
Top Forums Shell Programming and Scripting Need to change format of number Post 302352549 by cfajohnson on Friday 11th of September 2009 08:03:02 PM
Old 09-11-2009
Quote:
Originally Posted by bakunin
I don't know why you want to do it with awk,

Because that's the logical tool to use. One look at the sed code should convince anyone that sed is not the right tool.
Quote:
I'd prefer doing it with sed:

Code:
sed 's/,/:/g
     :loop
     /[0-9]\{4\}/ {
          s/\([0-9]\)\([0-9]\{3\}[.,:]\)/\1,\2/g
          b loop
     }'


For me, that script hangs indefinitely with the given input.


---------- Post updated at 08:03 PM ---------- Previous update was at 07:54 PM ----------
Quote:
Originally Posted by pgop
Hi,

using a shell script to get values from a CSV
eg:

12345.67,5678990.89,76232882.90
12345,5678990.89,76232882


Need the format of these numbers to change to

12,345.67:5,678,990.89:76,232,882.90
12,345:5678990.89:76232882

Using nawk on solaris, to parse these values, need the final data to be presented in the above format.

Why is the transformation different for the second line? Is it supposed to put thousands separators only in the first number of the second line?

Code:
nawk -F, 'BEGIN { OFS = ":" }

function commas(n) {
 if ( n < 1000 ) return n
 gsub(",","",n)
 point = index(n,".") - 1
 if (point < 0) point = length(n)
 while (point > 3) {
         point -= 3
         n = substr(n,1,point) "," substr(n,point + 1)
         }
 return n
}

## PATTERN { $1 = commas( $1 ); next }

{
  for (n = 1; n <= NF; ++n) $n = commas($n)
  print
}'

If some lines are to be treated differently (i.e., only add commas to the furst field), uncomment the PATTERN line and change PATTERN to whatever will catch those lines.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

change the empty function from the old format to the new format

I have about 300 files which has the function getDBBackend(). How to write a program to change the empty function from the old format to the new format? Old empty function format are either: function getDBBackend() { // Not available } // getDBBackend or: function... (0 Replies)
Discussion started by: powah
0 Replies

2. UNIX for Dummies Questions & Answers

How to change it to the date format

Hi, I want to know how to change this string to date format 20061102122042 to 02-11-2006 12:20:42 or 02-Nov-2006 12:20:42 Please let me know at the earliest.Thanks in advance. Regards, Preetham R. (3 Replies)
Discussion started by: preethgideon
3 Replies

3. UNIX for Advanced & Expert Users

Change date format

I know the command date +"%Y%m%d" can change today's date to digit format as below . $date +"%Y%m%d" 20071217 it works fine . now I want to do it back . If I have a file like below, (in the file , there are three lines, and each line have ; sign , after the ; sign is the date ) , I... (4 Replies)
Discussion started by: ust
4 Replies

4. Shell Programming and Scripting

Change of date format

I want to chnage the date format from the file format like below to WT;T15D;0000007208;;20080401;3;0;0;3;;B;ZZZZZZ; WT;T25D;0000007208;;20080401;6;0;0;6;;B;ZZZZZZ; WT;T5D;0000007208;;20080401;123;0;0;123;;B;ZZZZZZ; to WT;T15D;0000007208;;04/01/200804;3;0;0;3;;B;ZZZZZZ;... (2 Replies)
Discussion started by: svenkatareddy
2 Replies

5. Shell Programming and Scripting

Change date format

Hi guys, I have a text file with lots of lines like this: MCOGT23R27815 27/07/07 27/05/09 SO733AM0235 30/11/07 30/11/10 NL123403N 04/03/08 04/03/11 0747AM7474 04/04/08 04/04/11 I want to change each line so the date format looks like this: MCOGT23R27815 07/07/27 09/05/27 ... (7 Replies)
Discussion started by: Tornado
7 Replies

6. Shell Programming and Scripting

format change

I have a text file sample.txt which contains some details like Order 9001 Item Code 34 Quantity 4 Entry Date 2009-04-23 Ordered by Ram Order 9002 Item Code 34 Quantity 3 (1 Reply)
Discussion started by: lazydev
1 Replies

7. Shell Programming and Scripting

Date Format Change

Hi, Please can I have some command to get yesterday in YYMMDD format? This will be used in ksh Thanks, (2 Replies)
Discussion started by: smalya
2 Replies

8. Shell Programming and Scripting

Change Date Format

Hi Guys, I had a scenario like this.. It seems very silly...dont think it as a home work question.....:) i tried it many ways but i didn't achieve this... start_date=May122011 here i want to change the start_date in to 20110512 start_date=20110512 tell me how can we achive... (5 Replies)
Discussion started by: apple2685
5 Replies

9. Shell Programming and Scripting

Format change

I wish to convert the following in shell. Help me SED or AWK ID= 12345,23456,67859 , 90225 , 67583 I can extract the right hand side of "=" using cut command "cut -d "=" -f2 after extracting that right side i would need like this '12345','23456','67859','90225','67583' 1 ) the... (2 Replies)
Discussion started by: ilugopal
2 Replies

10. Shell Programming and Scripting

Change name format

I am trying to use either awk or sed to make names like J. A. Smith and J.A. Martin Smith become JA Smith and JA Martin SmithThe code should concatenate abbreviated letters that have a dot after them. I have only been able to do this: echo $name | sed 's/\.\ //g'But that concatenates the... (3 Replies)
Discussion started by: locoroco
3 Replies

LEARN ABOUT DEBIAN

printwait

MESSAGES(3)						  libbash messages Library Manual					       MESSAGES(3)

NAME

     messages -- libbash library that implements a set of functions to print standard status messages

SYNOPSIS

     printOK	 [indent]
     printFAIL	 [indent]
     printNA	 [indent]
     printATTN	 [indent]
     printWAIT	 [indent]

DESCRIPTION

   General
     messages is a collection of functions to print standard status messages - those [ OK ] and [FAIL] messages you see during Linux boot process.

     The function list:
	   printOK	    Prints a standard [ OK ] message (green)
	   printFAIL	    Prints a standard [FAIL] message (red)
	   printNA	    Prints a standard [ N/A] message (yellow)
	   printATTN	    Prints a standard [ATTN] message (yellow)
	   printWAIT	    Prints a standard [WAIT] message (yellow)

     Detailed interface description follows.

   indent
     Column to move to before printing.

     Default indent is calculated as TTY_WIDTH-10. If current tty width can not be determined (for example, in case of serial console), it
     defaults to 80, so default indent is 80-10=10

FUNCTIONS DESCRIPTIONS

   printOK [indent]
     Prints a standard [ OK ] message (green)

   printFAIL [indent]
     Prints a standard [FAIL] message (red)

   printNA [indent]
     Prints a standard [ N/A] message (yellow)

   printATTN [indent]
     Prints a standard [ATTN] message (yellow)

   printWAIT [indent]
     Prints a standard [WAIT] message (yellow)

EXAMPLES

     Run a program named MyProg, and report it's success or failure:

	      echo -n 'Running MyProg...'
	      printWAIT
	      if MyProg ; then
		      printOK
	      else
		      printFAIL
	      fi

AUTHORS

     Hai Zaar <haizaar@haizaar.com>
     Gil Ran <gil@ran4.net>

SEE ALSO

     ldbash(1), libbash(1)

Linux								       Epoch								     Linux
All times are GMT -4. The time now is 12:23 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy