Wow. I would totally break down and get a cell phone if that existed.
Buffy. When I saw you stop the world from, you know, ending, I just assumed that was a big week for you. Turns out I suddenly find myself needing to know the plural of 'apocalypse.'
Riley ,'Potential'
Buffistechnology 2: You Made Her So She Growls?
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!
Jon B. - Oct 04, 2005 10:42:16 am PDT #4744 of 10003
A turkey in every toilet -- only in America!
tommyrot - Oct 04, 2005 10:55:35 am PDT #4745 of 10003
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.
Got a problem.
If you have an html document that's just a table, you can import it into Excel and get a spreadsheet. Of course, for each cell in the table you get a cell in Excel. But if there's a line break (<br> tag) within a cell, it screws up when you open the html document in Excel - it's like Excel treats the line break as a cell delimiter.
What we're doing is taking the result of an Access query and importing it into Excel. We first save from Access to an HTML document, because if you go straight from Access to Excel there's a 255 character limit for each cell.
So, is there some other character we can insert into the html (doesn't matter if it does not produce a line break in html) that will produce a line break when opened in Excel?
We're using Excel 2002 SP2.
eta: Alternatly, will Excell correctly deal with carriage returns in a delimited text file? (Assuming some other delimiter besides carriage return.)
Sean K - Oct 04, 2005 11:05:53 am PDT #4746 of 10003
You can't leave me to my own devices; my devices are Nap and Eat. -Zenkitty
So, is there some other character we can insert into the html (doesn't matter if it does not produce a line break in html) that will produce a line break when opened in Excel?
Not even remotely sure this will work, but can't you do a find/replace on your HTML doc to replace all instances of t br with a ^M?
(ETA: Not entirely sure Excel will read a ^M as a carriage return, but I think it might)
tommyrot - Oct 04, 2005 11:06:40 am PDT #4747 of 10003
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.
Lemme try....
le nubian - Oct 04, 2005 11:08:45 am PDT #4748 of 10003
"And to be clear, I am the hell. And the high water."
Jessica,
that's a hot phone. Man.
le nubian - Oct 04, 2005 11:13:10 am PDT #4749 of 10003
"And to be clear, I am the hell. And the high water."
tommyrot - Oct 04, 2005 11:19:09 am PDT #4750 of 10003
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.
Nah, it ain't ^M. I'm searching for some other character that Excel will see as a new line....
brenda m - Oct 04, 2005 11:19:57 am PDT #4751 of 10003
If you're going through hell/keep on going/don't slow down/keep your fear from showing/you might be gone/'fore the devil even knows you're there
^l should give you a line break
Jon B. - Oct 04, 2005 11:22:03 am PDT #4752 of 10003
A turkey in every toilet -- only in America!
there is a 4 minute animation for the phone
I didn't realize you could make the phone automatically change shape when a call comes in or an alarm goes off. Wacky!
§ ita § - Oct 04, 2005 11:23:29 am PDT #4753 of 10003
Well not canonically, no, but this is transformative fiction.
Well, once they create the "liquid battery, speech recognition, flexible touch screen, [and] touch sensitive body cover," why not make it change shape? The world is your oyster.