Awk problem


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Awk problem
# 1  
Old 10-19-2004
Data awk / shell

Hi, I am fairly new at using Unix / awks / shell.
I have created a file (using awk) which contains a list of application numbers of failed apps. From this list I want to know which file they originated from. To do this I must scan through dozens of other files which contain these application numbers to discover where they came from. This is where I am stuck!
Can somebody please help!
# 2  
Old 10-19-2004
Dan - please provide more information. OS and version - application(s) - file output from awk script - some info on the application numbers. Why you are "stuck" in searching through these files. There just isn't much info in what you posted so far to have anyone give you a clear answer.

Take a look at the man pages for find and egrep for possible help in your 'search'.
# 3  
Old 10-19-2004
>> OS and version - application(s)
I think its Tinyterm (?)
Sorry, but I thought it would all be about the same.

>> file output from awk script - some info on the application >> numbers.
They contain letters and numbers, 20 characters long

>>Why you are "stuck" in searching through these files.
Because I dont know how to do it!
As I said, I'm new to using awks.
The file I created consists of hundreds of application numbers.
Using this file, I need to check, one line at a time, which file it has come from. There are dozens of these files to look through. Each application number is within one of these files.
Hope this is now enough information.
Thanks for your help
# 4  
Old 10-19-2004
for appNum in `cat appNames.txt`
do
grep -l $appNum * 2>/dev/null

done



where appNames.txt contains list of appNames created by yr awk script;

In the above scripts * can be replaced by the some pattern
for dozens of files u are going to scan ;
# 5  
Old 10-21-2004
Awk problem

Hi, I'm using Unix on tinyterm. I have used an awk to produce a file containing dozens of application numbers (which contain max 20 chars). These numbers are on each line. What I need to do is check where each of these app numbers have come from. By this I mean which MACS file. There are hundreds of these MACS files which can be broken down using tar xvf to produce applic.txt - this is a pipe delimited file which contains numerous application numbers and details of the app. The application numbers do not have any patterns to them, ie they look like: D/54645-54 or 42548786, etc. I am stuck. I do whether or not to search the MACS pipe delimited file or first tar xvf it then search the pipe delimited applic.txt file. I also am having trouble getting the right code to do this. I think using a while may be best, "while not last line" or something similar (?). Please help me!
# 6  
Old 10-21-2004
Firstly, TinyTERM is just a terminal emulator, usually run under Windows.

To find your OS version, try "uname -a". To get your Shell "echo $SHELL" or "echo $0" at the prompt.

Anyway. We really need to see a sample of this file.

You can process files line-by-line with a while loop

Code:
# just prints out each line
while read line; do
  echo $line
  # put other processing here.
done < my_file_name

If your file is pipe delimited, and you want to say pull the fifth field out with awk, a simple one liner such as
Code:
awk 'BEGIN{ FS="|" } {print $5}' my_file_name

This will work as long as your "application number" is in the same field, consistently.

When you say where the application numbers "have come from" what do you mean?

How have you used "awk" to create the file?

We need a lot more information, and most importantly
1) A sample of the file
2) What you want to get out of the file (i.e. what output are you expecting?)

Cheers
ZB
# 7  
Old 10-21-2004
Threads merged - please don't post the same questions twice (read the rules). Keeping one thread on your problem will assist others in helping you - so they don't have to ask the same questions again and again. Please go back through the thread and answer the questions that were asked.
 
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