[AccessD] Trouble using Split command

Charlotte Foust charlotte.foust at gmail.com
Fri Apr 22 10:18:05 CDT 2011


You're telling it to use "0" as the delimiter, which obviously isn't
correct. If you want to use a 0 for the binary compare, you need to
add the missing commas to get it in the right bucket.  What is the
"-" in there for?

Charlotte Foust

On Fri, Apr 22, 2011 at 8:12 AM, Charlotte Foust
<charlotte.foust at gmail.com> wrote:
> 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