Hello? Gay now!

Willow ,'Showtime'


Buffistechnology 3: "Press Some Buttons, See What Happens."

Got a question about technology? Ask it here. Discussion of hardware, software, TiVos, multi-region DVDs, Windows, Macs, LINUX, hand-helds, iPods, anything tech related. Better than any helpdesk!


javachik - Jul 21, 2010 12:20:07 pm PDT #14488 of 25501
Our wings are not tired.

So just got told by IT that my new iPhone has arrived and is being configured. I should be excited yet am filled with ambivalence. Please tell me how silly I am being and that the iPhone 4 is magical and worth my $400?!


NoiseDesign - Jul 21, 2010 12:24:49 pm PDT #14489 of 25501
Our wings are not tired

I want an iPhone 4 very badly.


amych - Jul 21, 2010 12:26:46 pm PDT #14490 of 25501
Now let us crush something soft and watch it fountain blood. That is a girlish thing to want to do, yes?

javachik, MAGICAL SPARKLEPONIES


javachik - Jul 21, 2010 12:59:01 pm PDT #14491 of 25501
Our wings are not tired.

I am forgoing mani/pedis and meals out to budget for the magicphonesparklyness.


Jessica - Jul 21, 2010 1:40:26 pm PDT #14492 of 25501
And then Ortus came and said "It's Ortin' time" and they all Orted off into the sunset

Even with a Sansa clip, I'd have no way to get the files from the Internet to the device since Overdrive for Mac only recognizes mp3s.


Jon B. - Jul 21, 2010 4:06:06 pm PDT #14493 of 25501
A turkey in every toilet -- only in America!

What's the formula that I need to search a row to find out if any value contains a certain character? Not is equal to, but contains? I need to scan a range for "|", and I can't work out the simplest way. Everything I can think of is unduly convoluted.

I think writing a quick macro using the Find method will work, but maybe that counts as convoluted? [link]


§ ita § - Jul 21, 2010 4:12:08 pm PDT #14494 of 25501
Well not canonically, no, but this is transformative fiction.

Yeah, that counts as convoluted. I'll just go back to the SQL or something. I hate data.

Thanks, though.


le nubian - Jul 21, 2010 4:28:12 pm PDT #14495 of 25501
"And to be clear, I am the hell. And the high water."

ita, do you still need to know?

would this work?

[link]


§ ita § - Jul 21, 2010 4:31:22 pm PDT #14496 of 25501
Well not canonically, no, but this is transformative fiction.

The problem is I need to search a range (most of a row), not a cell. That's what's tripping me up. I guess I could concatenate those cells first--it's just dragging the formulas, in the end.

Thanks.


le nubian - Jul 21, 2010 4:38:45 pm PDT #14497 of 25501
"And to be clear, I am the hell. And the high water."

oh, I see. how many cells are in the row, roughly?