Passing key column from parent to child records


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Passing key column from parent to child records
# 8  
Old 06-03-2016
if AM00 does not start in position 13 then I don't want to add any suffix to children records.
# 9  
Old 06-03-2016
Oh, I see - didn't jump to my eyes immediately.

If a "record separator" were a blank line, try e.g.
Code:
!NF {SUFFIX = ""};

to the begin of the one-liner.
# 10  
Old 06-03-2016
Thank you Rudy.

This is my code but it didn't quite work - suffix = 99 still showing up on the 2nd record:
Code:
awk '!NF {SUFFIX = ""}; substr($0,13,4)=="AM00" {SUFFIX = substr($0,38,2)} substr($0,13,4)=="AM01" {$0 = $0 FS SUFFIX} 1'  file

on a side note, is it possible to store substr($0,13,4) in a variable?

I tried this but it didn't work:
Code:
awk '!NF {SUFFIX = ""}; var1=substr($0,13,4) "$var1"=="AM00" {SUFFIX = substr($0,38,2)} substr($0,13,4)=="AM01" {$0 = $0 FS SUFFIX} 1'  file

# 11  
Old 06-03-2016
Is NF really zero (== EMPTY line, not even spaces in there)?

Assignment to a variable IS possible but should be done in an action part (i.e. within { and } )
# 12  
Old 06-03-2016
also...
"$var1"=="AM00" should be var1 == "AM00"
# 13  
Old 06-03-2016
This is my final code in an attempt to use variables:

Code:
awk 'rec_type1=substr($0,13,4) {$rec_type1=="AM00"} {SUFFIX = substr($0,38,2)} substr($0,13,4)=="AM01" {$0 = $0 FS SUFFIX} 1'  file

it's Not working as expected using variables

Code:
Input Data:
000000000001AM00 1500895700000000000100                                                                                     
000000000001AM01 035000000000013000399820810000000P 

Output Data:
000000000001AM00 1500895700000000000100                                                                                     
000000000001AM01 035000000000013000399820810000000P 98

it's grabbing SUFFIX = 98 for the current record, not from the previous one.

Please help.

Thank you.
# 14  
Old 06-03-2016
Please get accustomed to reading man awk!

awk works on pattern {action} pairs for every input record: execute action if pattern is TRUE.

Code:
awk '
rec_type1=substr($0,13,4)                       # assignment; wrong: usually an action
{$rec_type1=="AM00"}                            # comparison; wrong: should be used as a pattern or within an "if" construct; wrong: the $ in front of var
{SUFFIX = substr($0,38,2)}                      # action alone; executed for every record as missing pattern is assumed TRUE
substr($0,13,4)=="AM01" {$0 = $0 FS SUFFIX}     # correct pattern {action} pair!
1                                               # TRUE pattern; executes default action: print $0
'  file

This User Gave Thanks to RudiC For This Post:
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. IP Networking

Message passing from child to parent using pipes

Hi, I am trying my hand in networking programming in C, and got stuck in piping. I was following some tutorial and did the forking like : while (1) { newsockfd = accept(sockfd, (struct sockaddr *) &cli_addr, &clilen); if (newsockfd < 0) ... (4 Replies)
Discussion started by: abhi1988sri
4 Replies

2. UNIX for Dummies Questions & Answers

parent and child directory

does anyone know how to check in an 'if' statement if a particular directory is a child directory of a particular directory? help ~ (2 Replies)
Discussion started by: ymc1g11
2 Replies

3. Shell Programming and Scripting

forking a child process and kill its parent to show that child process has init() as its parent

Hi everyone i am very new to linux , working on bash shell. I am trying to solve the given problem 1. Create a process and then create children using fork 2. Check the Status of the application for successful running. 3. Kill all the process(threads) except parent and first child... (2 Replies)
Discussion started by: vizz_k
2 Replies

4. Homework & Coursework Questions

Need help with deleting childīs parent and child subprocess

1. The problem statement, all variables and given/known data: I need to make an program that in a loop creates one parent and five children with fork(). The problem i'm trying to solve is how to delete the parent and child of the childīs process. 2. Relevant commands, code, scripts,... (0 Replies)
Discussion started by: WhiteFace
0 Replies

5. Programming

To share fd between parent and child

i used function fork(). so i made two process. parent process accepted socket fd and writing to shared memory. then now. how can child process share parent's socket fd? is this possible? Thanks in advance (1 Reply)
Discussion started by: andrew.paul
1 Replies

6. UNIX for Advanced & Expert Users

Child Killing Parent

Hi all, I am writing a script which calls other third party scripts that perform numerous actions. I have no control over these scripts. My problem is, one of these scripts seems to execute and do what it is meant to do, but my calling / parent script always exits at that point. I need to... (4 Replies)
Discussion started by: mark007
4 Replies

7. Shell Programming and Scripting

Passing a variable from a child script back to the parent

Hi I have written a script using ftp to get files from one server and copy them to 2 dirrerent servers. I wish to call this script from a parent script that will check the number of files copied and run a check sum for each file. As the filenames for the files in the get portion of the script... (3 Replies)
Discussion started by: Andy82
3 Replies

8. UNIX for Dummies Questions & Answers

kill parent and child

Hello all, I have gone through the search and looked at posting about idle users and killing processes. Here is my question I would like to kill an idle user ( which I can do) but how can I asure that all of his process is also killed whit out tracing his inital start PID. I have tried this on a... (4 Replies)
Discussion started by: larry
4 Replies

9. Filesystems, Disks and Memory

How hard can it be? ps child/parent

:( Since I'm fairly new to the scene and don't have much experience in shell programming, I decided to check out the net for a useful script or two. What I'm looking for is a script that would let me enter a PID and then show the process tree associated with it. So it would display the (grand-)... (2 Replies)
Discussion started by: velde046
2 Replies

10. UNIX for Dummies Questions & Answers

what are parent and child processes all about?

I don't follow what these are... this is what my text says... "When a process is started, a duplicate of that process is created. This new process is called the child and the process that created it is called the parent. The child process then replaces the copy for the code the parent... (1 Reply)
Discussion started by: xyyz
1 Replies
Login or Register to Ask a Question