Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Problem in awk

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Problem in awk
# 1  
Old 06-07-2013
Problem in awk
how to rename files like

Code:
XFRRT_20130606203918_2496622_02.IDR

to

Code:
XFRRT_0001.IDR

also if there are a number of files and all we have to replace with

Code:
XFRRT_0002.IDR
XFRRT_0003.IDR
XFRRT_0004.IDR

Moderator's Comments:
Mod Comment Can you please stop using "Problem in awk" for subject titles, and STOP posting what has nothing to to with Redhat in the Redhat sub-forum, PLEASE.
Last edited by Scott; 06-07-2013 at 04:21 AM.. Reason: Comment
# 2  
Old 06-07-2013
On what basis are you renaming XFRRT_20130606203918_2496622_02.IDR as XFRRT_0001.IDR??

And is there any hint on the old file name to choose the seq# in the new file name?
# 3  
Old 06-07-2013
Is there any chance that files in the target directory will already exist in the new naming format? (I.e., do we have to worry about a new name conflicting with an already existing filename?)

(And, why in the world would you want to use awk for this rather than doing it in the shell?)
# 4  
Old 06-07-2013
i have used this script

Code:
#!/bin/bash -xv
for f in `ls -lrth XFR*|awk '{print $NF}'`
do
file=`echo $f|awk -F"_" '{print $1}'` # store filename without _[0-9] numbers
a=`echo $f|awk -F"_" '{print $NF}'` #store variable which I want to increment by 1
b=`echo $a|awk -F"." '{print $NF}'`
n=$(( b + 1 ))
mv $f XFRRT__"$n".IDR # renaming file with new _numbers[0-9]
done

but the problem is that it is renaming
Code:
XFRRT_20130606203918_2496622_02

to
Code:
XFRRT_3.IDR

but i want
Code:
XFRRT_03.IDR

can any one please help.
# 5  
Old 06-07-2013
Code:
#!/bin/bash

file=XFRRT_20130606203918_2496622_02.IDR
echo "original file name: $file"
ext=${file##*.}
echo $ext
file1=${file%.*}
prefix=$(echo $file1 | cut -d"_" -f1)
echo $prefix
num=$(expr $(echo $file1 | awk -F"_" '{print $NF}') + 1)
echo $num
echo "mv $file "$prefix"_$(printf "%0.2d" $num).$ext"

Output:
Code:
original file name: XFRRT_20130606203918_2496622_02.IDR
IDR
XFRRT
3
mv XFRRT_20130606203918_2496622_02.IDR XFRRT_03.IDR

# 6  
Old 06-07-2013
Your first post said you were trying to rename XFRRT_20130606203918_2496622_02.IDR to XFRRT_0001.IDR. In you most recent post you said you want to rename XFRRT_20130606203918_2496622_02 to XFRRT_03.IDR. So, do the files you want to rename end with ".IDR" or not? And in your first post you wanted 4 digit zero filled numbers; now you seem to want 2 digit zero filled numbers. Again, what is it (2, 4, or the same number of digits as appear after the last "_" in the source filename)? And the mv statement in your script includes "__" instead of "_", but your examples show one underscore. Again, what do you want?

And, I repeat: Do we have to worry about a new name conflicting with an already existing filename?
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk problem

Hi I have two columns and I would like to create a third column based on how many lines away from a value of 1 in column 2, for example I have 1,0 2,0 3,0 4,0 5,0 6,1 7,0 8,0 9,0 10,0 11,1 And I want an output (6 Replies)
Discussion started by: garethsays
6 Replies

2. Shell Programming and Scripting

awk problem

i have an email list in file.txt with comma separated line1 - FIELD1,pippo@gmail.com,darth@gmail.com line2 - FIELD2,pippo@gmail.com,darth@gmail.com,sampei@gmail.com output=(awk -F ',' -v var="$awkvar" '$1==var {print $2,$3,$4}' spreadsheet.txt)but awk delete some letters at the... (8 Replies)
Discussion started by: pasaico
8 Replies

3. Shell Programming and Scripting

awk problem - combining awk statements

i have a datafile that has several lines that look like this: 2,dataflow,Sun Mar 17 16:50:01 2013,1363539001,2990,excelsheet,660,mortar,660,4 using the following command: awk -F, '{$3=strftime("%a %b %d %T %Y,%s",$3)}1' OFS=, $DATAFILE | egrep -v "\-OLDISSUES," | ${AWK} "/${MONTH} ${DAY}... (7 Replies)
Discussion started by: SkySmart
7 Replies

4. UNIX for Dummies Questions & Answers

Little problem with AWK

I thought I had solved this problem but after testing the script I came to realize that it is not doing what I need. So, here it goes again. This is the code: awk '/\>/{F=$2; N=$3; split(FILENAME, A, "."); getline; x = ">"}{print ">" A"-" x++" "F" " N"\n" $0}' This is the input file: ... (5 Replies)
Discussion started by: Xterra
5 Replies

5. Shell Programming and Scripting

awk problem

Find the number of files with sizes > 100KB in /, /bin, /usr, /usr/bin and /usr/sbin directories and output them in a two column format with the name of the directory and the number of files. i tried with awk $>ls -lh | awk '/^-/ && $5 >= 100k {print $8 $5}' but it is not working pls tell... (3 Replies)
Discussion started by: abhikamune
3 Replies

6. Shell Programming and Scripting

Problem with awk awk: program limit exceeded: sprintf buffer size=1020

Hi I have many problems with a script. I have a script that formats a text file but always prints the same error when i try to execute it The code is that: { if (NF==17){ print $0 }else{ fields=NF; all=$0; while... (2 Replies)
Discussion started by: fate
2 Replies

7. Shell Programming and Scripting

Awk problem: How to express the single quote(') by using awk print function

Actually I got a list of file end with *.txt I want to use the same command apply to all the *.txt Thus I try to find out the fastest way to write those same command in a script and then want to let them run automatics. For example: I got the file below: file1.txt file2.txt file3.txt... (4 Replies)
Discussion started by: patrick87
4 Replies

8. Shell Programming and Scripting

problem using awk

Hi there every body I'm new to shell scripting and there is a problem facing me,, please look at the following piece of code: awk ' BEGIN{ FS="<assertion id=\1"; RS="<assertion id=\"2"}/<assertion id=\"1/{print FS$2 > "/home/ds2/test/output.txt"} ' filename all I wanna do is to... (6 Replies)
Discussion started by: senior_ahmed
6 Replies

9. Shell Programming and Scripting

Problem with AWK

Hi All, How can i store a value of the unix command executed in AWK with system command. devise=`cut -c1-3 dvgp.txt` I wrote this command in awk as awk'{ code= sprintf("devise=`cut -c1-3 dvgp.txt`"); system(code); }' Is this correct. can you please suggest me how the code can be... (1 Reply)
Discussion started by: krishna_gnv
1 Replies

10. UNIX for Dummies Questions & Answers

AWK Problem

Hi, I posted something here about this yesterday but I can't seem to find it. I needed help writting a script which would append a file with new lines after every so many charachters. Example: (my original flat file) L60 LETTER OF CREDIT 60 DAYS W00 ON RECEIPT WIRE TRANSFER W30 NET... (12 Replies)
Discussion started by: gseyforth
12 Replies
Login or Register to Ask a Question