Paradox Community

Items in pnews.paradox-programming

Subject:Re: Downloading and saving as a csv via API Call
Date:Tue, 1 May 2018 14:49:51 +1000
From:Robert MacMillan <>
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

Copyright © 2004