[AccessD] Trouble using Split command

Charlotte Foust charlotte.foust at gmail.com
Fri Apr 22 10:12:20 CDT 2011


What is the (0) for?  You have to declare the variable as a variant
because the value returned from Split is an array.

Charlotte Foust

On Fri, Apr 22, 2011 at 7:57 AM, philippe pons <phpons at gmail.com> wrote:
> Dim Test() As Variant
>
> Philippe
>
> 2011/4/22 Kaup, Chester <Chester_Kaup at kindermorgan.com>
>
>> I am trying to use the split command on the following string
>>
>> "                                0.000            243.729             -
>>   61.495              -"
>>
>> I have a dim statements as follows
>> Dim LineText As String
>> Dim Test() As String
>>
>> The split statement is as follows
>> Test = Split(LineText)(0)
>>
>> No matter how I dim Test() I get an error message of
>> Run Time Error 13
>> Type Mismatch
>>
>> This seems like it should be real simple but I am obviously missing
>> something.
>>
>> Thanks.
>>
>>
>>
>>
>> Chester Kaup
>> Engineering Technician
>> Kinder Morgan CO2 Company, LLP
>> Office (432) 688-3797
>> FAX (432) 688-3799
>>
>>
>> No trees were killed in the sending of this message. However a large number
>> of electrons were terribly inconvenienced.
>>
>>
>> --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>




More information about the AccessD mailing list