Join not working properly


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Join not working properly
# 8  
Old 12-16-2013
What OS and what awk version do you use?
# 9  
Old 12-16-2013
Code:
# awk --version
GNU Awk 3.1.5

OS

Code:
Red Hat Enterprise Linux Server release 5.9 (Tikanga)

# 10  
Old 12-16-2013
Strange. gawk should know conditional assignments. Try
Code:
                         n= $NF+1; Sep=""
                         for (i=1; i<=C; i++) {$n=$n Sep T[I[i]]; Sep=","}}

This User Gave Thanks to RudiC For This Post:
# 11  
Old 12-16-2013
Quote:
Originally Posted by ritakadm
The error is the following with any subset of data, or for that matter any filename that i provide, it is not getting to the files at all.

Code:
awk: cmd. line:3: (FILENAME=file1 FNR=1) fatal: function `n' not defined

with code

Code:
awk     'NR==FNR {T[$1]=($1="")$0; next}
                        {C=split ($3,I,",")
                         n= $NF+1
                         for (i=1; i<=C; i++) $n=$n($n?",":"")T[I[i]]}
         1
        ' mt4.genenames.sorted.txt file1

I guess this line need correction, isn't it?
Code:
$n=$n($n?",":"")T[I[i]]}

This User Gave Thanks to Yoda For This Post:
# 12  
Old 12-16-2013
This time there are no errors but but output = input with no name appended

Code:
  awk     'NR==FNR        {T[$1]=($1="")$0; next}
                          {
                              C=split ($3,I,",")
                         n= $NF+1; Sep=""
                         for (i=1; i<=C; i++) {$n=$n Sep T[I[i]]; Sep=","}}
           1
        ' mt4.genenames.sorted.txt file1 | head

---------- Post updated at 05:39 PM ---------- Previous update was at 05:36 PM ----------

Quote:
Originally Posted by Yoda
I guess this line need correction, isn't it?
Code:
$n=$n($n?",":"")T[I[i]]}

I think the bracket after $n in that line makes it assume that n is a function.
# 13  
Old 12-16-2013
Try this
Code:
NR==FNR        {X=$1; $1=""; T[X]=$0; next}

This User Gave Thanks to RudiC For This Post:
# 14  
Old 12-16-2013
awesome !! seems to work perfectly now... will get back if I notice anything else..thank you so much !
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Expansion not working properly

I'm using an Ubuntu machine and expansion is not working properly. What would cause this? Do I need to check for any particular bash packages? $ ipcs -m | grep $USER | awk '{printf "%s ",$2}' $ ipcs -m | grep UNF | awk '{printf "%s ",$2}' 294912 1048577 425986 688131 786436 1245189... (14 Replies)
Discussion started by: cokedude
14 Replies

2. Shell Programming and Scripting

Why is sort not working properly here ?

Platform: RHEL 5.4 In the below text file I have strings like following. $ cat /tmp/mytextfile.txt DISK1 DISK10 DISK101 DISK102 DISK103 DISK104 DISK105 DISK106 DISK107 DISK108 DISK109 DISK110 DISK111 DISK112 DISK113 DISK114 (8 Replies)
Discussion started by: kraljic
8 Replies

3. UNIX for Dummies Questions & Answers

~c is not working properly with -r option

Hi There, --------- file1 ------- ~c asd@ac.com -------------- Now i am using below command cat file1|mailx -s " testing" -r " My Name" abc@tech.com (3 Replies)
Discussion started by: Tapan Sharma
3 Replies

4. Linux

rexec not working properly

Hi, I am trying to enable rexec to automate certain tasks(it has to be rexec, not ssh or any other due to the system environment), so after switching to linux, I followed the certain instructions that were laid out in the web. My operating system is fedora 17, so I first installed the... (1 Reply)
Discussion started by: wringer
1 Replies

5. Shell Programming and Scripting

mailx not working properly

I am using mailx command in my script to attach a file and send an email. I need to attach a csv file and send email to a mail id - I am using uuencode output.csv output.csv | mailx -s "test mail" xyz@abc.com This will send a mail with scrambled text in body. am i missing something ?... (4 Replies)
Discussion started by: Sriranga
4 Replies

6. UNIX for Advanced & Expert Users

Sendmail is not working properly

Hi All, Can any one help me to solve the issue. The Issue is, i have started the sendmail service on my RHEL 4 update 6 box, I am able to send the mail from my box to almost all of the Email Id's except few. Exampe, test mail. . Output is :the message is sent. now if I send the... (2 Replies)
Discussion started by: akhtar.bhat
2 Replies

7. Shell Programming and Scripting

\n not working properly

Hi all, I'm trying to generate a series of txt files starting from a plain csv file part of my code: #!/bin/ksh INSTALLDIR=/Users/ME/Installdir CSV=CSV.csv TMP=/tmp/$(basename $0).txt tr -s "\r" "\n" < /$INSTALLDIR/$CSV > $TMP function Makefiles { printf '%24s:%30s\n' "sometext"... (1 Reply)
Discussion started by: Jive Spector
1 Replies

8. HP-UX

FC card not working properly

Hi I've a problem with Hp-ux 11.11 9000/800/rp3440 system. Already the software for driver & its patch are loaded for HBA Fibrechannel card, but still the fibrechannel card is showing the status "Unclaimed" . What will be reason for this? How to get the status "Claimed" ? Pl. help me out.... (4 Replies)
Discussion started by: Mike1234
4 Replies

9. Programming

y is this not working properly?

#include <stdio.h> #include <sys/types.h> #include <string.h> #include <sys/stat.h> #include <unistd.h> struct stat s; main() { char c; if (fork()==0) { system("clear"); do { printf("myAI\\>§ "); scanf("%s",c); if(stat(c,&s)>-1) {... (3 Replies)
Discussion started by: C|[anti-trust]
3 Replies

10. UNIX for Dummies Questions & Answers

Keyboard not working properly...

Hello Again, Those that have noticed my earlier posts will know that I have succesfully installed Solaris 8 onto my pc. I haven't been able to get x-server working (i think it doesn't like my video card) though I've been able to log into root (with a bit of help from unix forums :o ) and have... (2 Replies)
Discussion started by: timresh
2 Replies
Login or Register to Ask a Question