awk (?) programming


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers awk (?) programming
# 1  
Old 07-18-2008
awk (?) programming

Hello

i need help with following problem:

i need to update a file containing records in following format:

student1
classa
student2
classb
student3
student4
classc

i need to associate EACH student with a class in my output file ... so for students 3 and 4, i need to create a new separate entries for each one.

here's how the output should look like..

student1
classa
student2
classb
student3
classc
student4
classc

i tried using awk, counters... i'm at a loss!!!

thanks
# 2  
Old 07-18-2008
Could you post your code?
# 3  
Old 07-18-2008
i don't have code that is working... the file contained much more data than above.. this is how i was able to sort it to extract only the relevant data, and now i need to create a separate record for each student in any class..
# 4  
Old 07-18-2008
I understand, what I'm asking you is to post your code so we can try to fix it.
It would be even better if you post a sample from your real original input file
(not only the sorted/extracted part).
# 5  
Old 07-18-2008
Quote:
Originally Posted by alrinno
i don't have code that is working... the file contained much more data than above.. this is how i was able to sort it to extract only the relevant data, and now i need to create a separate record for each student in any class..
We really don't do your homework for you.

If you have working code, please post it and someone might be willing to take a look.

It is against the rules to post homework here, BTW.
# 6  
Old 07-18-2008
okey dokey..

original file format:
:junk1
"student1"
:junk2
blah
blah
blah
:junk3
blah
blah
:junk4
"classa"
:junk1
"student2"
"student3"
:junk2
blah
blah
blah
:junk3
blah
:junk4
"classb"

i wrote an elementary code to create the output of only the student names and classes, without any of the junk...
awk '/:junk1/{
getline
count=0
FS="\""
split($0, arr1, FS)
split(arr1[2], arr2, " ")
if (NF > 1)
{
count ++
print arr2[1]" "arr2[2]":"count
}
count=count
getline
until ($0 == ":junk2")
# print $0
split($0, arr3, FS)
split(arr3[2], arr4, " ")
if (NF > 1)
{
count++
print arr4[1]" "arr4[2]":"count
getline
}
getline
while ($0 != ":junk4")
{
getline
}
getline
print $0
}' infile > tempout

so output of tempout now contains the following
student1 :1 (this is a counter)
"classa"
student2 :1
student3 :2
"classb"

i was hoping to use the coutner in some way to associate how many times the specified class will have to be repeated but i'm stuck!
# 7  
Old 07-18-2008
I'm sorry for offending anyone! i'm not trying to get easy help.. i'm really stuck!
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk programming -Passing variable to awk for loop

Hi All, I am new to AWK programming. I have the following for loop in my awk program. cat printhtml.awk: BEGIN -------- <some code here> END{ ----------<some code here> for(N=0; N<H; N++) { for(M=5; M<D; M++) print "\t" D ""; } ----- } ... (2 Replies)
Discussion started by: ctrld
2 Replies

2. Shell Programming and Scripting

awk programming

Need assistance using awk . Need assistance in awk programming. Any idea of getting the marked data into a file. </tr> <tr> <td class='labelOptional_ind'> cdr.00012325.0000000000000000.20130612.050005.WANP4722_csv </td> <td width='15%' class='labelOptional'> <div align='center'>... (8 Replies)
Discussion started by: ajayram_arya
8 Replies

3. Shell Programming and Scripting

AWK programming

Hi All, I read the AWK manual in the MAN page. But i didn't understand the below piece of code in the script TABLE=`echo "${FILE}" | awk -F"/" '{print $NF}' | cut -d"." -f1 | awk -F"_" '{print $NF}' 2>> ${LOGFILE}`; Please explain the above code. Thanks in advance ....... Regards,... (4 Replies)
Discussion started by: pdathu
4 Replies

4. Programming

awk programming

I have the list of numbers in a file 105.1 102.0 100.5 100 98 97.5 95 ... I want to get how many times I have numbers greater than a particular limit, say 100 in the list. How can I do that with awk command? (5 Replies)
Discussion started by: pranto_d
5 Replies

5. Shell Programming and Scripting

awk programming

Good morning to everyone! guys, help me please I have a file like this one: diamond 5 7.8 77777765 1 7 1234567890 9 3.5 diamond 2 1 1234567890 3 6.8 77777765 0 4 os Solaris it's only example, columns may be more, but in my case only 3 columns so, my question how I can group... (1 Reply)
Discussion started by: shizik
1 Replies

6. UNIX for Dummies Questions & Answers

awk programming

Good morning! guys, help me please I have a file like this one: diamond 5 7.8 77777765 1 7 1234567890 9 3.5 diamond 2 1 1234567890 3 6.8 77777765 0 4 os Solaris it's only example, columns may be more, but in my case only 3 columns so, my question how I can group according to... (1 Reply)
Discussion started by: shizik
1 Replies

7. Shell Programming and Scripting

awk programming

Hi I have a multi -line file which is sorted by the 1-st colomn in the following format: 400 0000 0001 1000 1010 0111 0000 1000 0000 402 1101 0000 1100 1010 0111 1000 1000 0000 403 1001 0000 1100 1010 0111 0000 1000 0000 495 1000 0000 1100 ... (4 Replies)
Discussion started by: aoussenko
4 Replies

8. Shell Programming and Scripting

need help with awk programming

Hello Friends I want to process only those lines which are not started with a * or " example File name: GRX "RxDataTime, NSysClkEn, Frame","Size","Sleep","TNum","TSet","TWait" *Init Start *Comment Generated from: C:\Documents and Settings 000000,0000,1,0,0,0,0,0,0... (8 Replies)
Discussion started by: user_prady
8 Replies

9. Shell Programming and Scripting

awk programming

Hi all, i want to study harder awk programming. where can i get a good examples, problems and solutions. i'm in a hurry.. thanks, (5 Replies)
Discussion started by: tungaw2004
5 Replies

10. Shell Programming and Scripting

awk programming

Hi folks, I would like to know the difference between shell programming and awk programming. Actually i have developed a few applications in both but i could not find a better difference other than the syntax differences. For example, the awk programming syntax is complicated. It has "{" and... (4 Replies)
Discussion started by: Nisha
4 Replies
Login or Register to Ask a Question