Hi All,



can any one suggest better alternative to statement like Len(Trim(string))>0. As we know Trim operation is very complex one ane we are using same statement so many places in a loop.



Please suggest better solution/function which do the same task.



Thanks in advance,

Surya


____________________________
surya satya

Hi..

Some other functions could do the same output but it depends of the user and where you going to do it..

mid,right,left and other functions can be


There are so many members here who can help you If you're going to post your complete and very specific problem.


Im sorry it's not clear to me what probably you want to be.

-VYX-

--------------------------------
"Genius is 1 percent inspiration but 99 percent perspiration"
by Thomas Edison

Hi,
The following will be quicker.. although how much is quite marginal.

dim i as long for i=len(s) to 0    if asc(mid$(s,i,1))<>32 then exit for next i s = left$(s,i)

Hope this helps,
Kieron


____________________________
Build it better, faster, quicker, easier.. then fix it (non-offical MS mission statement)