Slashdot is powered by your submissions, so send in your scoop

 



Forgot your password?
typodupeerror
×

Comment Re:Betteridge was here (Score 1) 84

The most important comments are often also the most unassuming.

The top of the list of things you don't want to take from excel is the date/time processing concepts.

I cannot over-emphasise how much I agree with this.

<rant>
I am after spending most of the last two full weeks trying to import several hundred .csv files into an Excel spreadsheet. The files have the dates and times in a single field, in US format:

,m/d/yy 3:14 AM,

But my system's regional settings are set to the Irish standard:

dd/mm/yyyy 03:14:00

Importing through "Power Query" (a lie if there ever was) was a fecking nightmare. Even when I specifically indicated that the field was in MDY format, Excel ignored my input completely. So "3/3/21" imported fine... but as soon as it hit 3/13/21, PQ errored out and refused to load the data.

I figured that perhaps the combined date/time field was tripping it up. So I split the field (using a space as the delimiter) into separate date and time columns.
3/3:
| 3/3/21 | 03:14:00 |
3:13:
Error: Invalid date

WTF??

So I split the date field again, using "/" as the delimiter. So now I have
3/3:
| 3 | 3 | 21 | 03:14:00 |
3/16:
Error: Invalid date

o_O??

I tried changing the regional settings in Windows.

Nothing.

In Office.

Nothing.

In Excel.

Nothing.

What I finally discovered (after an embarrassingly long time) is that Power Query HAS ITS OWN REGIONAL SETTINGS. So finally I switched that to US standard, and the data began importing.

But I couldn't leave it there. WTF was happening that PQ was looking at | 3 | 16 | 21 | and failing a date check??

It turns out that before PQ will run the logic to split the data into columns, it (silently) assigns a default data type to each field it's importing, then checks the data against that data type and decides whether or not to import the field at all before running any of my logic on it. So it saw "type date", failed the validation (since it was quietly looking for - only - a Euro date format), and threw an error instead of importing the data and parsing it how I had instructed.

I apologise for the long post, but I needed to put this somewhere where it would be indexed and hopefully save someone else the dozens of hours of late-night pain it caused me.

And, circling back...

The top of the list of things you don't want to take from excel is the date/time processing concepts.

Please... please let microsoft/excel's date/time handling die a lonely, asphyxiated death.

</rant>

Comment Re:overfocus on diffs = ignoring simularities (Score 1) 31

giraffes have one of the biggest errors in evolution

The appendix was so named because at one time people thought it was an evolutionary relic with no current function.

Now, of course, we think the appendix serves a very important purpose.

So while you label this nerve's path an 'error', I don't necessarily agree. If we knew so little about giraffes' social structure, how much less do we really understand about their anatomy?

Comment Re: Needs proper regulation, ban is too extreme (Score 1) 32

Seriously, what the fuck is happening to America where everyone feels every view they have should be enacted into law and forced on everyone else?

You do not have an expectation of privacy

So we have to abide by your definition of what the "true" expectation of privacy is?

Oh, wait, you said 'You do not have an expectation of privacy legally speaking. I.e., we must abide by the definition imposed by the government.

fuck people who believe their views should be enforced by governmental fiat.

Emmm..

Do not come for my rights.

No need. you've already relinquished them, it appears.

Comment Re:One of the best points in history (Score 1) 117

I, for one, am afraid that the people spying on me might be evil people who seek to do me harm. Maybe they are also employees of some legitimate organization, but that doesn't mean that they aren't also evil people out to victimize me in some way.

The people spying on me are strangers. I don't know who they are, or what their motivations are. I haven't had a chance to vet them and I certainly didn't vote for them. I have zero reason to trust them. It would be irrational to simply accept that they are spying on me and I don't have any reason to fear. The only rational response is to fear the spying and seek to minimize it as much as is legally and physically possible.

Severely under-rated comment.

Anyone who wants this sort of access should be required - by international law and treaty - to have the same software installed on their own devices and open to the public for inspection.

The concept that I should trust someone simply because they trust themselves is utterly mental.

Comment Re:How pathetic is this (Score 4, Insightful) 80

Our government can't manage to have a space program anymore

The people who work on LRO, MRO, Mars landers, Hubble, Webb, New Horizons, Space Command, etc. (nearly ad infinitum) might take a bit of issue with your definition of what a 'space program' is there, lad.

I'd say the US still has a fairly robust space progam.

Slashdot Top Deals

Anyone can make an omelet with eggs. The trick is to make one with none.

Working...