Search Results

PORT=`${EFG_ISQL} -b <<-!
set nocount on
use ${EFG_DB}
go
select portId from PORTFOLIO
go
!`

echo $PORT

for Portfolio in $PORT
do
........................
done


The input is...

What if we are not sure about the lenght for eg the var can be

aaa_bbb_ccc_ddd.abc
or aaa_bbb.abc
or aaa.abc

Hi,

I am trying to query the database to get the list of portfolio and for each portfolio, I am using the for loop, but the problem is some of the portfolio is having the spaces.

The Code
...