parsing strings in vbs

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

parsing strings in vbs

Logged in as: Guest

arrSession:exec spGetSession 2,2,536

	Active Users: There are 0 members and 0 guests.
	Users viewing this topic: none

Printable Version

All Forums >> [Scripting] >> WSH & Client Side VBScript >> parsing strings in vbs
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: [1]

Message

<< Older Topic Newer Topic >>

parsing strings in vbs - 12/17/2001 4:21:36 PM

lesuk

Posts: 1
Score: 0
Joined: 12/17/2001
From: United Kingdom
Status: offline

Hi all first time here.....

Im in need of some support in writing a piece of VB Scrip for my website.

Im pulling data from a Access data base and want the data to be in the correct format, as in the capitals in the correct places etc, "House not house"

Ive got the first bit going ok in that the fields from tha data base with only one word entrys can be displayed like this one

<% myVar_location = (RS_member_detail_page.Fields.Item("location").Value)Response.Write(uCase(left(myvar_location,1))) & (right(myvar_location, Len(myvar_location)-1))
%>

Now being a newbie to VBS this took me a while to figure out..........So If one of the recordsets being pulled has a field in which there is a sentence or a few words

Can anyone advise me on how to count the words and number of charactures used.

Im not sure how to parse spaces? If there is a sentance is it just recognised as 1 string..

Many thanks in advance

Les.