Click here to Skip to main content
15,906,816 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: crystal reports Pin
Dave Kreskowiak23-Apr-06 3:59
mveDave Kreskowiak23-Apr-06 3:59 
Questionvalue and reference Pin
pankajgarg1222-Apr-06 21:34
pankajgarg1222-Apr-06 21:34 
AnswerRe: value and reference Pin
Steve Pullan22-Apr-06 22:32
Steve Pullan22-Apr-06 22:32 
GeneralRe: value and reference Pin
John R. Shaw22-Apr-06 23:01
John R. Shaw22-Apr-06 23:01 
GeneralRe: value and reference Pin
Steve Pullan23-Apr-06 0:51
Steve Pullan23-Apr-06 0:51 
GeneralRe: value and reference Pin
John R. Shaw23-Apr-06 11:09
John R. Shaw23-Apr-06 11:09 
QuestionSeperating text from Database Pin
jdjd111822-Apr-06 17:54
jdjd111822-Apr-06 17:54 
AnswerRe: Seperating text from Database Pin
Steve Pullan22-Apr-06 18:11
Steve Pullan22-Apr-06 18:11 
Depends whether or not you want to do the manipulation in the database engine or VB. If the former you can write a TSQL query like this:

select FullName,
       substring(fullName, x, n) as FirstName,
       substring(fullName, y, m) as LastName
from ....

where the substring() function extracts the names from the FullName column. These will then be presented to your program as columns returned from the query.

If on the other hand you want to do the manipulation in your program, use the Split() function on the FullName column (e.g. if FullName contains "Bloggs, Joe" the following code will extract these into the names array...

Dim names() as String<br />
names = Split(FullName, ", ")<br />
<br />
'names(0) will contain "Bloggs"<br />
'names(1) will contain "Joe"


Hope that helps.


...Steve

1. quod erat demonstrandum
2. "Give a man a fish and you've fed him for a day. Teach him how to fish and you've fed him for life."
I read that somewhere once Smile | :)
QuestionProblem with MainMenu display? Pin
jphuphilly22-Apr-06 14:35
jphuphilly22-Apr-06 14:35 
AnswerRe: Problem with MainMenu display? Pin
Dave Kreskowiak23-Apr-06 3:53
mveDave Kreskowiak23-Apr-06 3:53 
QuestionHow to change shape properties in a VB report? Pin
nasps122-Apr-06 9:00
nasps122-Apr-06 9:00 
QuestionButton usage Pin
machman122-Apr-06 8:50
machman122-Apr-06 8:50 
AnswerRe: Button usage Pin
CWIZO22-Apr-06 23:46
CWIZO22-Apr-06 23:46 
AnswerRe: Button usage Pin
Dave Kreskowiak23-Apr-06 3:40
mveDave Kreskowiak23-Apr-06 3:40 
AnswerRe: Button usage Pin
arunendra24-Apr-06 4:48
arunendra24-Apr-06 4:48 
Questionproblem with msvbvm60.dll Pin
ZEALOTT22-Apr-06 8:02
ZEALOTT22-Apr-06 8:02 
AnswerRe: problem with msvbvm60.dll Pin
Dave Kreskowiak23-Apr-06 3:38
mveDave Kreskowiak23-Apr-06 3:38 
Questionframe-delay change in gif Pin
sasha_razm22-Apr-06 5:07
sasha_razm22-Apr-06 5:07 
QuestionHelp About String Matching Pin
extraful22-Apr-06 3:48
extraful22-Apr-06 3:48 
AnswerRe: Help About String Matching Pin
Dave Kreskowiak22-Apr-06 6:29
mveDave Kreskowiak22-Apr-06 6:29 
AnswerRe: Help About String Matching Pin
extraful24-Apr-06 5:17
extraful24-Apr-06 5:17 
Questionplz help me.. this is the fifth time ... Pin
Mr kilany22-Apr-06 3:37
Mr kilany22-Apr-06 3:37 
GeneralRe: plz help me.. this is the fifth time ... Pin
Guffa22-Apr-06 4:50
Guffa22-Apr-06 4:50 
GeneralRe: plz help me.. this is the fifth time ... Pin
Dave Kreskowiak22-Apr-06 6:27
mveDave Kreskowiak22-Apr-06 6:27 
AnswerRe: plz help me.. this is the fifth time ... Pin
Steve Pullan22-Apr-06 17:11
Steve Pullan22-Apr-06 17:11 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.