Shell Programming and Scripting

I follow your suggestion

name=$(pgsql -c "select name from teacher")
name=${name% (*}
echo "${name#*- }"

I got
"name"
"------------"
" Mary Lee "
"(1 row)"

Any ideas? Thanks again!!

Then you misinformed us. The result from pgsql was not a single line; each field is on a separate line.

And did you really get those quotes in the output? If not, why are they there? If you did, why didn't you show them in your previous posts?

Code:

LF='
'
name=$(pgsql -c "select name from teacher")
name=${name%$LF(*}
echo "${name#*-$LF}"

Really sorry about the misleading. Since I am not familiar with shell script, I can just tell you what I can see from the screen.

1. Single line
before asking

name=$(pgsql -c "select name from teacher")
echo $name

I can see only a single line display out there.
name ------------ Mary Lee (1 row)

Now I know that it is an array.
name
------------
Mary
Lee
(1
row)

There are no white spaces.

2. "quote"

Because from the screen of
name=$(pgsql -c "select name from teacher")
name=${name% (*}
echo "${name#*- }"

I found some white spaces next to Mary Lee, so want to show you there are some white spaces only.

It should be like that
<<white space>>name
------------
<<white space>>Mary Lee
(1 row)

3. Latest code

LF='
'
name=$(pgsql -c "select name from teacher")
name=${name%$LF(*}
echo "${name#*-$LF}"

------------
<<white space>>Mary Lee
<<blank line>>

Sorry again for the misinformation.

Try:

Code:

echo "$name"

No, it's not. It is a scalar variable containing more than one line.

What command produced that?

What is the output from:

Code:

pgsql -c "select name from teacher" | od -c

<<white space>>name
-----------
<<white space>>Mary Lee
(1 row)

for n in $name
do
echo $n
done

Quote:

0000000 n a m e \n - - - - -
0000020 - - - - - \n M a r y L e e \n
0000040 ( 1 r o w ) \n \n
0000051

Thanks!