grep variable replacement error - can't open file

[tekinfarmland]

this command works
CSTIME=$(grep "PA3.1" Jobcheck.tbl | cut -f2 -d',')

but when I replace the values with variables with same values
CSTIME=$(grep $JNAME $TBL | cut -f2 -d',')

I get "error can't open Jobcheck.tbl"

Am I missing special characters in the 2nd grep command?
Any help would be appreciated.

 

[tarn]

Maybe if you echo $JNAME and $TBL in your script you may find that you are not getting the value you expect in the variables ?

Or maybe try wrapping the $JNAME in quotes as you have in the top example?

IHTH

Laurie

 

[blarneyme]

On AIX 5.3 TL12 SP5 using ksh93 Version M-12/28/93e

# cat jobcheck.tbl
a,PA3.1,c,d
b,PA1.2,c,d
c,PA3.1,d,z

# cat d.sh
#!/bin/ksh93

TBL="/tmp/jobcheck.tbl"
JNAME="PA3.1"
CSTIME=$(grep $JNAME $TBL | cut -f2 -d',')
echo $CSTIME

# ./d.sh
PA3.1 PA3.1

 

[tekinfarmland]

Thanks, I tried the () idea and it did not work.

 

[blarneyme]

$ cat /etc/*release
Red Hat Enterprise Linux ES release 4 (Nahant Update 9)

$ cat jobcheck.tbl
a,PA3.1,c,d
b,PA1.2,c,d
c,PA3.1,d,z

$ cat d.sh
#!/bin/ksh

TBL="./jobcheck.tbl"
JNAME="PA3.1"
CSTIME=$(grep $JNAME $TBL | cut -f2 -d',')
echo $CSTIME

$ ./d.sh
PA3.1 PA3.1

 

[blarneyme]

# cat /etc/release
                        Solaris 8 6/00 s28s_u1wos_08 SPARC
           Copyright 2000 Sun Microsystems, Inc.  All Rights Reserved.
                             Assembled 26 April 2000

# cat jobcheck.tbl
a,PA3.1,c,d
b,PA1.2,c,d
c,PA3.1,d,z

# cat d.sh
#!/bin/ksh

TBL="./jobcheck.tbl"
JNAME="PA3.1"
CSTIME=$(grep $JNAME $TBL | cut -f2 -d',')
echo $CSTIME

# ./d.sh
PA3.1 PA3.1

 

[Annihilannic]

tekinfarmland, what shell, operating system and versions of both are you using?

Annihilannic
[small]tgmlify - code syntax highlighting for your tek-tips posts[/small]

 

[tekinfarmland]

Been away from this for awhile. My last work with unix shell was on HPUX about 8 years ago. How can I tell what shell version? OS is Solaris 10 10/09 s10s_u8wos_08a SPARC

 

[Annihilannic]

Well, just knowing which shell it is would be enough, i.e. the output of ps -fp $$.

Does your test like the ones by blarneyme above still yield different results?

Annihilannic
[small]tgmlify - code syntax highlighting for your tek-tips posts[/small]

 

[tekinfarmland]

looks like it is ksh
$ ps -fp $$
UID PID PPID C STIME TTY TIME CMD
leroy 3625 3633 0 06:34:49 pts/1 0:00 -ksh

 

[PHV]

Anyway, why not simply this ?

CSTIME=$(awk -F, "/$JNAME/"'{print $2}' $TBL)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[tekinfarmland]

no, the awk version did not work.
"awk: can't open ./Jobcheck.tbl"

 

[PHV]

Seems like Jobcheck.tbl is not in the current directory.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[tekinfarmland]

exactly that is the odd problem. Jobcheck.tbl IS in the same directory as the the file executing (Jobcheck.ksh). and both files are set to 7777.

 

[PHV]

I'd put a cd command in Jobcheck.ksh

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SamBones]

What's the ownership and permissions on [tt]jobcheck.tbl[/tt]?

Look for non-printable characters in the file name. Try this...

ls -lb *jobcheck.tbl*

Did you create or edit any of your scripts on a PC? If so, this can introduce extra EOL characters at the end of lines. This can mess things up. If you edit the file in [tt]vi[/tt] you should be able to see them. Or use the [tt]unix2dos[/tt] command to remove them.

 

[tekinfarmland]

all good replies. I seem to have isolated the issue down to just the grep part.
original command:
JNAME=PA3.1
TBL=Jobcheck.tbl
CSTIME=$(grep $JNAME $TBL | cut -f2 -d',')

simple command:
Jobcheck.tbl contains "PA3.1,0,0,0,20"
echo $JNAME
CSTIME=$(grep $JNAME Jobcheck.tbl)
I echo $JNAME before the command and receive "PA3.1"
After, I echo $CSTIME and receive an empty string, like grep did not find anything. Is there something I am missing in my grep statement?

 

[blarneyme]

# ./d.sh
JNAME PA3.1
CSTIME 0
# cat d.sh
#!/bin/ksh

TBL=./jobcheck.tbl
JNAME=PA3.1
echo JNAME $JNAME
CSTIME=$(grep $JNAME $TBL | cut -f2 -d',')
echo CSTIME $CSTIME
# ./d.sh
JNAME PA3.1
CSTIME 0
# cat /etc/release
                        Solaris 8 6/00 s28s_u1wos_08 SPARC
           Copyright 2000 Sun Microsystems, Inc.  All Rights Reserved.
                             Assembled 26 April 2000
#

Two things.

1) Why don't you do what I have done and copy and paste what jobcheck.tbl contains and the contents of your script and the output of execution of the script?

2) After that, run your script with:

ksh -x ./myscript.ksh

So you can trace the execution.

 

[tekinfarmland]

Issue solved. my command now works in the script.
CSTIME=$(grep "$JNAME" "$TBL" | cut -f2 -d',')

My issue was unseen characters caused by the windows editor.
I removed them by using "dos2unix temp1.ksh temp2.ksh"

Thanks to everyone that replied.