Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Passing key column from parent to child records

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Passing key column from parent to child records
# 1  
Old 06-02-2016
Passing key column from parent to child records
Hi Forum.

I have this challenging issue that I'm hoping someone can help me.

I have a file that contains 3 different types of segments (AM00, AM01, AM32) in a hierarchy structure and I want to be able to pass the column key from the parent record to the children records.

AM00 - parent key: suffix# (underlined last column)
AM01 - parent key: card# (underlined last column)


Code:
Input data:
AM00,1,12345
AM01,ab,677
AM32,10

AM01,cd,789
AM32,20
--
AM00,2,23456
AM01,ef,654
AM32,30

AM01,gh,765
AM32,40



Code:
Output data:
AM00,1,12345
AM01,ab,677,12345
AM32,10,12345,677

AM01,cd,789,12345
AM32,20,12345,789
--
AM00,2,23456
AM01,ef,654,23456
AM32,30,23456,654

AM01,gh,765,23456
AM32,40,23456,765

Thank you for all your help.
# 2  
Old 06-02-2016
Before we can help, please show us your attempts to solve the problem and where you are stuck.
# 3  
Old 06-02-2016
I was actually thinking of reading each record and preserving each key for the segment and writing that key to the subsequent child record but that might be too slow since I will be dealing with a large file and in the future, I can have more than 3 segments.

If you have any ideas that you can suggest to get me started.

Thank you.
# 4  
Old 06-02-2016
Code:
awk -F, '$1=="AM00" {n=$NF;print;next} NF && !/--/ {$(NF+1)=n}1' OFS=, myFile

This User Gave Thanks to vgersh99 For This Post:
pchang
# 5  
Old 06-02-2016
How about

Code:
awk '/AM00/ {SUFFIX = $NF} /AM01/ {CARD = $NF; $0 = $0 FS SUFFIX} /AM32/ {$0 = $0 FS SUFFIX FS CARD} 1' FS=, file3
AM00,1,12345
AM01,ab,677,12345
AM32,10,12345,677

AM01,cd,789,12345
AM32,20,12345,789
--
AM00,2,23456
AM01,ef,654,23456
AM32,30,23456,654

AM01,gh,765,23456
AM32,40,23456,765

This User Gave Thanks to RudiC For This Post:
pchang
# 6  
Old 06-03-2016
Thank you guys - your solution works great.

---------- Post updated 06-03-16 at 10:18 AM ---------- Previous update was 06-02-16 at 04:31 PM ----------

I just found out that I will be working with fixed width files instead of comma delimited and here's my code so far:

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

How do I reset the SUFFIX variable back to Null after processing each record?

I tested on a sample file and it seems that SUFFIX = "99" is being written to all AM01 records regardless if substr($0,13,4)=="AM00" from the parent record.

Thank you.

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

0000000000001AM00 1500895700000000000199
000000000001AM01 035000000000013000399820810000000P

Output Data:
000000000001AM00 1500895700000000000199
000000000001AM01 035000000000013000399820810000000P99

0000000000001AM00 1500895700000000000199
000000000001AM01 035000000000013000399820810000000P99

Second AM01 output record should not have SUFFIX of 99.
# 7  
Old 06-03-2016
Why not? Its AM00 record HAS suffix 99, too! Except that the record is shifted right by one position; should the suffix be 19, then?
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