Awk displays file name twice (?!)


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Awk displays file name twice (?!)
# 1  
Old 02-16-2011
Awk displays file name twice (?!)

Greetings.

I have files that contains eleven fields in the file name. Each file has a specific meaning. My job is to list each file name and load the info into a database table for reporting.

My awk code does this (files have VER suffix):

Code:
    find . -name "*.VER" -exec ls '{}' ';' -printf %f\\t | awk -F"~" '{print $1"\t"$2"\t"$3"\t"$4"\t"$5"\t"$6"\t"$7"\t"$8"\t"$9"\t"$10"\t"$0}' > somefile.tab

It works fine except that it does something weird with the file name ($0): it repeats it like so (the 2 last fields from the right):

Code:
    RRR1	PRE	DTV_PREP	PREP05	JGM15453.	26	P	H23-600	029416589165	20110216	RRR1~PRE~DTV_PREP~PREP05~JGM15453.~26~P~H23-600~029416589165~20110216~090353.VER	./RRR1~PRE~DTV_PREP~PREP05~JGMDTV269~33~P~H21-200~029384120357~20110216~091829.VER

What am missing here? Any ideas?

Thanks for your input.

---------- Post updated at 12:25 PM ---------- Previous update was at 12:11 PM ----------

I removed " -printf %f\\t " and replaced $0 with $filename. It works now but display "./" right before the filename. How can remove these two leading characters?
# 2  
Old 02-16-2011
Try removing -exec clause while leaving -printf.
# 3  
Old 02-16-2011
Quote:
Originally Posted by bartus11
Try removing -exec clause while leaving -printf.
Remove -exec and tweaked the printf() statement to add a newline character like so:

Code:
find . -name "*.VER" -printf %f\\n | awk -F"~" '{print $1"\t"$2"\t"$3"\t"$4"\t"$5"\t"$6"\t"$7"\t"$8"\t"$9"\t"$10"\t"$0}'

It worked like a charm. Thank you.
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Bash $(...) DISPLAYS EVERY COMMAND

I use things like this a lot in ksh and bash, but lately bash has been printing the command for every loop: ... | while read f do if then echo Differ "$f" fi done How to prevent this? (5 Replies)
Discussion started by: DGPickett
5 Replies

2. UNIX Desktop Questions & Answers

Cat/tac displays nothing but vi does

Hi, Today i have seen a file which shows nothing when i use cat/tac. But when i use vi it displays a single line at the top. There are no other lines. I am curious why cat/tac doesn't display that line and only vi does? Any thoughts? Thanks in advance, (1 Reply)
Discussion started by: pandeesh
1 Replies

3. UNIX for Dummies Questions & Answers

script works well but displays " line 6: =: No such file or directory"

strange :) can you tell why?:cool: #!/bin/bash echo " enter your age " read age if ; then echo " you do not have to pay tax " elif ]; then echo " you are eligible for income tax " else echo " you dont have to pay tax " fi (3 Replies)
Discussion started by: me.
3 Replies

4. Solaris

ls -l displays output with an error

when i use ls command it works normal but when i using additional parameter with ls like ls -l , ls -a... it shows a error followed by the output. # ls -l ./hgfs: Operation not applicable total 12861 -rw-r--r-- 1 root root 0 Jun 1 21:12 1 drwxr-xr-x 2 root root ... (4 Replies)
Discussion started by: chidori
4 Replies

5. UNIX for Dummies Questions & Answers

ls -l displays size in KB, MB, GB?

Hi, ls -l displays the long listing of a file in 8 fields. Query: ------ Does ls -l display the filename size in KB or MB or GB? -rwxrwxr-x 1 xx dba 655 May 22 06:27 time Here 655 is KB or MB or GB? Many thanks. (2 Replies)
Discussion started by: venkatesht
2 Replies

6. UNIX for Dummies Questions & Answers

Creating a file that contains output from a command, and then displays itself

hey, I'm trying to create the command that will create a file named user.txt that contains the output of the command cut -d: -f1,5 /etc/passwd, and displays itself afterwards. I don't know how to bridge cat > user.txt with cut -d: -f1,5 /etc/passwd, or how display it afterwards. Any help would... (2 Replies)
Discussion started by: raidkridley
2 Replies

7. AIX

who -r displays no output

Hello. I have an AIX machine at 6100-00. We had some strange activity since filling up /tmp. One symptom is that who -r displays no output. It doesn't hang just no output is displayed. We are going to boot the machine, but prior to that I'd like to dig a bit to see what may be causing the... (0 Replies)
Discussion started by: maficdan
0 Replies

8. HP-UX

Dual Displays HP-UX 10.20

Hello All! Where I work we have C3600's that have a video cards that have both DVI and Regular RBG type monitor ports on them. My question is: is it possible to spread my desktop across two monitors that are plugged into the one card much like you can do with NVIDIA software like NVIEW for... (0 Replies)
Discussion started by: giftedone
0 Replies

9. UNIX for Dummies Questions & Answers

Dual Displays

I have a TV and a monitor hooked up to my box. Right now the system is displaying all the information on the TV instead of the monitor, obviously I want to switch this, as the TV is very impracticle for everything other than watching movies. I thought I remembered a command I used to use that... (2 Replies)
Discussion started by: Synbios
2 Replies
Login or Register to Ask a Question

Featured Tech Videos