Thank you. That's the one.
Mark

> Use the function SPLIT()
it will split your string by a delimiter and put the results in to an array
hope this helps

>From: "Mark" <tek_mark@h...>
>Reply-To: "professional vb" <pro_vb@p...>
>To: "professional vb" <pro_vb@p...>
>Subject: [pro_vb] Parsing an Input String
>Date: Mon, 10 Mar 2003 19:56:56
>
>There is a command within VB6 that easily parses an input string and
>separates the arguments by a specified delimiter:
>
>String="A,B,C,D,E"
>Avar=ThisFunction(String,",")
>Bvar=ThisFunction(String,",")
>
>Where ThisFunction is defined as
>Function ThisFunction(InputString as string, Delimiter as string",") as
>string