Help with format a number in a file


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Help with format a number in a file
# 1  
Old 09-07-2007
Help with format a number in a file

Hey,

I have a file which starts each line with 6 digits followed bya colon:

090607:The rest of the line
091207:Also some text
091207:Here's some more text

And I want to reformat them into:

06-09-07:The rest of the line
12-09-07:Also some text
12-09-07:Here's some more text

I already split the file into three temporaty files with cut, but how do I join them?

Or is there another way to do this?

Thanx.
# 2  
Old 09-07-2007
Assuming there is no digit(s) in the second part (after Smilie, here is one solution from my side.

jsaikia@LOLA:~/prac$ cat fil2
090607:The rest of the line
091207:Also some text
091207:Here's some more text

jsaikia@LOLA:~/prac$ cat fil2 | sed 's/[0-9][0-9]/&-/g' | sed 's/-:/:/'
09-06-07:The rest of the line
09-12-07:Also some text
09-12-07:Here's some more text
# 3  
Old 09-07-2007
Quote:
Originally Posted by jaduks
jsaikia@LOLA:~/prac$ cat fil2
090607:The rest of the line
091207:Also some text
091207:Here's some more text

jsaikia@LOLA:~/prac$ cat fil2 | sed 's/[0-9][0-9]/&-/g' | sed 's/-:/:/'
09-06-07:The rest of the line
09-12-07:Also some text
09-12-07:Here's some more text
Since all lines start with 6 digits

Code:
sed -e "s/^\(..\)\(..\)\(.*\)/\2-\1-\3/g" in.txt

# 4  
Old 09-07-2007
Quote:
Originally Posted by vino
Since all lines start with 6 digits

Code:
sed -e "s/^\(..\)\(..\)\(.*\)/\2-\1-\3/g" in.txt

Yeah, Thanks.
That does exactly what I want.Smilie
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

how to format a number in bash

Say I have a number x=123, but I want to it be x=000123, because I need to use it in as a file name. thanks! (2 Replies)
Discussion started by: aerosols
2 Replies

2. OS X (Apple)

get file modification date in number format (yyyy mm dd hh mm ss)

How do i get the file modification date in number format (yyyy mm dd hh mm ss) i used ls -l pathname but month is still in text "Aug" and year and time is not allways shown. time is show if it is in this year. and year is shown if it is before this year. what do i need to get... (7 Replies)
Discussion started by: rvdokkum
7 Replies

3. Shell Programming and Scripting

awk:How to format a number?

Hello, I need to format a number..like 12900 should be printed as 12,900 and 1209 as 1,209 and so on. (Just like we do in excel). Can this be done in awk. any printf options we have?Please suggest me. Thanks! (8 Replies)
Discussion started by: vijay_0209
8 Replies

4. Shell Programming and Scripting

Need to change format of number

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... (10 Replies)
Discussion started by: pgop
10 Replies

5. Shell Programming and Scripting

Number/string format in bash

I would like to change the format of an integer type number adding zeros to the left of it in a script in bash. For example number=1 echo $number 00001 Thanks (3 Replies)
Discussion started by: josegr
3 Replies

6. Web Development

Need Number Format Help in PHP

I have a number coming into a php echo statement that looks like 0293 and i want to output it looking like 29.3 and for the life of me i cannot figure out how to do it with available php functions like number_format, sprintf, or printf. Sample Data: 0293 0304 0282 0310 1324 2000 ... (2 Replies)
Discussion started by: RacerX
2 Replies

7. Shell Programming and Scripting

number format in Perl

I try to read in a file and write out a new file with increased number at the end of each line. And I can set the initial value and increased constant from inputs. input file: text1 text2 text3 ... text100 if I set initial value is 10, and increased constant is 0.4 output file: text1... (3 Replies)
Discussion started by: jinsh
3 Replies

8. UNIX for Dummies Questions & Answers

how to number format a data file without using SED?

Hi I have a file which contains data (list of data) and I want to put a number with bracket 1) 2) 3) etc at the beginning of every successive line I can do it with SED and I can also do it using the nl route but am looking for a different method. I'm guessing I would need some sort of loop... (3 Replies)
Discussion started by: Cactus Jack
3 Replies

9. Shell Programming and Scripting

Number format conversion in UNIX

Hi All, I want to convert Scientific number format into normal number format using unix script or using any command of unix. e.g 1.55397e+09 into 1553970000 Thanks in advance Kamal (1 Reply)
Discussion started by: kamal_418
1 Replies

10. Shell Programming and Scripting

How to format number/string in ksh

Hi, How to format a number in ksh. For example x=RANDOM $$ I want x to be of 20 digits long, so if x = 12345 I want it to be left paded with 15 zeros. Thanks. (2 Replies)
Discussion started by: GNMIKE
2 Replies
Login or Register to Ask a Question