Regarding logic

[d_koti24]

Hi All,

PFA

i am loading the data from log file.to retrive file path and extension ,i.e fine.in my extension file contains 4 extensions

like:

qvd(qvd),

qvd,

xls,

xlsx

my req is i want dispaly only 2 extn's in list box like qvd,xlsx instead of 4.when i click qvd i want to reflect the data for both fields(

qvd(qvd),

qvd,)

same vise versa.

How to achive this?

regards,

Kd.

[Clever_Anjos]

this should solve

Loc:

load

if(LEFT(SubField(locations,' ',6),1)='F',mid(locations,index(locations,' ',6),len(locations)-index(locations,' ',6)+1),

                                         mid(locations,index(locations,' ',4),len(locations)-index(locations,' ',4)+1)) as loc,

locations,

left(SubField( SubField(locations,'.',-1),']'),3) as extn

Resident Test;

[d_koti24]

Thanks for Quick reply Clever Anjos

It's working fine,but i am getting one extra space in list box

how to remove that one

[Clever_Anjos]

Loc:

load

if(LEFT(SubField(locations,' ',6),1)='F',mid(locations,index(locations,' ',6),len(locations)-index(locations,' ',6)+1),

                                         mid(locations,index(locations,' ',4),len(locations)-index(locations,' ',4)+1)) as loc,

locations,

trim(left(SubField( SubField(locations,'.',-1),']'),3)) as extn //  this should fix it

Resident Test;