use an export variable as part of filename in awk program

Question

I have set an export X25DATAF=/home/Bob/X25/Datafiles in my profile and that's what is outputted when I do a echo $X25DATAF.

I want to replace /home/Bob/X25/Datafiles in the awk below with the $X25DATAF in the 2 places it's in the awk program. But, I can't get it to work (ie: $X25DATAF/ALL_SW_DB.txt). This way all I have to do is set the export to the path on whichever system I'm on to run this awk program (and others like it).

awk -F"\t" ' 
FILENAME=="Sites1" {
  cllina[$0]=$0
}
FILENAME=="/home/bob/X25/DataFiles/ALL_SW_DB.txt" {
  swclli=hostclli=""
  swclli=substr($7,1,8)
  hostclli=substr($3,1,8)
  fclli[hostclli]++
  fclli[swclli]++

  if(hostclli==cllina[hostclli]) {
    if(swclli!=hostclli) {
      printf"REM|%s|%s|%s|%s|%s|%s|%s|%s|%s-%s\n",hostclli,$4,$3,$6,$9,$7,$12,$13,$5,$14 >>"host_remote"
    }
   }

  if(swclli==cllina[swclli]) {
      printf"HOST|%s|%s|%s|%s|%s|%s|%s|%s|%s-%s\n",swclli,$4,$3,$6,$9,$7,$12,$13,$5,$14 >>"host_remote"
    }
 }
 END{
  for(x in cllina)
    if(fclli[x]=="") printf"%s\n",x >"site1.err"
}' Sites1 /home/bob/X25/DataFiles/ALL_SW_DB.txt

Answer 1

As usual the construction FNR==NR (file row number is equal whole row number) is used for 1st file and next operation to skip 2nd file instructions:

awk -F'\t' -v OFS='|' '
    FNR==NR{
        cllina[$0]=1
        next
    }
    {
        swclli=hostclli=""
        …
        fclli[swclli]++
    }
    cllina[hostclli] && swclli!=hostclli{
        print "REM",hostclli,$4,$3,$6,$9,$7,$12,$13,$5,$14
    }
    cllina[swclli]{
        print "HOST",swclli,$4,$3,$6,$9,$7,$12,$13,$5,$14
    }
    …
    }' Sites1 /home/bob/X25/DataFiles/ALL_SW_DB.txt >>host_remote

or see comments to your question.

Answer 2

This is a simpler example. I want to replace the 2 instances of /home/Bob/X25/DataFiles with the export of X25DATAF (export X25DATAF=/home/Bob/X25/DataFiles) I have in my profile. If I can get it to work in this simple awk, I can modify my real awk.

$ cat test1
test1_data
test1a_data
test1b_data

Bob@Bob-PC ~/X25/Scott/TEST/TEST1

$ cat /home/Bob/X25/DataFiles/test2
test2_data

Bob@Bob-PC ~/X25/Scott/TEST/TEST1

$ cat gettestfiles

File 1test11 has 3 records test1_data, test1a_data and test1b_data and is in same dir that awk is run in.

File test2 only has 1 record test2_data and is in the /home/Bob/X25/DataFiles directory.

awk -F"_" '
FILENAME=="test1" {
  print $1 " " $2
}
FILENAME=="/home/bob/X25/DataFiles/test2" {
print $0
}
END{ }' test1 /home/bob/X25/DataFiles/test2

Bob@Bob-PC ~/X25/Scott/TEST/TEST1

$ gettestfiles
test1 data
test1a data
test1b data
test2_data

Bob@Bob-PC ~/X25/Scott/TEST/TEST1

$