Subject: | Re: Downloading and saving as a csv via API Call
| Date: | Tue, 1 May 2018 14:49:51 +1000
| From: | Robert MacMillan <macfam@bigpond.net.au>
| Newsgroups: | pnews.paradox-programming
|
Thank you Larry.
Brain not working again. The answer was to breakapart on "\n" into an
array - the new line markers are actually there but ignored by notepad.
From there I can scan the array, textstream it, deal with it on the
spot into what I finally want out of it.
Some of the files are 15,000 runners long but paradox is really good at
parsing that sort of thing quickly.
On 1/05/2018 1:14 PM, Larry DiGiovanni wrote:
> Robert MacMillan wrote:
>
>> so all I need to now solve is how to not put it in a string but dump
>> it complete into a .csv file.
>
> msXML has a .responseStream that will return a stream. I don't know/if
> ObjectPAL can handle a stream, though.
>
>> There is also a problem in breaking it apart and processing it that
>> way from the entire string in that there is no comma between the end
>> of one record and the beginning of the next.
>
> If you open the URL in the browser and save it, are the line breaks
> present? If so, then I'd guess it has something to do with the String
> conversion, or possibly just how you are looking at them, or not looking
> at them.
>
> --
> Larry DiGiovanni
>
|