Reputation
5,095
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
20 56 109
Impact
~1.3m people reached

Sep
26
comment Importing multiple CSV files
Please provide some example sheets so we have an idea of the data you're trying to work with. I'm not sure if Excel has built-in user-friendly features that can help with this, but it might be something that can be done with VBA or PowerShell.
Sep
24
comment Appending Year to Excel Date
If they're formatted dates, the last bit of my solution might not work - it assumes they're string values. Let me know if it's broken and I'll look into what's needed to fix it. Or, if you manage to fix it yourself, please let me know what you did.
Sep
24
comment Appending Year to Excel Date
Are the dates (e.g. "02-August") formatted as dates or text?
Sep
24
comment How to fix my local administrator?
Do you have access to an Admin-level account? Or is someone else responsible for administering the system?
Sep
24
comment Schrodinger's Contacts in Lync
@SvW That process is mired in corporate procedure involving a call center and several tiers of support. I much prefer to self-support troubleshooting of issues when I can - it's usually faster and less painful (and often more educational) that way.
Sep
24
comment Schrodinger's Contacts in Lync
@SvW Perhaps better suited for Super User? If it's a problem that doesn't require admin intervention (and I don't know that it is/isn't for sure - this is one of the reasons I'm asking), I don't see why it wouldn't belong either there or here. Either way, an answer of "this is a problem that needs to be resolved on the server or requires admin intervention" is also perfectly acceptable, if true.
Sep
24
comment Issue regarding text message privacy
@Ramhound That depends on how the app handles SSL certificate errors. If it ignores errors and accepts all certificates, an SSL proxy can step in the middle and intercept the communications. A desktop web browser would show errors stating that the certificate issuer is untrusted, unless corporate policy has been applied to force the system to trust it, but some apps (and many users) will just ignore this. I don't know the particulars about iMessage for certain, to say whether or not this is the case for that app. If you know, or find out, I suggest posting an answer that covers the topic.
Sep
24
comment Issue regarding text message privacy
From a quick Wikipedia lookup, it seems end-to-end encryption is used for iMessage. However, there's no mention about resistance to SSL proxies or similar interception technologies.
Sep
24
comment Issue regarding text message privacy
@Ramhound Not entirely true. iPhones will use iMessage by default for texting with other iOS users. iMessage will use WiFi. From there, it's just a matter of whether iMessage uses encryption for data-in-transit, and if the implementation is resistant to man-in-the-middle attacks like SSL proxies.
Sep
24
comment How to fix my local administrator?
Is this your personal computer, or a company resource? If the latter, go with the coffee & donuts solution suggested by @YetiFiasco. If the former, it's probably time for a rebuild anyway. Some very restrictive UAC configurations can prevent you from being able to run commands that require elevation without already being in an elevated session (e.g.: use an elevated CMD prompt instead of Start->Run), but you usually won't see that at home.
Sep
24
comment Managing a drive - searching for files that are rarely in use (so I can delete them for space)
Sorry about the confusion in DEL /S. I must have been reading about the same switch in a different section of the TCC docs or something. As for PowerShell, you've got to go back to Windows 2000/Me before you find an OS it can't run on. (And TCC can't go that far back either, though its predecessors may.) XP/2003 can't get the latest and greatest, and some of the newer modules aren't available below the latest Windows versions even with the same PowerShell version installed, but they can all still go up to at least PowerShell 2.0 which generally covers all the essentials.
Sep
23
comment Managing a drive - searching for files that are rarely in use (so I can delete them for space)
@RubenBaden If you ran the command exactly as-is in the answer, and only changed C:\*path*, you'll find the output in a file called "xxxxxxx.csv" within the current working directory.
Sep
23
comment Managing a drive - searching for files that are rarely in use (so I can delete them for space)
If you're simply talking about similarity in command name alone, PowerShell has built-in aliases to re-direct many common CMD commands to the new PowerShell alternatives. (Example: dir calls Get-ChildItem.) PowerShell can also make direct use of most other native CMD commands, and many external commands, without any special accommodations needed.
Sep
23
comment Managing a drive - searching for files that are rarely in use (so I can delete them for space)
I get that DIR /T:A /OD might be familiar to CMD users, but I don't see how the DIR syntax, or the DIR filtering syntax should be. DEL /S in CMD does something completely different, and neither DIR nor DEL have any native filtering functionality similar to what is used here that I'm aware of or able to find.
Sep
23
comment Managing a drive - searching for files that are rarely in use (so I can delete them for space)
@RubenBaden \\ is just a UNC path designator to tell the system you're specifying a resource on the network instead of locally. As far as when it's finished, you'll know when it produces output and/or returns you to the command prompt. If output has been redirected to a file, you won't see it on-screen. After the command prompt re-appears, just open the output file.
Sep
23
comment Managing a drive - searching for files that are rarely in use (so I can delete them for space)
1. Get-ChildItem | Sort-Object LastAccessTime, 2. Get-ChildItem | Where-Object {$_.LastAccessTime.Year -le 2008}, 3. Get-ChildItem | Where-Object {$_.LastAccessTime.Year -le 2008} | Remove-Item -WhatIf, 4. Get-ChildItem | Where-Object {$_.LastAccessTime.Year -le 2008} | Remove-Item. Given that PowerShell is 100% free, comes with Windows 7+, has commands and parameters that are generally much more human-readable and human-parseable than the syntax in this answer, and has a built-in help system plus gobs of online community support, I'm not sure how it's more "daunting" than TCC.
Sep
23
comment Managing a drive - searching for files that are rarely in use (so I can delete them for space)
@RubenBaden Change C:\*path* to the network path you want searched. Example: \\FileServer\ShareName.
Sep
23
comment Way to list and cat all files that contain string X in powershell
@musher That's happening because, by default, Select-String returns all lines that match what you're looking for. Using the -Quiet parameter avoids that, and instead returns a simple Boolean value. The script in my answer also avoids the issue by using Select-String as part of another matching condition instead of actually taking the output directly.
Sep
23
comment Powershell script to open a number of files located inside subdirectories
@val I also suggest you try using PowerShell's built-in help functionality whenever you're having trouble with a command. The cmdlet is Get-Help. (Example: Get-Help Invoke-Item) Depending on what version of PowerShell you're using, you may need to Update-Help first.
Sep
23
comment Managing a drive - searching for files that are rarely in use (so I can delete them for space)
@RubenBaden Copy/paste.