1,105,423 Community Members

Functions

Member Avatar
ng5
Light Poster
42 posts since Dec 2011
Reputation Points: 9 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

I am trying to populate a text box by taking the first 8 characters of a string in a list box. I have heard of a left mid and right function. Does anybody know how to use these functions?

Thanks in advance :)

Member Avatar
hericles
Veteran Poster
1,078 posts since Nov 2007
Reputation Points: 98 [?]
Q&As Helped to Solve: 232 [?]
Skill Endorsements: 14 [?]
Featured
 
0
 

The substring function lets you specify a start point in the string and how many characters to take from that point. So to take the first 8 characters of a string would be:

string smallString = longString.subString(0,8)

Left and right accept the string and the number of characters to take as parameters. Mid takes the string, the start position and the number of characters to take. E.g.
Dim s As String
s = Left(s, length)
s = Mid(s, start, length)
s = Right(s, length)

Member Avatar
ChrisPadgham
Posting Pro in Training
450 posts since Sep 2009
Reputation Points: 113 [?]
Q&As Helped to Solve: 90 [?]
Skill Endorsements: 8 [?]
 
0
 

surely you could have looked this up in microsofts reference material

http://msdn.microsoft.com

Member Avatar
codeorder
Postaholic
2,027 posts since Aug 2010
Reputation Points: 197 [?]
Q&As Helped to Solve: 390 [?]
Skill Endorsements: 10 [?]
 
0
 

>>...I have heard of a left mid and right function. Does anybody know how to use these functions?
I have heard that those are vb6- Functions and you should try to move on from those; even though they are still available for the migrating.programmers from "basic?" to use .net, .net.Functions as .Substring and/or your own Functions, can do most of the content.extract stuff, If Not more.

You
This article has been dead for over three months: Start a new discussion instead
Post:
Start New Discussion
View similar articles that have also been tagged: