Assuming number is required, the following 160 results were found.
-
top ten chart of your data (eg. movies, music, etc). My aim is to do the following: retrieve data from a table, count the number of times each data exists, sort it in reverse order so that the most frequent is at the top of the list print out each row...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
Just a quick note to refine a function that will take a date in the past and return the number of years, months, weeks, days, hours, minutes and seconds. Why? Here are some examples of what we want to achieve: 1 year 2 months 3 weeks 4 days 5 hours 6...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
twice: It is prompting you for the range of all the data to apply this to (eg. $A1:$W36000). You are then prompted for the number of rows per sheet (eg. 3000). In my example, this will produce an extra 12 worksheets in this file. Using the above module,...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
A --------------- warm noise term wreck The formula to paste in column B of Sheet1 is as follows: =SUMPRODUCT(--ISNUMBER(SEARCH(Sheet2!$A$1:$A$4,Sheet1!A1)))>0 Where: SumProduct( is a function to multiply two ranges together (must be the same size) and...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
to create from the SQL and paste in the next step) > Next In Step 3: give it a table name and hit “Create” In Step 4: (no number?) edit Schedule, add records and replace if already exists, ID, Include new columns > Next In Step 5: (still no number?) set...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
CMS 2.5.x Joomla Filter: Validation OnSave INT Forces the value to be an Integer UINT Forces the value to be an absolute number (-4.2 becomes 4.2) FLOAT Forces the value to be a floating point value BOOL Forces the value to be true or false WORD Strips...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
Typing an ASCII character In DOS: Hold down the key while typing the decimal number on the keyboard keypad. (Example: 178) In Windows for a DOS character: Hold down while typing the decimal on the keyboard keypad. (Example: 230) In Windows for a WIN...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
with upper case alphabets) P (for Printable characters only) Usage select dbms_random.random from dual; -- yields random number, eg. 68489408 select dbms_random.value from dual; -- yields values between 0 and 1 select dbms_random.value(1,1000) myAlias...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: *
-
to installing a Virtuemart UK Credit Card Payment Module (vm-ukcreditcard). A lot of forums were suggesting to change the number_format to convert any number to a currency or two decimal places. Another suggestion was to alter the main virtuemart...
- Type: Article
- Author: Joel Lipman
- Category: Virtuemart
- Language: *
-
" F " htmlText:=htmlText " S " htmlText:=htmlText " S " htmlText:=htmlText " " htmlText:=htmlText "" ; GET NUMBER OF DAYS THIS MONTH ; Haven't found anyone who calculates how many days there are in a month so this is a crude solution ; This checks if...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
the value of the Search for Author Input Box, which is the 4th element on the webpage with an INPUT Tag: (Note - the item number may be dynamic) Code: javascript: alert(document.getElementsByTagName('input')[3].value) MsgBox %...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
List, List, %Omit% DllCall( "ImageHlp\UnMapAndLoad", UInt,&$LI ) Return List } ExitApp Examples of DllCall'ing: // get number of network card interfaces DllCall("iphlpapi\GetNumberOfInterfaces", "UintP", nIf) MsgBox % nIf... // get current process ID...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
; converts Size (in bytes) to byte(s)/KB/MB/GB/TB (uses best option) ; decimalPlaces is the number of decimal places to round ; -------------------------------------------------------------------------------------- autoByteFormat(size, decimalPlaces =...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
Forum Ruleshttps://joellipman.com/component/content/article/forum-rules.html?catid=50&Itemid=165
and you will lose 10 postcount for each of the posts excluding the first one. Your post count can be changed to a negative number if necessary. The only exeption to this rule is if your edit timer (24 hours) for the post has run out, in which case you...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
:: eXclude Junction points for Directories. /XJF :: eXclude Junction points for Files. :: :: Retry Options : :: /R:n :: number of Retries on failed copies: default 1 million. /W:n :: Wait time between retries: default is 30 seconds. /REG :: Save /R:n...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: en-GB
-
server logs. This gives data as to your unique visitors (referred to as visitors), the visits these generated (visits), the number of files/scripts/images requested (hits) and their filesize (bandwidth). Purpose: To extract all data into a Comma...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
Open the terminal app on your Mac and type the following to test the install: node –v npm –v You should get a version number for each of these as a response. Failing this you should check your security and privacy and ensure that you have permission to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
There are other ways to verify your custom domain such as TXT, which I feel has the same difficulty level and equal number of steps as verifying by CNAME; or by uploading a HTML verify file which I tend to forget to delete afterwards and involves just...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
integration field returns an ID as a string. If you want to assign it to an integration field, you have to convert it to a number with .toLong(). Say I have an integration field on my form called "CRM Account" with field link name "Account"; Then I have...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
Done: Additional Remember that an integration field on the interface is returned as a string and needs to be converted to a number to be assigned, eg: r_Details = myForm[ID == 1234567980123456789]; r_Details.Account = input.Account.toLong();
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *