How to merge rows in a column into one cell in excel?
E.g ``` A1:I A2:am A3:a A4:boy ``` I want to merge them all to a single cell "Iamaboy" This example shows 4 cells merge into 1 cell however I have many cells (more than 100), I can't type them one...
Why doesn't Console.Writeline, Console.Write work in Visual Studio Express?
I just open a console application and I type ``` Console.WriteLine("Test"); ``` But the output window doesn't show this. I go to the output window with + , . But nothing shows up when I run my progr...
- Modified
- 17 Jan at 21:40
What is a "callback" in C and how are they implemented?
From the reading that I have done, Core Audio relies heavily on callbacks (and C++, but that's another story). I understand the concept (sort of) of setting up a function that is called by another ...
How can I run a C program on Mac OS X using Terminal?
I am new to C. Here is my "Hello, World!" program. ``` #include <stdio.h> int main(void) { printf("Hello, World!\n"); return 0; } ``` After I try to run it using Terminal it says: ``` /Users/mac...
Search an Oracle database for tables with specific column names?
We have a large Oracle database with many tables. Is there a way I can query or search to find if there are any tables with certain column names? IE show me all tables that have the columns: `id, fn...
TypeError: 'str' does not support the buffer interface
``` plaintext = input("Please enter the text you want to compress") filename = input("Please enter the desired filename") with gzip.open(filename + ".gz", "wb") as outfile: outfile.write(plaintext...
How to create module-wide variables in Python?
Is there a way to set up a global variable inside of a module? When I tried to do it the most obvious way as appears below, the Python interpreter said the variable `__DBNAME__` did not exist. ``` .....
How to list all installed packages and their versions in Python?
Is there a way in Python to list all installed packages and their versions? I know I can go inside `python/Lib/site-packages` and see what files and directories exist, but I find this very awkward. W...
- Modified
- 8 Jul at 02:11
Difference between File.separator and slash in paths
What is the difference between using `File.separator` and a normal `/` in a Java Path-String? In contrast to double backslash `\\` platform independence seems not to be the reason, since both version...
- Modified
- 21 Aug at 07:29
Which Radio button in the group is checked?
Using WinForms; Is there a better way to find the checked RadioButton for a group? It seems to me that the code below should not be necessary. When you check a different RadioButton then it knows whic...
- Modified
- 25 Nov at 16:51
Flatten list of lists
I'm having a problem with square brackets in Python. I wrote a code that produces the following output: ``` [[180.0], [173.8], [164.2], [156.5], [147.2], [138.2]] ``` But I would like to perform so...
Convert date to YYYYMM format
I want to select value = `201301` ``` select getdate(), cast(datepart(year, getdate()) as varchar(4))+cast(datepart(MONTH, getdate()) as varchar(2)) ``` it returns `20131` what is the normal way t...
- Modified
- 9 Nov at 05:24
HTML5 Audio stop function
I am playing a small audio clip on click of each link in my navigation HTML Code: ``` <audio tabindex="0" id="beep-one" controls preload="auto" > <source src="audio/Output 1-2.mp3"> <source ...
- Modified
- 12 Feb at 14:12
Error: allowDefinition='MachineToApplication' beyond application level
I have downloaded the online project in ASP.Net. While running application I get an error > It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application l...
- Modified
- 15 Oct at 23:29
Is there an arraylist in Javascript?
I have a bunch of things I want to add into an array, and I don't know what the size of the array will be beforehand. Can I do something similar to the c# arraylist in javascript, and do `myArray.Add(...
- Modified
- 17 Nov at 13:15
YouTube API to fetch all videos on a channel
We need a video list by channel name of YouTube (using the API). We can get a channel list (only channel name) by using the below API: ``` https://gdata.youtube.com/feeds/api/channels?v=2&q=tendulka...
- Modified
- 22 Feb at 13:0
How to display a Yes/No dialog box on Android?
Yes, I know there's AlertDialog.Builder, but I'm shocked to know how difficult (well, at least not programmer-friendly) to display a dialog in Android. I used to be a .NET developer, and I'm wonderin...
- Modified
- 17 May at 21:24
How to use moment.js library in angular 2 typescript app?
I tried to use it with typescript bindings: ``` npm install moment --save typings install moment --ambient -- save ``` test.ts: ``` import {moment} from 'moment/moment'; ``` And without: ``` np...
- Modified
- 3 Feb at 00:4
Oracle SQL query for Date format
I always get confused with date format in ORACLE SQL query and spend minutes together to google, Can someone explain me the simplest way to tackle when we have different format of date in database tab...
Writing a VLOOKUP function in vba
I'm trying to lookup a value on a spreadsheet within a table array using the VLOOKUP function in my vba code. I don't know how to write it correctly. Here is the normal VLOOKUP formula with all the ...
Disallow Twitter Bootstrap modal window from closing
I am creating a modal window using Twitter Bootstrap. The default behavior is if you click outside the modal area, the modal will automatically close. I would like to disable that -- i.e. not close th...
- Modified
- 29 Jul at 18:29
How to print register values in GDB?
How do I print the value of `%eax` and `%ebp`? ``` (gdb) p $eax $1 = void ```
- Modified
- 14 Jun at 23:30
How to paginate with Mongoose in Node.js?
I am writing a webapp with Node.js and mongoose. How can I paginate the results I get from a `.find()` call? I would like a functionality comparable to `"LIMIT 50,100"` in SQL.
- Modified
- 26 Jun at 15:18
How to fast-forward a branch to head
I switched to after developing on a branch for a long time. The log shows: > Your branch is behind 'origin/master' by 167 commits, and can be fast-forwarded. I tried: ``` git checkout HEAD ``` It do...
- Modified
- 12 Nov at 04:15