Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > microsoft.public.excel.programming > #110644
| From | dpb <none@none.net> |
|---|---|
| Newsgroups | microsoft.public.excel.programming |
| Subject | Re: Check how date is entered |
| Date | 2018-05-08 01:31 -0500 |
| Organization | Aioe.org NNTP Server |
| Message-ID | <pcrg7h$1ds3$1@gioia.aioe.org> (permalink) |
| References | (21 earlier) <pcq7c2$1m2m$1@gioia.aioe.org> <pcqccs$1ho$1@dont-email.me> <pcqh1a$3lj$1@dont-email.me> <pcqjqh$av5$1@gioia.aioe.org> <pcr8he$648$1@dont-email.me> |
On 5/7/2018 11:19 PM, GS wrote:
>> On 5/7/2018 4:38 PM, GS wrote:
>>> "...most development languages use DateSerial"
>>
>> Well, let's say most have a library available for the developer _to_
>> use. :)
>
> Actually, for VB[A] it's called a runtime.dll which is, as noted, the
> dev app's library. The developer has no control over the functions or
> methods the lib exposes, though.
For the most part it's just a wrapper around the C RTL and you can call
C RTL directly if wish (or roll your own)...
>> MS, of course, has a problem in that they think 1900 was a leap year
>> so are off by one compared to those who don't (correctly). I don't
>> know which way the C library work or POSIX or whether there's an
>> interpretation on how should work.
>
> Most langs use DateSerial for date values since this has more-or-less
> been adopted as a 'global' standard so 'regions' will capture the real
> value in local formats.
I still say "the language" does no such thing; the language may or may
not include the library but it's entirely up to the developer to use
whatever package or encoding they choose.
> I'm thinking, though, that terminology and familiarity with processes
> has played a role in any misunderstandings that prevailed here. Entering
> 05/07/2018 into a cell in Excel (or any other spreadsheet) is raw data
> not text. Entering that same data into a grid control is both raw data
> and text.
It's ASCII characters typed or pasted in from clipboard or whatever
other source, that's "text". How Excel interprets it is parsing that
text; spreadsheets have their rules which are quite complex as compared
to procedural languages; that's their advantage as being a much
"friendlier" coding paradigm for users that are not traditional programmers.
> Don't know how your MatLab takes values but your dialog here suggests it
> accepts string values that it uses to process whatever, OR
> interprets/treats entered values as string data. Does this mean what
> gets entered is wrapped in ""? (You could enlighten me further on this,
> if you would please.)
Depends on the source, and how one is using it...at the command line
it's much like working at the Immediate window in Excel VBA; one simply
writes executable statements in Matlab syntax (which is very much
Fortran/VB-like in form) and strings those together to achieve a goal.
Of course, for applications or repeatable tasks, one writes code
("m-files") for functions (local scope) and/or scripts (global) and
strings them together just like writing a VB app excepting one doesn't
have the container of the spreadsheet; one handles all data as either
native arrays or higher-level constructs of structs, tables, etc., etc.,
... ML is different from VB in that it is weakly typed in that there
are no variable declaration statements; the double is the default type,
everything else is a cast() to some other type.
As far as strings, the original base language treated them like F77
Fortran--as arrays of char(). Cell arrays were introduced which operate
much like a Variant in VB in holding mixed types and with it special
syntax for the cellstr() string; fairly recently a new strings() class
has been introduced which looks and acts much more like a VB string.
As far as quoted strings; they're recognized by the '%q' C-like format
string in context of fscanf() and friends or in other higher-level
routines that are part of the base package of Matlab such as readtable()
or textscan() or csvread(). The base Matlab package consists of
hundreds of these functions, the most fundamental of which are compiled
code, the high-level ones are often m-files themselves and distributed
with the product as source and are interpreted no differently than
user-written functions.
--
Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
Check how date is entered jan120253@gmail.com - 2018-05-04 00:31 -0700
Re: Check how date is entered dpb <none@none.net> - 2018-05-04 07:46 -0500
Re: Check how date is entered "Auric__" <not.my.real@email.address> - 2018-05-04 15:55 +0000
Re: Check how date is entered dpb <none@none.net> - 2018-05-04 12:43 -0500
Re: Check how date is entered GS <gs@v.invalid> - 2018-05-04 17:37 -0400
Re: Check how date is entered dpb <none@none.net> - 2018-05-04 18:49 -0500
Re: Check how date is entered GS <gs@v.invalid> - 2018-05-04 21:42 -0400
Re: Check how date is entered dpb <none@none.net> - 2018-05-04 23:46 -0500
Re: Check how date is entered GS <gs@v.invalid> - 2018-05-05 04:21 -0400
Re: Check how date is entered dpb <none@none.net> - 2018-05-05 07:21 -0500
Re: Check how date is entered GS <gs@v.invalid> - 2018-05-05 09:50 -0400
Re: Check how date is entered dpb <none@none.net> - 2018-05-05 09:05 -0500
Re: Check how date is entered GS <gs@v.invalid> - 2018-05-05 10:33 -0400
Re: Check how date is entered dpb <none@none.net> - 2018-05-05 10:57 -0500
Re: Check how date is entered GS <gs@v.invalid> - 2018-05-05 20:51 -0400
Re: Check how date is entered dpb <none@none.net> - 2018-05-05 11:32 -0500
Re: Check how date is entered GS <gs@v.invalid> - 2018-05-05 21:19 -0400
Re: Check how date is entered dpb <none@none.net> - 2018-05-06 07:46 -0500
Re: Check how date is entered dpb <none@none.net> - 2018-05-06 09:37 -0500
Re: Check how date is entered GS <gs@v.invalid> - 2018-05-06 20:37 -0400
Re: Check how date is entered dpb <none@none.net> - 2018-05-06 19:53 -0500
Re: Check how date is entered GS <gs@v.invalid> - 2018-05-06 21:03 -0400
Re: Check how date is entered dpb <none@none.net> - 2018-05-07 00:06 -0500
Re: Check how date is entered GS <gs@v.invalid> - 2018-05-07 03:14 -0400
Re: Check how date is entered dpb <none@none.net> - 2018-05-07 07:45 -0500
Re: Check how date is entered GS <gs@v.invalid> - 2018-05-07 13:06 -0400
Re: Check how date is entered dpb <none@none.net> - 2018-05-07 13:53 -0500
Re: Check how date is entered malone <malone@nospam.net.nz> - 2018-05-08 08:19 +1200
Re: Check how date is entered dpb <none@none.net> - 2018-05-07 15:35 -0500
Re: Check how date is entered GS <gs@v.invalid> - 2018-05-07 17:38 -0400
Re: Check how date is entered dpb <none@none.net> - 2018-05-07 17:26 -0500
Re: Check how date is entered GS <gs@v.invalid> - 2018-05-08 00:19 -0400
Re: Check how date is entered dpb <none@none.net> - 2018-05-08 01:31 -0500
Re: Check how date is entered GS <gs@v.invalid> - 2018-05-08 07:45 -0400
Re: Check how date is entered dpb <none@none.net> - 2018-05-08 09:45 -0500
Re: Check how date is entered GS <gs@v.invalid> - 2018-05-08 14:34 -0400
Re: Check how date is entered dpb <none@none.net> - 2018-05-08 14:09 -0500
Re: Check how date is entered GS <gs@v.invalid> - 2018-05-08 17:06 -0400
Re: Check how date is entered dpb <none@none.net> - 2018-05-08 13:48 -0500
Re: Check how date is entered GS <gs@v.invalid> - 2018-05-08 15:02 -0400
Re: Check how date is entered dpb <none@none.net> - 2018-05-08 14:59 -0500
Re: Check how date is entered GS <gs@v.invalid> - 2018-05-08 17:04 -0400
Re: Check how date is entered dpb <none@none.net> - 2018-05-08 18:53 -0500
Re: Check how date is entered dpb <none@none.net> - 2018-05-08 21:12 -0500
Re: Check how date is entered GS <gs@v.invalid> - 2018-05-08 23:51 -0400
Re: Check how date is entered dpb <none@none.net> - 2018-05-09 07:20 -0500
Re: Check how date is entered GS <gs@v.invalid> - 2018-05-09 11:32 -0400
Re: Check how date is entered dpb <none@none.net> - 2018-05-09 11:35 -0500
Re: Check how date is entered GS <gs@v.invalid> - 2018-05-09 15:03 -0400
Re: Check how date is entered dpb <none@none.net> - 2018-05-09 15:18 -0500
Re: Check how date is entered GS <gs@v.invalid> - 2018-05-07 13:34 -0400
Re: Check how date is entered dpb <none@none.net> - 2018-05-07 13:44 -0500
Re: Check how date is entered GS <gs@v.invalid> - 2018-05-07 17:40 -0400
Re: Check how date is entered dpb <none@none.net> - 2018-05-07 17:50 -0500
Re: Check how date is entered GS <gs@v.invalid> - 2018-05-08 00:02 -0400
Re: Check how date is entered jan120253@gmail.com - 2018-05-07 01:45 -0700
Re: Check how date is entered jan120253@gmail.com - 2018-05-07 01:52 -0700
Re: Check how date is entered dpb <none@none.net> - 2018-05-07 08:16 -0500
Re: Check how date is entered GS <gs@v.invalid> - 2018-05-07 13:10 -0400
Re: Check how date is entered Ramon-México <cesaramon@gmail.com> - 2018-05-07 22:03 -0700
csiph-web