Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

awk and leading zeroes

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting awk and leading zeroes
# 1  
Old 09-26-2011
awk and leading zeroes
I have the following script that renames filenames like:
blah_bleh_91_2011-09-26_00.05.43AM.xls
and transforms it in:
91_20110926_000543_3_blih.xls
Code:
for a in *.xls;
do
b="$(echo "${a}" | cut -d '_' -f4)"
dia=`echo ${b} | cut -c9-10`
mes=`echo ${b} | cut -c6-7`
anio=`echo ${b} | cut -c1-4`
nueva_fecha="${anio}${mes}${dia}" 

c="$(echo "${a}" | cut -d '_' -f5)"
hora=`echo ${c} | cut -c1-2`
min=`echo ${c} | cut -c4-5`
seg=`echo ${c} | cut -c7-8`
nueva_hora="${hora}${min}${seg}" 

echo $a | awk -F_ '{ print "mv -v "$0" "$3"_"'${nueva_fecha}'"_"'${nueva_hora}'"_blih.xls" }' | bash

done

It works fine except in the particular case of the example. When the hour is "00.0x" it does not work properly.

Any thoughts?

Thanks!
# 2  
Old 09-26-2011
How about this:

Code:
ls *.xls | awk -F_ '
{
    nueva_fecha=substr($4,1,4) substr($4,6,2) substr($4,9,2)
    nueva_hora=substr($5,1,2) substr($5,4,2) substr($5,7,2)
    print "mv -v " $0 " " $3 "_" nueva_fecha "_" nueva_hora "_blih.xls" }'

This User Gave Thanks to Chubler_XL For This Post:
Tr0cken
# 3  
Old 09-26-2011
Quote:
Originally Posted by Tr0cken
It works fine except in the particular case of the example. When the hour is "00.0x" it does not work properly.

Any thoughts?

Thanks!
Thats because the leading 0s make it an octal number inside of awk and as you can guess...000543 in octal is 355 in decimal...besides why make it so tedious when a single awk command is enough for this...
Code:
echo *.xls | awk -F_ '{
    s=$0
    t="_blih.xls"
    gsub("-","",$4)
    gsub("[PAM.xls]","",$5)
    d=$3FS$4FS$5
    system("mv -v "s" "d""t)
}'

# 4  
Old 09-26-2011
Quote:
Originally Posted by Chubler_XL
How about this:

Code:
ls *.xls | awk -F_ '
{
    nueva_fecha=substr($4,1,4) substr($4,6,2) substr($4,9,2)
    nueva_hora=substr($5,1,2) substr($5,4,2) substr($5,7,2)
    print "mv -v " $0 " " $3 "_" nueva_fecha "_" nueva_hora "_blih.xls" }'


My thoughts exactly Smilie

I thought I'd toss in the reason why the O/P was having issues though. The source of the problem is the awk

Code:
awk -F_ '{ print "mv -v "$0" "$3"_"'${nueva_fecha}'"_"'${nueva_hora}'"_blih.xls" }'

nueva_hora contains 000543 which when placed on a command as a number, rather than as a string, is interpreted as an octal value and the leading zeros are 'absorbed.' To see this, run this simple awk:

Code:
awk ' BEGIN { print 000543 }'

Opening and closing the single quotes to insert shell variables helps to lead to this problem which is why doing that is one of my pet peeves. Assuming the awk being used is modern, then this code would have prevented the problem (though I still like Chubler_XL's solution better):

Code:
awk  -v n_hora="$nueva_hora" -v n_fecha="$nueva_fecha" -F_ '{ 
print "mv -v " $0 " " $3 "_" n_fecha "_" n_hora "_blih.xls" }'

This User Gave Thanks to agama For This Post:
Tr0cken
# 5  
Old 09-27-2011
Thank you guys!
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

awk printing leading tab in output

The awk below executes and produces the current output. it skips the header in row 1 and prints $4,$5,$6 and then adds the header row back. The problem is that it keeps the tailing tab and prints it in front of $1. I could add a pipe to remove the tab, but is there a better way to do it with on... (7 Replies)
Discussion started by: cmccabe
7 Replies

2. Shell Programming and Scripting

awk pad 1 column with leading zero if char > 12

Hello, I got a question. I have several csv files with lots of data in it and for the first column i have EAN codes. The problem that i am facing is that some of these codes have the leading 0 removed so they are 12 or less chars while a EAN code is (always?) 13 chars. For this i used a... (9 Replies)
Discussion started by: SDohmen
9 Replies

3. Shell Programming and Scripting

rename numbered files to numbered files with leading zeroes

Hi, I have some hundreds/thousands of files named logX.dat, where X can be any integer, and they are sequential, X ranges between 1 and any number: log1.dat log2.dat log3.dat log6.dat log10.dat ... log6000.dat I would like to rename them to scatter_params_0001.dat... (6 Replies)
Discussion started by: pau
6 Replies

4. Shell Programming and Scripting

awk to remove leading zeros for a hex number

Is it possible by using awk to remove leading zeros for a hex number? ex: 0000000011179E0A -> 11179E0A Thank you! (4 Replies)
Discussion started by: carloszhang
4 Replies

5. Shell Programming and Scripting

Remove leading zeroes in 2nd field using sed

Hi Forum. I tried searching the forum but couldn't find a solution for my question. I have the following data and would like to have a sed syntax to remove the leading zeroes from the 2nd field only: Before: 2010-01-01|123|1|1000|2000|500|1500|600|700... (18 Replies)
Discussion started by: pchang
18 Replies

6. Shell Programming and Scripting

sed not removing leading zeroes

I have th following file 0000000011 0000000001 0000000231 0000000001 0000000022 noow when i run the following command sed 's/^0+//g' file name I receive the same output and the leading zeroes are not removed from the file . Please let me know how to achieve... (4 Replies)
Discussion started by: asalman.qazi
4 Replies

7. Shell Programming and Scripting

insert leading zeroes based on the character count

Hi, I need add leading zeroes to a field in a file based on the character count. The field can be of 1 character to 6 character length. I need to make the field 14bytes. eg: 8351,20,1 8351,234,6 8351,2,0 8351,1234,2 8351,123456,1 8351,12345,2 This should become. ... (3 Replies)
Discussion started by: gpaulose
3 Replies

8. Programming

how to check and remove leading zeroes from the buffer using c program

Helo , I m writing small module of c.on RHEL 4 I have one buffer (for e.g. buffer = "002" now I want to check whethere buffer contains leading zeroes and if it contains leading zeroes then I want to remove all leading zeroes ( i.e. if buffer = "002" then I want to make buffer = "2") how... (1 Reply)
Discussion started by: amitpansuria
1 Replies

9. Shell Programming and Scripting

Add leading zeroes to numbers in a file

Hello, I am (trying) to write a script that will check to see how many users are logged on to my machine, and if that number is more than 60 I need to kill off all the oldest sessions that are over 60. So far I have been able to check how many users are on and now I am at the part where I have to... (3 Replies)
Discussion started by: raidzero
3 Replies

10. Shell Programming and Scripting

How to trim the leading zeroes in a Currency field ?

How do I trim the leading zeroes, and (+,-) in the currency field ? I have a text file. Your bill of +00002780.96 for a/c no. 25287324 is due on 11-06. Your bill of +00422270.48 for a/c no. 28931373 is due on 11-06. I want the O/P file to be like. Your bill of 2780.96 for a/c no. 25287324... (22 Replies)
Discussion started by: Amruta Pitkar
22 Replies
Login or Register to Ask a Question