Tag Info

Hot answers tagged

15

Using regedit, remove the key HKCU\Software\Sysinternals\Process Explorer, then start Process Explorer. I would suggest to first Export the key, just in case.


11

awk is probably the canonical tool for this kind of problem. $ cat data foo 200 bar foo 200 baz bar 4 baz $ cat data | awk '$2 != 200 { print $0 }' bar 4 baz


11

Have you tried using Text to Columns? Highlight the column that contains your list. Go to Data > Text to Columns. Choose Delimited. Click Next. Choose Comma. Click Next. Choose General or Text, whichever you prefer. Leave Destination as is, or choose another column. Click Finish. You could also use two formulas in two separate columns. To get the ...


6

This is the simplest way I would do that with just a formula.... if the values are in columns A and B, then this formula in C1, then copied down as far as you want, it will show blanks when the values run out: =IF(ROW()<=COUNTA(A:A), INDEX(A:A,ROW()), IF(ROW()>COUNTA(A:B), "", INDEX(B:B,ROW()-COUNTA(A:A))))


5

Try this in your ~/.vimrc: au BufRead * let &numberwidth = float2nr(log10(line("$"))) + 2 \| let &columns = &numberwidth + 80 Every time you load a buffer (i.e., open a file), that will determine the number of columns required to show the largest line number, set the 'numberwidth' option accordingly, and set 'columns' to that number ...


4

I'm not sure if it's possible to enable the 'Dimension' attribute (nor 'Resolution') to make it just as easy to add these columns to any folder as the "normal" ones. But if you want to add one or both to folders which don't display these attributes then: Temporarily change the name of the folder to any name that starts with the characters "Pictures" (case ...


4

Use column. Example: ls -1 | column -c 100 This will format the output of ls -1 (one entry per line) to fit as many columns of equal size as possible in rows that are 100 character wide.


4

If the cell you want to reference is A3, make your formula: =$A$3 The dollar signs make the cell reference absolute, so they won't be adjusted relative to where you paste.


4

You want an array formula... Assuming your data starts in A1, you can type: =MEDIAN(A1:A3*B1:B3) and the press Ctrl + Shift + Enter to enter it into the cell as an array formula. If you do it correctly, you'll see the formula enclosed in curly braces by Excel.


4

Is it what you are looking for? Convert columns to rows, or rows to columns


4

Yes. You need to be connected to an Active Directory domain. Then you can select a range and go Review > Allow Users to Edit Ranges. Click the New button and set a password Click the Permissions button and then add users or groups from your domain address book As with all other cell protection, this only applies after the sheet is protected.


4

cut -sf2 -d' ' list.tab|sed -e 's/\..*/\"/' meaning cut only the second field in lines with separators (space) replace the dot and anything that follows with quotation marks.


3

Input into B3 = C3 * C$2 and then copy down. C$2 is known as mixed cell reference. In this case, as the dollar sign ($) is put in front of the row number (2). It can help to fix the row number when copying. Reference: http://blogs.office.com/b/microsoft-excel/archive/2011/08/17/making-sense-of-dollar-signs-in-excel.aspx Absolute cell references ...


3

This question appears to be very similar to http://stackoverflow.com/questions/11963720/multi-column-terminal-multiplexer. See answers over there. The only implementation I am aware of is my own two column virtual terminal. Feedback (via email) is welcome.


3

The csv.vim - A Filetype plugin for csv files also supports tab-delimited files, and has :ArrangeColumn and :UnArrangeColumn commands for that.


3

Copy/Paste the text into a text editor Replace all space characters with carriagereturn/linefeeds Save as a TXT file. Open the file in Excel.


2

Here is a messy way you could do it that involves the ADDRESS and INDIRECT formulas (sample data assumed to be in A1:B6: =COUNTIF( INDIRECT(SUBSTITUTE(ADDRESS(1,MATCH("Priority",1:1,0),4),"1","") & ":" & SUBSTITUTE(ADDRESS(1,MATCH("Priority",1:1,0),4),"1","")), 1) Basically what it does is finds the column matching Priority in ...


2

My Answer: =COUNTIF(OFFSET($A:$A,0,MATCH("Priority",1:1)-1),1) Now to explain: Offset($A:$A,0,X) returns the entire column starting with the first offset by X where in this situations X = MATCH("Priority",1:1) - 1. Because MATCH("Priority",1:1) return the column number, we must subtract 1 to get the proper offset. Then the last bit ,1) is indicating we ...


2

I don't think you can, at least not in any version of Excel I've seen. The left hand side starts with a column's left margin, and that's it. A couple of options you do have: Decrease the width of the column, add wrapping to any cells that go beyond the edge of the cell and view the contents in a multi-line format. This is probably how you want to provide ...


2

this is a pretty obscure vtXX feature and would mess with other panes in the same tmux window, so this is not supported. If you can modify the application, you can have it send \ePtmux;\e\e[?3h\e\\ to pass through a raw escape sequence to the underlying terminals (\e=Escape,\\=Backslash)


2

In the same thread you pointed as a reference, there is a user proposing a UDF to solve the problem. Search for SUMRANGEWITHEXCEPTION in the text. With care you may also follow the Excel 2007 help: If you want to keep the circular reference, you can enable iterative calculations but you must determine how many times the formula should recalculate. ...


2

I found the answer myself. There's no setting for this, but I managed to do this by modifying the source code. The file "includes/CategoryPage.php" has a function "columnList", by changing the two numbers "3" to whatever you want will do it.


2

I don't understand why do you need this... But you could achieve a similar view with the details view by removing every details except name. (Right click the header)


2

In Vista it was considered a feature. It must have confused some people though - for example, pray do tell, why oh why does an icon based list view have column titles !!!!!! So for Windows 7, Explorer reverted back to the behavior of XP - to quote Microsoft: Note that column headings are available only in Details view. So the bottom line is that ...


2

The solution (open source, freeware, so you can see how it does what it does): go to https://github.com/ijprest/Explorer7Fixes and download latest version (Explorer7Fixes.1.0.0.2.zip), register dll, then logoff or restart to see changes.


2

awk '$2 {oFS=FS; FS="."; $0=$2; print $1"\""; FS=oFS}' input For all lines that have a second field: save the current FS value set FS to . force awk to re-split the second field on the new FS print the first field (and a trailing quotation mark) set FS back to its original value


1

When you have properly space-aligned the table (with the mentioned Tabularize or the alternative Align plugin), you can then convert the spaces to tabs with the following commands: :%retab! :%substitute/ \+/\t/g The first command replaces indent with tabs where possible without changing the widths (this assumes you've :set noexpandtab), the second then ...


1

Normally you only see this when the worksheet/workbook is protected. Try it with a macro. For example: Sub Test() Columns("A:C").ColumnWidth = 20 End Sub When protected then you get a message that it is unable to set the ColumnWidth property.


1

This should give you what you want: columns=`head -1 datafile.txt | wc -w` for i in `seq 1 $columns` do awk '{print $'$i'}' < datafile.txt > Column$i.txt done This assumes that all the rows in the file have the same number of columns as the first row.



Only top voted, non community-wiki answers of a minimum length are eligible