Right - but with ALines you are stuck to only being able to process this
with a memofield and it won't work on large CSV files. Also, it won't
work
if there are CRLF between quotes per my earlier reply. It can work but I
personally would probably go with StrTran if commas and CRLF are not an
issue and size of the file is less than 16 megs. Otherwise I think he is
stuck with either Append From CSV into a cursor or writing his own
function
depending on the parameters of the CSV file.
Mike
"Jack Jackson" <jjackson@[EMAIL PROTECTED]
> wrote in message
news:4arj54djc16qph0gj1m7t11gg7rq89maq2@[EMAIL PROTECTED]
> On Wed, 18 Jun 2008 19:58:06 -0700, Gene Wirchenko <genew@[EMAIL PROTECTED]
>
> wrote:
>
>> Is there a function for parsing a comma-delimited string into an
>>array of substrings? I thought there was, but I can not find it in
>>the docs.
>>
>> Example: "abc,,def,ghi," would return an array of elements:
>> "abc"
>> ""
>> "def"
>> "ghi"
>> ""
>>
>>Sincerely,
>>
>>Gene Wirchenko
>>
>>Computerese Irregular Verb Conjugation:
>> I have preferences.
>> You have biases.
>> He/She has prejudices.
>
> ALINES has an option to specify the delimiter in newer versions.
>
> There is also GETWORDNUM and GETWORDCOUNT.
>
> However, you have to be careful about your requirement to get empty
> items. GETWORDNUM/GETWORDCOUNT ignore empty items - they treat a
> single delimiter the same as multiple delimiters in a row. I suppose
> that comes from them originally only using space as the delimiter. I
> think ALINES will keep the empty ones, but you need to check.
|
