|
Perl scripts?
Is regex possible with this Qlikview crap?
modified 7-Aug-18 10:42am.
|
|
|
|
|
John Simmons / outlaw programmer wrote: YYYY-MM-DD HH:MM:SS.FFF
Seriously? The format strings don't differentiate between "month" and "minute"?  💩
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Perhaps it's context sensitive.
Everyone is born right handed. Only the strongest overcome it.
Fight for left-handed rights and hand equality.
|
|
|
|
|
I like positive thinking.
|
|
|
|
|
Perhaps the feature "common sense" was integrated. If it sees HH, then the next format will treat minutes regardless of the casing 
|
|
|
|
|
John Simmons / outlaw programmer wrote: DATE(NUM(DATE(FLOOR($(vTEST)) 'YYYY-MM-DD HH:MM:SS.FFF')
In my geeky teens I would have thought, "oh wow, this is so cool, 4 levels of parens!" and shown it to all my friends (erm, wait, what friends???) who would have gone "wow, that IS cool!" (if I had any friends.)
Now in my geeky 50's I'm with you -- I look at that and think, wow, what BS is this?
Latest Article - A Concise Overview of Threads
Learning to code with python is like learning to swim with those little arm floaties. It gives you undeserved confidence and will eventually drown you. - DangerBunny
Artificial intelligence is the only remedy for natural stupidity. - CDP1802
|
|
|
|
|
Marc Clifton wrote: "oh wow, this is so cool, 4 levels of parens!"
And your geeky friends would have mocked you because there are 5 levels... 
Sent from my Amstrad PC 1640
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
If he were counting parens, 4 would be the average between the left and right side. 
edit: sorry, didn't see the post below which mentions this. 
"Go forth into the source" - Neal Morse
|
|
|
|
|
qlik example DATE(NUM(DATE(FLOOR($(vTEST)) 'YYYY-MM-DD HH:MM:SS.FFF')
This is the necessary stage of declarative programming* that occurs right before AI takes over and writes all the code for us. 
Yes, it's like SQL and yes I hate SQL also*.
<bumpersticker>Real Devs Hate SQL</bumpersticker>
|
|
|
|
|
I'm somewhere between my teens and 50's and two parens would've been fine for me 
|
|
|
|
|
I wonder that any of these expressions returns something, since none of them has balanced parentheses.
On the other hand, I have never heard of "Qlikview" (fortunately), and perhaps this "language" can't cope with balanced parentheses
|
|
|
|
|
Does this work for you?
SET DateFormat='YYYY-MM-DD';
LET vTEST = '2018-09-05 13:27:14.5';
dayname(vTEST)
|
|
|
|
|
This will give you the date portion of the string:
LET vTEST = '2018-09-05 13:27:14.5';
LET vResult = Date(vTEST, 'YYYY-MM-DD'); <-- vResult = 2018-09-05
Also, 'MM' for months, 'mm' for minutes.
Sincerely,
-Mark
|
|
|
|
|
I'm - among other things - making a software for the ATMs (for Bitcoins they're called BTMs). Yesterday we've found out that one of our machines has probably a defective touch screen. It was randomly pressing all over the screen. On closer inspection (on site) it turned out to be a branch of a tree randomly waving in the wind and occasionally touching the screen. This branch also managed in this short time to uncover two bugs that two testing teams were unable to find during two years of product lifetime. One was even as simply as touching the screen in a certain time. One was more complex, the branch managed to 'touch' through random screens and created very weird scenarios. One of them was a really obscure bug. The branch became a honorary member of our testing team.
In order to understand stack overflow, you must first understand stack overflow.
|
|
|
|
|
Welcome to fuzzing[^]
Software rusts. Simon Stephenson, ca 1994. So does this signature. me, 2012
|
|
|
|
|
That means the Branch is probably the most experienced member of our testing team. I reckon it will lead the team within few months.
In order to understand stack overflow, you must first understand stack overflow.
|
|
|
|
|
there is great potential he could become the next branch manager!
|
|
|
|
|
First day in office in my previous work... I come in the room and I see a guy looking at the roof randomly touching a screen on the table with both hands.
When I asked... "what are you doing?"
He answered... "playing the bored operator"
4 Years later, a line programed by me that had been working for months stable and smooth got an error... I could not get out of the status without direct access to the PLC to change some values using my laptop. A new guy had been assigned to the line, he had discovered a deadlock in his 3rd day and the worst is... I could not find out, how he did it.
In that moment, I remembered my first day crystal clear and thought "man... was he right"
You story has called the same flash back again.
M.D.V. 
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
I understand now as well. I'll include such random trial in my debug version and will let one copy run endlessly.
In order to understand stack overflow, you must first understand stack overflow.
|
|
|
|
|
Smart K8 wrote: I'll include such random trial in my debug version and will let one copy run endlessly.
And you won't be so accurated as a bored / stupid human
M.D.V.
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
True. We need an algorithm for 'stupid'. Then just run DoStupid() on your application to cause mayhem.
In order to understand stack overflow, you must first understand stack overflow.
|
|
|
|
|
I recall (many years) ago a unix tool that output text to the screen. It included options to simulate a lazy/drunk human (you could specify how drunk with some numerical argument). It introduced delays, mistakes and corrections into the typing and looked convincingly human. I can't remember it being useful, but it was funny.
|
|
|
|
|
Go green!
"It is easy to decipher extraterrestrial signals after deciphering Javascript and VB6 themselves.", ISanti[ ^]
|
|
|
|
|
People are afraid A.I. will replace them, but slowly the nature is overtaking our jobs. Dey took err jerbs!
In order to understand stack overflow, you must first understand stack overflow.
|
|
|
|
|
that tree must get pay hike.. probably more fertilizers and water
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
