|    
			
				18/12/2002, 10:36
			
			
			  | 
  |   |  |  |  |  Fecha de Ingreso: diciembre-2002 Ubicación: Chapinlandia :-D 
						Mensajes: 725
					 Antigüedad: 22 años, 10 meses Puntos: 11 |  | 
  |  aca va el resto...
 Public Function GetElement(ByVal strList As String, ByVal strDelimiter As String, ByVal lngNumColumns As Long, ByVal lngRow As Long, ByVal lngColumn As Long) As String
 
 Dim lngCounter As Long
 
 ' Append delimiter text to the end of the list as a terminator.
 strList = strList & strDelimiter
 
 ' Calculate the offset for the item required based on the number of columns the list
 ' 'strList' has i.e. 'lngNumColumns' and from which row the element is to be
 ' selected i.e. 'lngRow'.
 lngColumn = IIf(lngRow = 0, lngColumn, (lngRow * lngNumColumns) + lngColumn)
 
 ' Search for the 'lngColumn' item from the list 'strList'.
 For lngCounter = 0 To lngColumn - 1
 
 ' Remove each item from the list.
 strList = Mid$(strList, InStr(strList, strDelimiter) + Len(strDelimiter), Len(strList))
 
 ' If list becomes empty before 'lngColumn' is found then just
 ' return an empty string.
 If Len(strList) = 0 Then
 GetElement = ""
 Exit Function
 End If
 
 Next lngCounter
 
 ' Return the sought list element.
 GetElement = Left$(strList, InStr(strList, strDelimiter) - 1)
 
 End Function
 
 
 ''''''''''''''''''''''''''''''''''''''''''''''''''  ''''''''''''
 'Function GetNumElements (ByVal strList As String,
 '                         ByVal strDelimiter As String)
 '                         As Integer
 '
 '  strList      = The element list.
 '  strDelimiter = The delimiter by which the elements in
 '                 'strList' are seperated.
 '
 '  The function returns an integer which is the count of the
 '  number of elements in 'strList'.
 '
 '  Author: Roger Taylor
 '
 '  Date:26/12/1998
 '
 '  Additional Information:
 '
 '  Revision History:
 '
 ''''''''''''''''''''''''''''''''''''''''''''''''''  ''''''''''''
 
 Public Function GetNumElements(ByVal strList As String, ByVal strDelimiter As String) As Integer
 
 Dim intElementCount As Integer
 
 ' If no elements in the list 'strList' then just return 0.
 If Len(strList) = 0 Then
 GetNumElements = 0
 Exit Function
 End If
 
 ' Append delimiter text to the end of the list as a terminator.
 strList = strList & strDelimiter
 
 ' Count the number of elements in 'strlist'
 While InStr(strList, strDelimiter) > 0
 intElementCount = intElementCount + 1
 strList = Mid$(strList, InStr(strList, strDelimiter) + 1, Len(strList))
 Wend
 GetNumElements = intElementCount
 End Function
     |