I am surprised to find how it works because I think it only works on integers and not decimals, etc. I ran it on this list: 1 10 .10 1.1 5.2 1,000.50 1,000 200...
14872
Don - HtmlFixIt.com
dpasseng
Mar 4, 2006 8:09 pm
So I say to self, "self, if you multiply the item by 100, that should move the decimal out of the way and get better results." Self was wrong ... why is x * 1...
14873
loro
yastupidhoo
Mar 4, 2006 9:36 pm
... Been there. In fact I found my post - from 2001. Jody confirmed number = integer. English question: what do you guys, in daily speech, call "numbers" that...
14874
Don - HtmlFixIt.com
dpasseng
Mar 4, 2006 10:19 pm
... Loro, Thanks so much for the response. I think I vaguely remember that discussion. I call anything that is a number a number in English. That function...
14875
loro
yastupidhoo
Mar 4, 2006 10:39 pm
... Oh. Clear as mud! Thank you. ... You are right. How strange. Bet there is a logical explanation as usual but I can't guess what it is. ln() seems to work...
14876
loro
yastupidhoo
Mar 4, 2006 11:10 pm
Don, It isn't only multiplication. A single letter a-z always is 0. Anyone knows why this is? a+1=1 a*1=0 a/1=0 a^1=0 1^a=1 a*a=0 For example these return an...
14877
John Wallace
johnta1
Mar 4, 2006 11:35 pm
I don't have any knowledge on this, just thinking out loud. I would say the 'a' is interpeted as not numeric and given a binary value of zero. Possibly the...
14878
Don - HtmlFixIt.com
dpasseng
Mar 5, 2006 12:00 am
... Hi Lotta, The above fails on this example: "1,00,00.10" Well I guess we could argue that is a number (begging that question again I suppose). At best, I...
14879
loro
yastupidhoo
Mar 5, 2006 12:20 am
... Come on! That isn't a (correctly written) number any way you see it. A writing convention maybe, but would you write it like that using a calculator? We...
14880
Don - HtmlFixIt.com
dpasseng
Mar 5, 2006 12:56 am
... I think we agree then :-) I probably didn't mean what I said or say what I meant. By fails I meant that it shows it to be a number when I would argue it...
14881
loro
yastupidhoo
Mar 5, 2006 8:56 pm
... "My" Notetab handles comma as well as period as decimal point. I don't know if that is programmed in Notatab or if it in some way pick the comma up from my...
14882
Don - HtmlFixIt.com
dpasseng
Mar 7, 2006 1:54 am
... hrs, we are on the basic list ... shouldn't this discussion move to the clips list and continue over there? Karl, if you want the solution, you need to...
14883
Don - htmlfixit.com
dpasseng
Mar 8, 2006 4:49 pm
... Dear Charles, This is a thread from a while back. I wanted to thank you again for the advice. I recently had occaision to write a clip for a client who ...
14884
Larry Hamilton
lm_hamilton
Mar 9, 2006 1:51 am
... Lotta, The IsNumber function is a True/False test. Either the selected information is a number or it is not. The Clip Help indicates that it returns 1 for...
14885
Don - htmlfixit.com
dpasseng
Mar 9, 2006 1:57 am
... Hi Larry, Of the things we tested only the following were numbers (according to isnumber): a. an integer b. any single letter of the alphabet (I consider...
14886
loro
yastupidhoo
Mar 9, 2006 2:46 am
... Except if it's a single letter! :-) ... It works, as I can use both period and comma. The problem is that a single alphabetic character returns true when...
14887
Don - htmlfixit.com
dpasseng
Mar 9, 2006 3:15 am
As we all know, the letter e is the most popular letter, so it demands to be treated differently during negotiations, don't you think?...
14888
loro
yastupidhoo
Mar 9, 2006 3:53 am
... I think it's nothing less than an insult that I can't calculate with å, ä and ö, that's what I think. I'll probably write to Jody about this. I demand...
14889
Larry Hamilton
lm_hamilton
Mar 9, 2006 4:34 am
... I'd like to buy a Q. ;-) I do not know if this behavior for IsNumber is a clip language bug or a problem with the infamous input control. I do not need...
14890
Bill Newman
wrnewman2
Mar 9, 2006 9:47 am
... I think the problem is with the definition of IsNumber in Help. It takes an argument of "Value" and then refers to "Value" as the "specified text". A...
14891
Don - htmlfixit.com
dpasseng
Mar 9, 2006 1:47 pm
... Your definition would have indeed been better than the one provided ... but I think it is more accurate to say integers (defined as all whole numbers...
14892
Hugo Paulissen
hugo_paulissen
Mar 9, 2006 2:47 pm
Don, You could try this... It fetches 4.96 as well as 5.0. And: 123,4234,976.345 4234,976.345 234,976.345 4234976.345 4234976345 1 (\d+,)*\d+(\.)*\d* Hugo...
14893
Jody
notetabber
Mar 9, 2006 10:05 pm
Hi Lotta and All, ... LOL! Actually, I have been trying to follow this thread, but my time is limited. I have sent posts to me to file it as a bug. I'm sure...
14894
Charles M. Raine
rainecus
Mar 10, 2006 3:48 am
Hi Don: ... Not quite correct Don as not all of your Calc statements are valid. Try the following to see what I mean. ^!Info [C]abcdetxy --...
14895
Hugo Paulissen
hugo_paulissen
Mar 14, 2006 9:28 am
Hi Don, You had a question about finding ^P and the difference in handling that in Pro and Light/Standard. I just saw that my message didn't reach the original...
14896
Jody
notetabber
Mar 15, 2006 11:18 am
Hi dpasseng, This was passed over to the Clips list from the [NTB]. Please look for replies here and let the [NTB] fizzle out. Go to the following link to sign...
14897
dvdwriters12
Mar 16, 2006 1:38 am
How do I test to see if the current selected text using ^& is blank or not (i.e. nothing selected) ?...
14898
loro
yastupidhoo
Mar 16, 2006 2:08 am
... After the texts is selected? Combine ^$IsEmpty$ and ^$GetSelection$. ^$IsEmpty$ returns true if the string is empty. ^!If ^$IsEmpty(^$GetSelection$)$...
14899
Vijay
bvr_1597
Mar 16, 2006 11:02 am
I am a newbie to Notetab.I want to import this data to Excel sheet..Any Ideas on how to make each column Tab delimited. The file containing the data is located...
14900
R Shapp
rayshapp
Mar 16, 2006 7:00 pm
Hi Charlie Raine, I downloaded the "Display Libraries + Clips Clipbook" from your site at >>> http://www.mts.net/~rainec/notetab.html Thanks for a very useful...
