Atlanta Custom Software Development 

   Search        Code/Page

User Login



Forgot the Password?
» Web Development
» Maintenance
» Data Integration/BI
» Information Management
» Regular Expr Tester
» Free Tools

Click here to copy the following block
' Concatenate an array of strings with commas and a final "and",
' or other separators
' Example:
'  Debug.WriteLine("Choose one from " & CreateStringList(New String() {"item1",
' "item2", "item3"}))
'  ' => Choose one from item1, item2 and item3

Function CreateStringList(ByVal items() As String, Optional ByVal sep As String _
  = ", ", Optional ByVal lastSep As String = " and ") As String
  ' join the strings with the first separator
  Dim res As String = String.Join(sep, items)
  ' find the last occurrence of the separator used to join the strings,
  ' remove it and insert the last separator instead
  Dim i As Integer = res.LastIndexOf(sep)
  If i > -1 Then
    res = res.Remove(i, sep.Length)
    res = res.Insert(i, lastSep)
  End If
  Return res
End Function

Submitted By : Nayan Patel  (Member Since : 5/26/2004 12:23:06 PM)

Job Description : He is the moderator of this site and currently working as an independent consultant. He works with, SQL Server and other MS technologies. He is, MCDBA and MCSE. In his free time he likes to watch funny movies and doing oil painting.
View all (893) submissions by this author  (Birth Date : 7/14/1981 )

Home   |  Comment   |  Contact Us   |  Privacy Policy   |  Terms & Conditions   |  BlogsZappySys

© 2008 BinaryWorld LLC. All rights reserved.