Visit Our UNIX and Linux User Community


AWK problem


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting AWK problem
# 1  
Old 02-06-2002
AWK problem

im working on this file with awk and i need to input some number say 1 to 5 e.g
ID
1
2
3
4
5
ID
1
2
3
4
5
but only after my command from awk.

ive outputted the id from my file but cant get 1 to 5 listed this way

Thankyou for your help in advanced

Can anyone help

Smilie
# 2  
Old 02-06-2002
Can you give more information? What's in the file? Are you writing a script? (if so, in what shell?) What's the OS and version?


If you are trying to input manually from a script, check the man page on the read command.

If you are trying to get those numbers into a file echo "1" >> filename ; echo "2" >> filename...(check man page on a loop function like for or while)
thehoghunter
# 3  
Old 02-06-2002
basically i have a file with test result from an experiment each test has 5 results and they each have different properties that i want outputted on the same line.

The thing is i can output the experiment ids ok

id1
id2
id3
id4
id5

but cant get the 5 results underneath each id.

Im using unix and am writing the script in a bourne shell.
# 4  
Old 02-06-2002
You will need to post the script (or the portions dealing with the problem).
thehoghunter
# 5  
Old 02-06-2002
5 Staff doing 5 experiments im going to obtain the average for each member of staff

96000222 id
01 10
02 10
03 10
04 6
05 8
06 8
average = ?
96000124 id
01 8
02 11
03 2
04 0
05 0
06 0
average = ?
96000321 id
01 0
02 5
03 4
04 6
05 4
06 14
average = ?
96000123 id
01 10
02 2
03 2
04 9
05 8
06 5
average = ?
ect

The end result i would like would be their name followed by an average mark

staff1 average_mark
staff2 average_mark
staff3 average_mark
staff4 average_mark
staff5 average_mark


sorry for the confusion hope this helpsSmilie
# 6  
Old 02-06-2002
So where is the script?

(Does this seem like a course problem to any of you? I get the feeling someone is wanting me to write their script for them.)
thehoghunter
# 7  
Old 02-07-2002
I think possibly so... If the poster has a script, and posts it looking for someone to help troubleshoot, I would, but I wouldn't post example code in this case, unless it was very general.

Previous Thread | Next Thread
Test Your Knowledge in Computers #733
Difficulty: Medium
AmigaBASIC is a complied BASIC programming language implementation for the Amiga, designed and written by Microsoft.
True or False?

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

Featured Tech Videos