Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Change in the file

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Change in the file
# 1  
Old 05-03-2017
Change in the file
Hi,

I have a file which has wrong time format and we want to correct it before we load it.

WRONG FORMAT : 93:0:00
CORRECT FORMAT :09:30:00

If you notice the 0 at the front is missing. Its the case always.
# 2  
Old 05-03-2017
Code:
echo "format : 93:0:00" | awk '{c=split($NF,a,":"); for (i=1;i<=c;i++) s=s sprintf(":%02d", a[i]); $NF=substr(s,2)} {print};'

Last edited by rdrtx1; 05-03-2017 at 12:28 PM..
# 3  
Old 05-03-2017
Quote:
Originally Posted by rdrtx1
Code:
cho "format : 93:0:00" | awk '{c=split($NF,a,":"); for (i=1;i<=c;i++) s=s sprintf(":%02d", a[i]); $NF=substr(s,2)} {print};'

It changed it to 93:00:00. i want it to be 09:30:00
# 4  
Old 05-03-2017
Code:
echo "format : 93:0:00" | awk '{gsub(":","",$NF); $NF=sprintf("%06d", $NF); for (i=1;i<=5;i+=2) s=s ":" substr($NF,i,2); $NF=substr(s,2)} {print};'

# 5  
Old 05-03-2017
Quote:
Originally Posted by rdrtx1
Code:
echo "format : 93:0:00" | awk '{gsub(":","",$NF); $NF=sprintf("%06d", $NF); for (i=1;i<=5;i+=2) s=s ":" substr($NF,i,2); $NF=substr(s,2)} {print};'

It gave me a syntax error
# 6  
Old 05-03-2017
Can you post the exact message?


--edit--
Try:
Code:
sed 's/\([0-9]\)\([0-9]\):\([0-9]:[0-9][0-9]\)/0\1:\2\3/g' file

--
On Solaris use /usr/xpg4/bin/awk rather than awk
Last edited by Scrutinizer; 05-03-2017 at 06:10 PM..
# 7  
Old 05-04-2017
Quote:
Originally Posted by Scrutinizer
Can you post the exact message?


--edit--
Try:
Code:
sed 's/\([0-9]\)\([0-9]\):\([0-9]:[0-9][0-9]\)/0\1:\2\3/g' file

--
On Solaris use /usr/xpg4/bin/awk rather than awk
Thanks, Worked fine.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

How to change name of the file with first line of the file which has some unwanted text in it?

I have a log file, which i have divided into 14 files using csplit, the file looks like below test-000000 test-000001 #and so on until 14 now I want all the 14 files generated to be renamed as the some part of test in first line of the file how can i eliminate the unwanted text? sample... (5 Replies)
Discussion started by: Sekhar419
5 Replies

2. Shell Programming and Scripting

Trying to take file numbers from a file, pass them to sed to change strings in corresponding lines

I have a bunch of file numbers in the file 'test': I'm trying the above command to change all the instances of "H" to "Na+" in the file testsds.pdb at the line numbers indicated in the file 'test'. I've tried the following and various similar alternatives but nothing is working: cat test |... (3 Replies)
Discussion started by: crunchgargoyle
3 Replies

3. Shell Programming and Scripting

Change the file name and copy old file content to new file names.

Hi, I have a files in a directory as below :- ls -1 mqdepth-S1STC02 proc-mq-S1STC01 proc-mq-S1STC02 proc-mq-S1STC03 Whereever i have S1STC i need to copy them into new file with file name S2STC. expected output :- ls -1 mqdepth-S2STC02 proc-mq-S2STC01 proc-mq-S2STC02... (3 Replies)
Discussion started by: satishmallidi
3 Replies

4. Shell Programming and Scripting

add line in file and change file name

HI I have 100 files in below folder:- /home/lkj/TEST File name like below undo_ARL01003_120907-155022.mos undo_ARL01006_120908-155042.mos i want replace one first line of each file to pt all i want change file name as below. ARL01003.mos ARL01006.mos Thanks (2 Replies)
Discussion started by: asavaliya
2 Replies

5. Shell Programming and Scripting

Help i want to change the data of one file and apend it into 2nd file.

Hi All, Please help i have written an ksh script, where i am actually take count of lines in one file and want to update this count to 2nd field of a new file and apend the this into an existing file. Note the below script is in for loop -------- I am apending few records in a file... (7 Replies)
Discussion started by: iamnoone
7 Replies

6. Shell Programming and Scripting

ksh; Change file permissions, update file, change permissions back?

Hi, I am creating a ksh script to search for a string of text inside files within a directory tree. Some of these file are going to be read/execute only. I know to use chmod to change the permissions of the file, but I want to preserve the original permissions after writing to the file. How can I... (3 Replies)
Discussion started by: right_coaster
3 Replies

7. Shell Programming and Scripting

how to change the current file processing to some other random file in awk ?

Hello, say suppose i am processing an file emp.dat the field of which are deptno empno empname etc now say suppose i want to change the file to emp.lst then how can i do it? Here i what i attempted but in vain BEGIN{ system("sort emp.dat > emp.lst") FILENAME="emp.lst" } { print... (2 Replies)
Discussion started by: salman4u
2 Replies

8. UNIX for Dummies Questions & Answers

How to change the file modification time of a file on nfs mount point

Hi I am accessing a file on nfs mounted device, after completing using of the file, i am tring to restore the access time and modification times of the file. So i got the previous modified time of the file using stat() function and trying to set the date and time for the file, To set these... (6 Replies)
Discussion started by: deepthi.s
6 Replies

9. Shell Programming and Scripting

Help to change value from a file.

How can I change the value of "INI_TEST" from "YES" to "NO" in the setup.ini file by command? $ cat setup.ini INI_START YES INI_END YES INI_TEST YES Thank u in advance! (15 Replies)
Discussion started by: GCTEII
15 Replies

10. UNIX for Dummies Questions & Answers

Help with multiple file rename - change case of part of file name

Hi there, I hope someone can help me with this problem : I have a directory (/var/www/file/imgprofil) which contains about 10000 JPG files. They have a naming convention thus : prefix-date-key-suffix.jpg they all have the prefix p-20050608- then AAAA is a 4 letter code the suffix is... (7 Replies)
Discussion started by: steve7
7 Replies
Login or Register to Ask a Question