I was away and was not using the net, so came at right time . If it is not bother can I trouble you to add Quarter as well in the Calculate Transform or in the DateTime format transform, which ever place you feel appropriate.
As I got some files in which I need to count the transactions Quarter wise. I could do that simply by taking the files to SQLite and do as I please over there, but I would rather stay in EDT if possible.
Will now go and download the snapshot and try to solve Day 3 problem, issue with that problem is that it needs to see the data one record above and one record below in addition to the same record as well and EDT only works with one record at a time and have no clue of record before and after.
Ok then you can add an option in the DateTime Transform as it is related to Date? as I need to get Quarter out of the date and could use DateTime format to change to Quarter from the transaction date or use it like for example
11-Dec-2023 >>> 2023-Q4 by having format set to YYYY-Q something like that.
Is it possible to change it from zero based index to one, cause the length gives you value not zero based, so getting the index zero based is confusing (at least for me) and difficult for non programmers users.
I had wondered about whether it should 1 or 0 based. The Excel equivalent FIND is 1 based. The Javascript IndexOf is 0 based. As a programmer I am used to 0 based.
Also I wondered whether it should be the position of Value 1 in Value 2 or vice versa.
If we go logically, it should be position of Value 2 in Value 1 as I am searching the position of a substring in the first (original) string for example,
Original string = …465…
Searching string = 465
So I am looking 465 in the original string, so Value 1 is the source string and Value 2 is the substring that I am looking for.
If need to calculate Quarter myself, then I rather use JavaScript transform, because to get Quarter out of a date one need to use 3 Calculate transform and here we are always striving to go for less number of transform.
I’m not sure either is more logical than the other. I had it that way round originally and then swapped the order to better match the Excel equivalent (FIND()).
Well i was going from the perspective left to right, you put source first and then what you want to do with that source. Anyway it is not that much trouble, but if you can make it one based instead of zero, that will be great.
Speaking personally, I’d rather see similarity with Excel in how things work. I’d expect most Easy Data Transform users will be familiar with Excel. And Apple’s Numbers FIND command also uses a 1 basis (and incidentally orders things as the position of Value 1 in Value 2).
So for me, having indexof and lastindexof as 1 based seems more logical.
And I prefer that (in similarly staying close to Excel) we search for the position of Value 1 in Value 2.
. If it is not bother can I trouble you to add Quarter as well in the Calculate Transform or in the DateTime format transform, which ever place you feel appropriate.