Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: AWK Programming Problem
Top Forums Programming AWK Programming Problem Post 302497055 by gator5242 on Wednesday 16th of February 2011 08:16:42 AM
Old 02-16-2011
AWK Programming Problem
I need development help with a AWK Program.

1
2
3 THIS IS THE INPUT FILE – EACH EMPLOYEE MAY HAVE FROM 1 TO 30 RECORDS
4 INPUT
5 1-4 Project
6 5-12 Employee
7 13-14 Sequence (MAYBE FROM 1 TO 30)
8 15-21 Work Code
9 22-22 Pri Code
10
11 9991|80100001|1|0389999|1|
12 9991|80100001|2|7070007|2|
13 9991|80100001|3|4912100|1|
14 9991|80100001|4|5990000|2|
15 9991|80100001|5|2500200|1|
16 9991|80100001|6|41401|2|
17 9991|80100001|7|515|1|
18 9991|80100001|8|4019|2|
19 9991|80100001|9|56210|1|
20
21 THIS IS THE OUTPUT (OPTION ONE)
22 ( NEED ONE CONTIGUOUS RECORD PER EMPLOYEE )
23 OUTPUT = project,employer, workcode,workcode,...,pricode, pricode,...
24 1586|80100001|0389999|7070007|4912100|599000|25002 00|41401|515|4019|56210|1|2|1|2|1|2|1|2|1|
25
26
27 THIS IS THE OUTPUT (OPTION TWO)
28 ( NEED ONE CONTIGUOUS RECORD PER EMPLOYEE WITH OUTPUT CONTAINING ROOM FOR 30 WORK CODES AND 30 PRI CODES )
29
30 1586|80100001|0389999|7070007|4912100|599000|25002 00|41401|515|4019|56210||||||||||||||||||||||1|2|1 |2|1|2|1|2|1||||||||||||||||||||||
31
thank for the help.



***
Please do not embed formatting of font/color/etc... when posting.


Input file:
Code:
9991|80100001|1|0389999|1|
9991|80100001|2|7070007|2|
9991|80100001|3|4912100|1|
9991|80100001|4|5990000|2|
9991|80100001|5|2500200|1|
9991|80100001|6|41401|2|
9991|80100001|7|515|1|
9991|80100001|8|4019|2|
9991|80100001|9|56210|1|

Output 1:
Code:
1586|80100001|0389999|7070007|4912100|599000|25002 00|41401|515|4019|56210|1|2|1|2|1|2|1|2|1|

Output 2:
Code:
1586|80100001|0389999|7070007|4912100|599000|25002 00|41401|515|4019|56210||||||||||||||||||||||1|2|1 |2|1|2|1|2|1||||||||||||||||||||||

Last edited by joeyg; 02-16-2011 at 09:53 AM.. Reason: Pulled out input & output files and wrapped with CodeTags
 

10 More Discussions You Might Find Interesting

1. 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

2. Programming

C programming + problem with char arrays

Im trying to write some code atm which gets the complete pathname of a folder and strips off references to the parent folders. The end result should be just the name of the folder. Currently Im able to extract the folder name, however Im getting junk added onto the name as well which is making... (7 Replies)
Discussion started by: JamesGoh
7 Replies

3. UNIX for Dummies Questions & Answers

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... (12 Replies)
Discussion started by: alrinno
12 Replies

4. UNIX for Advanced & Expert Users

RS232 programming problem

Hi all I encountered a strange phenomenon when reading / writing to RS232 serial device (on my machine /dev/ttyS0) I have simple 2 processes: 1) process which WRITE characters from /dev/ttyS0 For example write the characters... (2 Replies)
Discussion started by: dudi.forum
2 Replies

5. Shell Programming and Scripting

Problem with awk programming

i want to calculate power of 10 as follows: coef=2.0588 ra1=$(awk 'BEGIN{print 10^$coef}') it gives a result 1 when, if i calculate ra1=$(awk 'BEGIN{print 10^2.0588}') it gives a result 114.499 what should i do? (2 Replies)
Discussion started by: SANGUINE
2 Replies

6. 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

7. Programming

Programming problem

Hi Everybody. I have an Ubuntu linux 10.04 os and want be able to use the website of intuit but it only runs on unix. Is there any way that I can put the needed drivers in this os since both linux/unix share some distinctive programs. If this is not possible how can I save the information that I... (1 Reply)
Discussion started by: mk631219
1 Replies

8. 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

9. Programming

Gcc openmp programming problem

Dear Linux users, I'm a noob at openmp, gcc and c programming. I can run my own openmp code in terminal with no problem, eg. gcc -fopenmp program.c -o program. But now I'm trying to compile and run another person's code, it contains a makefile and multiple .c and .h files. I don't know how to... (2 Replies)
Discussion started by: pigeon151
2 Replies

10. 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
All times are GMT -4. The time now is 03:45 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy