Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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;
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
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;