I'm trying find the best way to remove nonnumerical data from a varchar in SQL e.g.
'(082) 000-0000' to '0820000000' or
'+2782 000 0000' to '0820000000'
The difficulty is i'm not always sure what number formats are coming in, as shown above, so I'd like like everything that is not a number removed essentially.
Thanks in advance for a...
Are there any c (or c++) libraries out there that can take an array of numbers and do basic statistical analysis on it (mean, median, mode, whatever else might be interesting)?
...
In chapter 8 of Godel, Escher, Bach by Douglas Hofstader, the reader is challenged to translate these 2 statements into TNT:
"b is a power of 2"
and
"b is a power of 10"
Are following answers correct?:
(Assuming '∃' to mean 'there exists a number'):
∃x:(x.x = b)
i.e. "there exists a number 'x' such that x multiplied x equals b"
I...
I'm making a program that takes a snapshot of the screen, and saves it to a folder as a Bitmap picture. I seem to be running into a problem though, the picture just overwrites itself.
Can anyone tell me how I can make it so when it saves, the number will be one higher than the last? For example: Save 1: Screenshot0001.bmp Save 2: Screen...
I'm trying a basic test of sorting an NSManagedObject subclass. I set up a basic subclass "TestClass" with two attributes: stringField and numberField. They use the standard Obj-C 2.0 accessor protocol:
@interface TestClass : NSManagedObject
@property (retain) NSString *stringField;
@property (retain) NSNumber *numberField;
@end
@imple...
One of the cool things about VB6 is that if you add a line numbers to your code is that the ERL function will return it if an error occurs.
I use MZ-Tools for VB6 to add line numbers to the entire project, which is really cool, however, it's a pain to work with code that is numbered. So I typically remove the lines while I work on it.
...
I making a web app in Flex using global coordinates
I get the coordinates as strings from a web service then I do something like this:
latStr:String = "28.7242100786401";
longStr:String = "-106.12635420984";
var cLat:Number = new Number(latStr);
var cLong:Number = new Number(longStr);
This works PERFECT on IE and chrome, from the we...
Hey, I am trying to do a project euler problem but it involves adding the digits of a very large number. (100!)
Using java, int and long are too small.
Thanks for any suggestions
...
I have the following code:
SN.get_Chars(5)
SN is a string so this should give the 5th Char
Ok!
Now i have another code but : SN.get_Chars(0x10)
I wonder what 0x10 is? Is it a number? If it's so, then what is it in decimal notation?
...
int a = 10000000;
a.ToString();
How do I make the output?
10,000,000
...
Getting Serial Number of the Hard Drive
Provided by the manufacturer through PHP :
How can it be done?
I want to store it in a file.
OS : windows 2000,XP,ME,Vista...
Yes, I want the serial number of the hard drive of the Server.
Or can it be done through Adobe AIR?
Or can it be done through a C program on Windows?
C:\Documents and ...
Getting Serial Number of the Hard Drive Provided
by the manufacturer through Adobe AIR
How can it be done?
...
I wondering about how serial number generators and validator work. My aim would be to generate a serial number with five parts consisting of numbers and letters only.
I enjoy coding as a hobby and would not call myself a professional programmer. However, I am very interested in how those interesting functions work technically to broaden...
Hello guys, I have a question regarding this code. I'm a beginner and enjoy learning C#. But then I'm on the topic now called Array which is quite difficult and I need your help. I would like to understand the code.
What I don't understand here is what does the part 1, 2, 3, 4 and 5 here mean?
I don't understand what is the function of ...
Hi
I'm tryin' to find a script that will let me display "linenumber# and linenumber# as well as lines#-#" from a text file in a batch file? I found this script here on this site..
@echo off
setlocal enabledelayedexpansion
if [%1] == [] goto usage
if [%2] == [] goto usage
SET /a counter=0
for /f "usebackq delims=" %%a in (%2) do (
if "...
Hi,
Looking to make a really simple random number generator method in C. The numbers should be between 0 and 24 and can be for example 14.5f.
Any help would be great, thanks!
...
Hi, I have this number extracting problem.
I want to get all matches that don't have a certain number in it
ex : 125501874, 125001873
Every number that as 55 at the position 2 are not to be considered.
The first numbers range is 0 to 9 and the second is 1-9 so the real range is [01-99]
(we cannot have 00 as the first two number)
With L...
Hi all,
It appears that when you type in a number in java, the compiler automatically reads it as an integer, which is why when you type in (long) 6000000000 (not in Integer's range) it will complain that 6000000000 is not an integer. To make it shut up, I had to specify 6000000000L. I just learned about this specification.
Are there...
** READ BEFORE POSTING **
I am aware of the multiply and add solution but since these are arbitrary length numbers, the multiply and add operations are not free so I'd like to avoid them, if at all possible.
My challenge is this: I want to be able to take, as input, a character pointer to a number in base 2 through 16 and as a second p...
Hey Everyone,
I have a simple problem I have a phone like this: +1 (123) 123-1234 and I want to just take the numbers out of that string using regex.
Any help will be greatly appreciated.
Thanks
...