In VB I have a string like this-
I want the result to have all the data upto the space ie-
How can I get this?
At present I am using Trim.. and it gets only 2 chars... I want to make it more felixble and have to parse everyting upto the space...
Left(LCase(Trim("" & Me.Controls("Col" & I))), 2)