Berkeley CSUA MOTD:Entry 14943
Berkeley CSUA MOTD
 
WIKI | FAQ | Tech FAQ
http://csua.com/feed/
2025/05/25 [General] UID:1000 Activity:popular
5/25    

1998/11/11 [Computer/SW/Apps, Computer/SW/OS/Windows] UID:14943 Activity:high
11/10   I have a large .txt file with data in it that I want to open
        in excel. In order to do that, I need to delete all the
        carriage returns from the file. Whats the fastest way to do
        this?
        \_ If you have Word, you can search for returns ("^n", I think)
           and replace them with nothing, or a space.  Most word-processors
           should do this, but I assume that if you have Excel than you
           also have Word.  - mikeym
        \_ eh? you want to remove CRLF (PC returns) or just CR?
           Last I remember Excel imports fine with CRLFs.
        \_ as common an operation as this is, you'd think they'd put in a
           quick point'n'click operation to switch betwen unix and dos
           end-of-line format. Oh wait, this is a microsoft product -- there
           are no valid non-dos formats. -ERic
        \_ echo `cat infile.txt` > outfile.txt  -- yuen
2025/05/25 [General] UID:1000 Activity:popular
5/25    

You may also be interested in these entries...
2013/4/9-5/18 [Computer/SW/Languages/C_Cplusplus, Computer/SW/Apps, Computer/SW/Languages/Perl] UID:54650 Activity:nil
4/04    Is there a good way to diff 2 files that consist of columns of
        floating point numbers, such that it only tells me if there's a
        difference if the numbers on a given line differ by at least a given
        ratio?  Say, 1%?
        \_ Use Excel.
           1. Open foo.txt in Excel.  It should convert all numbers to cells in
	...
2008/9/1-3 [Computer/Companies/Google] UID:51015 Activity:moderate
9/1     THE GOOG had Scott McCloud do a comic explaining why THE GOOG Chrome
        (their open-source webbrowser) is cool.  I don't really think it worked
        http://blogoscoped.com/google-chrome
        \_ Oh boy, it comes with porn mode!
        \_ Oh boy, it comes with a porn hider feature!
           http://blogoscoped.com/google-chrome/22
	...
2008/3/17-21 [Computer/SW/Apps] UID:49481 Activity:kinda low
3/17    Is there a way to compare differences between two substantially
        similar Excel and/or Powerpoint documents other than going through
        them manually?
        \_ In Excel 2003, there is a "Compare and Merge Workbooks..." option
           under the Tools menu.  (But for some reason it is greyed out in my
           Excel 2003.)  In PowerPoint 2003 there is "Compare and Merge
	...
2008/1/5-7 [Computer/SW/Apps] UID:48895 Activity:moderate
1/5     I'm an Excel novice who needs help. Let us say I have a column of
        data A. I then take the absolute value of A1 and enter it in B1:
        (B1=ABS(A1)). All is good. My problem is when I want to delete
        Column A, Column B is still referencing A. How do I tell Excel to
        stop referencing the source data and instead let me have the
        result standalone? I don't want to keep A around anymore, but I
	...
2007/5/13-14 [Computer/SW/OS/Windows] UID:46613 Activity:nil
5/13    Someone please give us a 411 on Windows Vista? Is activation
        tougher than WinXP sp2? Is it impossible to get around now forcing
        you to pay for upgrades? Let me just say that I don't like Windows
        OS.  I don't mind using Microsoft Word, Excel, and Powerpoint,
        and they actually make decent games. However, for over a decade
        I've been sucked into using Windows3.0/95/98/2K/XP because
	...
2006/7/13 [Computer/SW/Apps] UID:43668 Activity:nil
7/13    In Excel, is it possible to average every 24th column in a particular
        row.  I googled this and found http://www.exceltip.com/st/Calculating_the_Average_Value_in_Every_Nth_Column,_Excluding_Zeros%09/862.html
        though I can't get it to work.  In my spreadsheet, I have
        =AVERAGE(IF((MOD(COLUMN(C156:CP156)-CELL("col",C156),24)=0),C156:CP156))
        It makes sense, but won't work.  It seems to do the if logic only
        on the first column, and then just average the entire range, rather
	...
2006/6/13-15 [Computer/SW/Security] UID:43377 Activity:nil
6/13    ok, memorizing all these passwords is driving me insane. I
        know this has been asked before but I cant find it: whats the
        best way to keep a password-protected file of very sensitive
        information? in this case, all my other passwords. thanks
        \_ I use http://www.bugmenot.com
        \_ Whatever happened to this single login thing called the
	...
2006/5/15-16 [Computer/SW/Apps] UID:43062 Activity:low
5/15    MS Excel question: I have a moderately large sheet with one column
        filled with entries that are in this form: "num; stuff", meaning
        it's a number followed by a semicolon followed by anything. Is there
        a way to split up this column into 2, with the first containing
        the number and the second containing everything after the semicolon?
        Thanks.
	...
2011/12/23-2012/2/6 [Computer/Rants] UID:54271 Activity:nil
12/23   http://venturebeat.com/2011/12/22/uc-berkeley-google-apps
        Oh noes! What Would Bill Gates Do?
        \_ http://lauren.vortex.com/archive/000701.html
           Microsoft to Transition Corporate IT to Google Apps
	...
2011/11/27-2012/1/10 [Computer/HW/Drives] UID:54244 Activity:nil
11/27   CalMail has been down for a few days (hardware failure and database
        corruption -- sounds like fun!) and is starting to come back online.
        Looks like they're planning to outsource all campus mail to either
        Google Apps or Microsoft 365 as part of Operational Excellence.
        <DEAD>kb.berkeley.edu/jivekb/entry!default.jspa?externalID=2915<DEAD>
        \_ http://ist.berkeley.edu/ciocalmailupdates/november-30-2011
	...
2011/11/8-30 [Computer/SW/Security, Computer/SW/OS/Windows] UID:54218 Activity:nil
11/8    ObM$Sucks
        http://technet.microsoft.com/en-us/security/bulletin/ms11-083
        \_ How is this different from the hundreds of other M$ security
           vulnerabilities that people have been finding?
           \_ "The vulnerability could allow remote code execution if an
               attacker sends a continuous flow of specially crafted UDP
	...
2010/4/28-5/10 [Computer/SW/OS/Windows] UID:53807 Activity:nil
4/28    Win 3.1 was more widely adopted than Win 3.0.  Win XP (5.1) was more
        widely adopted than Win 2k (5.0).  Now it looks like Win 7 (6.1) is
        going to be more widely adopted than Vista (6.0).  Is this a trend on
        Microsoft x.0 versions being bad?
        \_ duh.
        \_ "more widely adopted" ... well... what are you basing these numbers
	...
2009/12/2-9 [Computer/SW/WWW/Browsers] UID:53556 Activity:nil
12/2    IE usage down but still kicking the majority ass. Chrome is also
        rising up high, almost at the Safari level. Firefox isn't
        doing badly either. Sorry Opera, you had your chance.
        http://arstechnica.com/microsoft/news/2009/12/november-2009-browser-stats-ie8-passes-ie7.ars
        \_ As long  as Opera is the only browser you can use on your Wii,
           I see a fine long life ahead of it.
	...