Welcome, Guest
You have to register before you can post on our site.

Username
  

Password
  





Search Forums

(Advanced Search)

Forum Statistics
» Members: 190
» Latest member: Lil Wiz
» Forum threads: 14,164
» Forum posts: 222,165

Full Statistics

Online Users
There are currently 1416 online users.
» 3 Member(s) | 1408 Guest(s)
Applebot, Baidu, Bing, Google, Yandex, batzulger, Dartz, drakensis

Latest Threads
Fic Update Thread 62: the...
Forum: Other People's Fanfiction
Last Post: Shepherd
19 minutes ago
» Replies: 64
» Views: 2,786
Image dump thread XXXI
Forum: General Chatter
Last Post: Labster
2 hours ago
» Replies: 226
» Views: 22,551
All The Tropes Wiki Proje...
Forum: General Chatter
Last Post: Bob Schroeck
4 hours ago
» Replies: 245
» Views: 31,246
Looking for a free media ...
Forum: General Chatter
Last Post: robkelk
5 hours ago
» Replies: 0
» Views: 14
Political Images thread t...
Forum: Politics and Other Fun
Last Post: Norgarth
11 hours ago
» Replies: 132
» Views: 12,382
Kick ALL the Starters, Pa...
Forum: General Chatter
Last Post: Shepherd
Yesterday, 10:39 PM
» Replies: 57
» Views: 15,776
The Imperial Presidency, ...
Forum: Politics and Other Fun
Last Post: Mamorien
Yesterday, 06:40 PM
» Replies: 202
» Views: 22,796
2017-01-17: Learning to B...
Forum: Stories
Last Post: robkelk
Yesterday, 07:20 AM
» Replies: 2
» Views: 181
Image Thread #3
Forum: My Apartment Manager is not an Isekai Character
Last Post: Mamorien
04-25-2026, 09:20 PM
» Replies: 182
» Views: 52,940
Weird & Interesting scien...
Forum: General Chatter
Last Post: classicdrogn
04-24-2026, 09:48 PM
» Replies: 258
» Views: 82,035

 
  Tech Request -- Accessing extensionless files from VBA
Posted by: SkyeFire - 07-23-2010, 07:19 PM - Forum: General Chatter - Replies (12)

Never thought this would be my biggest headache today.

Short version:  I spent all day yesterday doing test runs and logging data (for which the physical setup took the first part of the week).  Today I'm trying to sort the massive pile of log files into something that's convenient for analysis.  
Problem is, the software that was logging the realtime data is an old, unsupported POS with very strange filing procedures.  Essentially, for a test names "Test1", it dumps out a dozen+ files named Test1.xxx, where xxx can be, well, a LOT of different things.  And every additional test gets all its files dumped in that same directory.
And, just for grins&giggles, the data I need are always in the file that has no extension.

So, today I've been bashing (ahem) together a VBA script in Excel (sucks, but it's what I've got) that opens a user dialog, sucks up the file, and rearranges the data into nice columnar format for further processing.  But I'd like to have the file-select box filter out all the files that have extensions, so that when the user selects the directory where all the files from all of the tests got dumped, the user will only see the files that have no extension.
And this is where I'm stuck.  Googling around I've found how to have the box filter for any extension I like, except the no-extension-at-all condition.  I just can't seem to find the correct magic combination of search terms to lead me to what I need.

Anybody know how to do this?

Print this item

  Unless Doug's going to live with the Flower Division...
Posted by: robkelk - 07-23-2010, 02:05 PM - Forum: Future Steps - Replies (1)

...he'll probably end up rooming in a house like this one.

