var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: create new field from data after last space in a field?
I'm in need of some help. This is my first ever post here, though I have learned a lot from these forums, so please be kind.
I have a "name" field with a variable number of spaces in it. I need to create a new field that contains just the information found after the last space in the "name" field.
Your help is greatly appreciated.
What I understood, you want to search the last Space in your filed, don't you?
If so then
make a loop to search the space i.e chr$(32) using the InStr() function, till you get the last space, then use the Mid$ function to get the part after the last space.
Hope that could help.
hammbakka, spot on as usual...
might I suggest using the StrReverse() function to first reverse the string, thereby making locating the first space a good deal less intensive..
There is no
StrRevers under the Office 97 so I don't know that function, But you can use Tedde's suggestion under Acce$$ 2000 or heighter...
Gah... hamm, it's time to upgrade my friend.
I don't want headech with Acce$$ 2000 and heigher, I am old fashoned still with 97
hammbakka, well I know ppl who still prefer Windows 3.x
Originally Posted by
WFWG 3.11 here here, though I no longer have it I really enjoyed it and NEVER had a problem with it. Now with 98SE and XP I get headaches, cramps, nausea.....lol
Thank you all!
Thanks to everyone that replied! Special thanks to Teddy! I wasn't aware of this function! That's a perfect solution. You are very knowledgeable and helpful!