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)
hericles
Practically a Posting Shark
823 posts since Nov 2007
Reputation Points: 136
Solved Threads: 167
>>...I have heard of a left mid and right function. Does anybody know how to use these functions?
I have heard that those arevb6- 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.
codeorder
Posting Virtuoso
1,913 posts since Aug 2010
Reputation Points: 255
Solved Threads: 384