(Eimi would probably spend a lot of time running her copy of baseline Kohran while living there, just because it's appropriate.)

Print this item

  Alien Swarm
Posted by: HoagieOfDoom - 07-23-2010, 07:31 AM - Forum: General Chatter - Replies (1)

Valve released a game called Alien Swarm a few days ago. It's a Source Engine game that's completely free. Top-down, isometric co-op shooter game. You play as a bunch of marines on some colony world fighting against, well, an Alien Swarm. It feels a lot like Left 4 Dead (there's a lot of sound effects and interface elements shared between the two games). System requirements aren't horrendous and it's a heck of a lot of fun. If anyone would like to play a game, my SteamID is the same as my handle here.

Print this item

  Et tu, OpenDNS?
Posted by: Morganite - 07-23-2010, 06:02 AM - Forum: General Chatter - Replies (1)

So, I have all my computers set up to use OpenDNS. But when I started up my browser this evening, it's blocking various sites with messages like "Site blocked. www.sankakucomplex.com is not allowed on this network."

Looked around and found google's public DNS, which seems to be working just fine. But the question remains... what the hell is this?

-Morgan.

Print this item

  OneManga shutting down
Posted by: ECSNorway - 07-23-2010, 04:53 AM - Forum: Politics and Other Fun - Replies (96)

Well, folks, the forces of Copyright have won another battle.
Scanslation site OneManga is to shut down this week. Read what you can while it's still up.
--
Sucrose Octanitrate.
Proof positive that with sufficient motivation, you can make anything explode.

Print this item

  Is this a subversion, a lampshading, or both?
Posted by: robkelk - 07-23-2010, 03:22 AM - Forum: General Chatter - Replies (2)

http://www.dorktower.com/2010/07/21/dor ... y-21-2010/]Today's Dork Tower has a couple of characters we haven't seen for a few years...

Is Gilly subverting or lampshading the trope? (Or both?) Must use the correct term over on TVTropes...
--
Rob Kelk
"Governments have no right to question the loyalty of those who oppose
them. Adversaries remain citizens of the same state, common subjects of
the same sovereign, servants of the same law."

- Michael Ignatieff, addressing Stanford University in 2012

Print this item

  Pokemon Tarot Cards?
Posted by: Foxboy - 07-23-2010, 12:13 AM - Forum: General Chatter - Replies (4)

Apparently so:
Link
''We don't just borrow words; on occasion, English has pursued other languages down alleyways to beat
them unconscious and rifle their pockets for new vocabulary.''

-- James Nicoll

Print this item

  Warriorgeddon
Posted by: Star Ranger4 - 07-22-2010, 11:30 PM - Forum: The Legendary - Replies (3)

Aka Mercedes Sheldon's "Crown of Glory" arc...
Garavordnette has it.  Planning to run it Friday at 9pm eastern (sat am for you Aussies and Kiwis)   Passing along the word so that any who want can attend, ideally enough that we get enough bosses so that everyone can get their Legionare (Warrior boss kills) badge.
Hear that thunder rolling till it seems to split the sky?
That's every ship in Grayson's Navy taking up the cry-

NO QUARTER!!!
-- "No Quarter", by Echo's Children

Print this item

  ROTFL: MAO!
Posted by: itsune9tl - 07-22-2010, 07:49 PM - Forum: Archived Fanfic Recommendations - Replies (300)

If you've ever asked your neighbor to return your plastic silverware,
You might be a Redneck...

Print this item

  Anthem?
Posted by: zojojojo - 07-22-2010, 05:48 PM - Forum: The Game Everyone Loves To Play - Replies (24)

dunno if this has shown up or not (and i have no desire to trawl the forum looking) but:

The Star Spangled Banner (US National Anthem) (it's fiction, so Hendrix on guitar and Joplin on vocals... if that's not enough to stir his gift, nothing is) - Doug's position (whatever defensive structure he's attempting to hold) is unassailable for the duration. All incoming projectile weapons will explode harmlessly overhead, all incoming energy attacks will tint the air red and a USA flag will appear on a flagpole right behind him in a dramatic fashion. He has to be on top of his "defensive structure" as everything above that dramatic flag is considered "sky"

yes, this can make attending pretty much any major event without his tuneplug a pain in the ass.
-Z, Post-reader at Medium
----
If architects built buildings the way programmers write programs, the first woodpecker to come along would destroy civilization.

Print this item