If you are interested in advertising in COTW (our rates are VERY reasonable), please email us at sponsor@codeoftheweek.com
The source code in this issue is designed for Visual Basic 3.0 and higher.
This issue introduces a subroutine to extract a particular word out of a string based on its position in the string. It allows you to ask for word number X and the subroutine will search through the source string and return word X based on the delimiter you supply. This is useful for parsing command line parameters or doing data importing.
Function GetWord(sData As String, iWord As Integer, sDelim As String) As String
This function returns the word at position iWord in sData using sDelim as the delimiter.
Below are two examples of how this function works.
sSource = "This is a test"
MsgBox GetWord(sSource, 1, " ") ' Will return "This"
MsgBox GetWord(sSource, 4, " ") ' Will return "test"
sSource = "12,Smith,123 Main St, 11000"
MsgBox "Name: " & GetWord(sSource, 2, ",")
MsgBox "Address: " & GetWord(sSource, 3, ",")
To see the source code for this issue you must be a subscriber to Code of the Week. If you are a subscriber the source code is available at the following address: http://www.codeoftheweek.com/membersonly/bi/0023.html
That concludes this issue of COTW. We hope you find the source code useful in your development.
The below describes the ways you can supply us some feedback about COTW. We would like to see our members help mold COTW into the best Visual Basic source code resource available. But to do that we need your feedback about what you like and what you do not like about COTW.
If you have any suggestions for topics you would like to see covered or questions about this issue, please email them to info@codeoftheweek.com or use online feedback form at http://www.codeoftheweek.com/feedback.html.
If you have any source code you would like to submit for possible inclusion in COTW, please fill out our online submission form at http://www.codeoftheweek.com/submission.html.
Thank you for trying Code of the Week for Visual Basic.
Your free trial expires after you receive your fourth issue. If you want to continue to receive Code of the Week you can get 52 issues of COTW for only $19.95. This is a full year of Visual Basic source code and information to help with all your development. So don't wait, subscribe now! The quickest way to subscribe is to jump to our online order form at http://www.codeoftheweek.com/order.html