• Home
 · 
• String Manipulation
 · 
• This function will take a comma-delimited input string of any length and return an array of parsed

This function will take a comma-delimited input string of any length and return an array of parsed

This function will take a comma-delimited input string of any length and return an array of parsed substrings. You can control the number of

Rate This function will take a comma-delimited input string of any length and return an array of parsed

• 1
• 2
• 3
• 4
• 5

(1(1 Vote))

'This function will take a string of data that is comma-delimited and return it parsed
'in an array. The input string can have up to 15 comma-delimited parameters
'
'Created by Chris Lindsey 1/25/02

Dlength = Len(Data)
Dim Extract(15)
Position = 1

For i = 1 To Dlength
  character = Mid(Data, i, 1)
   
   If Asc(character) <> 44 Then
     Extract(Position) = Extract(Position) & character
   Else
     Extract(Position) = RTrim(Extract(Position))
     Position = Position + 1
   End If
    

Next i

ParseLine = Extract

End Function