7,021 reputation
1334
bio website
location
age
visits member for 1 year, 4 months
seen 3 hours ago
stats profile views 369

Apr
29
comment Significant platform-dependent efficiency when importing data?
using such an approach is possible for every OS: all you need is powerful command line programs to extract the data. head, tail and cut are standard unix programs which are available in probably every Linux distro and MacOS but not by default on Windows. You can install such command line programs on Windows, cygwin being a very convenient way to install a whole bunch of those running in an environment emulating a complete unix system. You can instead only install those cmd-line tools you're actually using. For more possibilities see the documentation (==man pages) of those programs...
Apr
29
comment Import large amount of data with time stamps
You can read the first two columns as string and convert to date lists with DateList. With that result you can then use e.g. DateListPlot. As converting with DateList might be relatively slow and your date format is fixed, I would suggest to use a StringReplace + ToExpression approach for improved performance. I think answers to this question will also be relevant, although your file seems to rather be large but not yet huge.
Apr
29
comment Network database access - How do I connect to a remote database?
AFAIK an Access database is just a plain file and the usual approach is to make the file accessable from the remote computer via e.g. a "network drive". It then can be used like a local file with the usual ODBC driver, but you'll probably have to configure that. As there is no real database server involved, concurrent usage of the same database file with several processes/programs will only be possible within certain limits (which I don't know about), and if you need concurrent read/write you certainly should consider installing/running a real database server...
Apr
29
awarded  Nice Answer
Apr
29
revised Reading periodic elements from a large file
added notes about actual observed memory consumption
Apr
27
revised Why function cannot be defined inside For loop?
added notes about compoundexpression
Apr
26
awarded  Nice Answer
Apr
26
comment CDF won't work but NB works
@dabd: just tested my code locally with the browser-plugin and it seems to work alright. I guess that there is something wrong with your setup for the embedding in the blog post and the message that the cdf couldn't be loaded also IMO rather looks like something not related to the actual content of the CDF. Maybe an issue with accessability or just a typo in the filenames/urls?
Apr
26
revised CDF won't work but NB works
added note about cdf-plugin
Apr
26
comment CDF won't work but NB works
@dabd: hm, have you tried to export as "Web Embedable" and run it from a local html-file in your browser? I'd ensure that this works before I'd try it from a remote site. Honestly I have only tested my answer with the "Standalone" export, it could be that for the sandboxed plugin even the Number form of InputField isn't supported. I'll try that and probably adopt my answer accordingly...
Apr
26
revised Why function cannot be defined inside For loop?
added 162 characters in body
Apr
26
answered How to get rid of trailing string after using Convert?
Apr
26
answered CDF won't work but NB works
Apr
26
comment How can I assign a Fit result to a function?
@AndreaColonna: one more point: you can/should use the same techniques to localize or protect the symbols used as function arguments as in J.M.s answer, e.g.: line2=Block[{y},Function[{y}, Evaluate[Fit[{p1, p2}, {1, y}, y]]]]
Apr
26
comment How can I assign a Fit result to a function?
@AndreaColonna: if you wonder about SetDelayed, why don't you just exchange it to Set (=). That works alright and is the thing to do here. With that change, I think it is a perfect way to define such a function, to some extent I like that even better than the function definition per downvalues. You should also note that the Evaluated -> True option isn't actually necessary then.
Apr
26
answered Why function cannot be defined inside For loop?
Apr
23
answered Substituting Data from File
Apr
23
answered Define variable relationships and dynamically update variables
Apr
17
revised How to split a file?
deleted 3 characters in body
Apr
17
answered How to remove a singularity with WhenEvent