Here are a few examples of how you can use the search feature:

Entering this and that into the search form will return results containing both "this" and "that".

Entering this not that into the search form will return results containing "this" and not "that".

Entering this or that into the search form will return results containing either "this" or "that".

Search results can also be filtered using a variety of criteria. Select one or more filters below to get started.

Assuming numbers is required, the following 40 results were found.

  1. MS Excel - Open CSV with Long Numbershttps://joellipman.com/articles/microsoft/excel/ms-excel-open-csv-with-long-numbers.html

    This is a quick reminder for myself on opening a CSV in MS Excel but without converting long numbers into exponential notations (which are incorrectly rounded anyway). My Data: Account ID,Name,Phone,Record ID...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB

  2. Prefix Line Numbers in a Text Filehttps://joellipman.com/articles/automation/ms-dos/prefix-line-numbers-to-a-text-file.html

    Right-click on "shell" and create a new key with the action name (eg. "Prefix_with_line_numbers") Right-click on this new key and add a key to this one called "command" Under the "command" key, double-click the "(Default)" string in the right-pane and...

    • Type: Article
    • Author: Joel Lipman
    • Category: MS-DOS
    • Language: *

  3. Windows OS: Alt Codes / Symbols / Special Charactershttps://joellipman.com/articles/microsoft/windows-os/windows-os-alt-codes-symbols-special-characters.html

    when you have lost the formatting and get weird question mark characters instead such as: . How? Ensure you are using the numbers on your numeric keypad and NOT the numbers at the top of your keyboard for the following steps. Also check that you have...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *

  4. Zoho Creator: Render to PDF with margins and page numbershttps://joellipman.com/articles/crm/zoho/zoho-creator-render-to-pdf-with-margins-and-page-numbers.html

    What? There are already articles out there that document this but I use this more and more and would rather just find it on my site than going through multiple bookmarks. Why? This use-case is for a customer who simply wanted a quote template to be...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *

  5. Format Numbers in AutoHotkey with Commashttps://joellipman.com/articles/automation/autohotkey/format-numbers-in-autohotkey-with-commas.html

    Just a quick note as I use this function in various scripts. This adds the 1000th separator comma: FormatAddCommas(val) { Result:=val StringLen, OutputVar, Result NumLoop := (OutputVar // 3) DNum = 3 Loop, % (NumLoop+1) { StringRight,Digit,Result,%DNum%...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB

  6. Zoho Deluge: Text (SMS) reminder using Twilio API (LocalSense)https://joellipman.com/articles/crm/zoho/zoho-deluge-text-sms-using-twilio-api-localsense.html

    a text message using Twilio API in Zoho Deluge. Why? The use-case here is that we want local sense dialing where specific numbers are used both for outbound and inbound but local to the customer and we want to remind our customer that they have an...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *

  7. Inserting incremental weeks in MySQLhttps://joellipman.com/articles/database/mysql/inserting-incremental-weeks-in-mysql.html

    Situation: I have a silly database table (not mine) storing CMIS Facility week numbers and their starting dates. For those of you unfamiliar with this system, the reason week numbers are different to normal people's week numbers is because these are...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB

  8. Alternate row background colour in Reporting Serviceshttps://joellipman.com/articles/microsoft/ssrs/alternate-row-background-colour-in-reporting-services.html

    Mod 2, "WhiteSmoke", "Garamond") This is telling the report to be white (=#ffffff) in row 1 (odd row numbers) and a very light grey (=#eeeeee) in row 2 (even row numbers). The first row being of all rows in the dataset and not for a particular...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *

  9. Generate Academic Calendar using MySQLhttps://joellipman.com/articles/database/mysql/generate-academic-calendar-using-mysql.html

    We have a specific timetabling system for academic institutions and all our staff/students follow academic week numbers as opposed to calendar week numbers. Why? The aim of this article is to quickly generate a calendar for a full academic year for...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB

  10. Zoho Deluge - Generate 5 Letter Booking Retrieval Codehttps://joellipman.com/articles/crm/zoho/zoho-deluge-generate-5-letter-booking-retrieval-code.html

    characters and another two which convert a number to 5 letters. Why? Zoho doesn't have a function to generate random numbers or strings. There are workarounds however. How? The first note is that there is something that can emulate a random number......

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *

  11. Zoho Deluge: Regex Rounding and/or Removing Trailing Zeroshttps://joellipman.com/articles/crm/zoho/zoho-deluge-regex-rounding-and-or-removing-trailing-zeros.html

    aware of is a regular expression. So the first expression I came up with worked to a certain point but didn't round up the numbers, in other words, it didn't remove the unnecessary zeros. Note that in the following regex, and if using Zoho Creator, you...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *

  12. Joomla Development: Possible XML Filtershttps://joellipman.com/articles/cms/joomla/joomla-development-possible-xml-filters.html

    to be a floating point value BOOL Forces the value to be true or false WORD Strips anything that is not letters (including numbers) ALNUM Forces the value to be alphanumeric (Letters and numbers only. No special characters) CMD Forces the value to be...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB

  13. ZCRM Client Script: Correct Decimal Fields OnLoadhttps://joellipman.com/articles/crm/zoho/zcrm-client-script-correct-decimal-fields-onload.html

    So we have a customer that has some decimal fields on the products module that are calculated and will sometimes return numbers with more than 6 decimal places. As this is more than specified on the ZohoCRM field properties, as soon as the staff user...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *

  14. T-SQL DateTimestampshttps://joellipman.com/articles/database/t-sql/t-sql-datetimestamps.html

    CURRENT_TIMESTAMP, 131) 14/11/1432 06:00:00:000AM I originally got a list from databases.aspfaq.com but the convert numbers didn't correspond to the output formats. This is my list created within my environment and setup (see above).

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB

  15. Joes FREE Website Thumbnailer (JWT)https://joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

    It ignores spaces before and after any text. If you haven't specified a name, then it just reverts to using 6 digit numbers. Question Something has happened to my images folder, does it matter? Answer: No, the program checks if a folder called...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *

  16. Before and After, Highs and Lowshttps://joellipman.com/articles/microsoft/ssrs/before-and-after-highs-and-lows.html

    I'm looking in the wrong place. Using Aggregate Functions? What follows is the T-SQL Query I finally went with. Lots of numbers but I think this pretty much answered my question: SELECT Catalog.Name AS ReportName , MIN(ExecutionLogStorage.TimeStart) AS...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *

  17. The ReportServer Databasehttps://joellipman.com/articles/database/the-reportserver-database.html

    need the size of the report but the value has to be returned as part of the aggregate query. I want the SQL to return just numbers and let the MDX query add the thousand separator. My answer for everything: CAST((TimeEnd - TimeStart) AS TIME)...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB

  18. MySQL last year week month day trend periodshttps://joellipman.com/articles/database/mysql/mysql-last-year-week-month-day-trend.html

    becoming an analyst, I do more at the database level now. What follows should be usable mySQL statements to get all the numbers: Yesterdays -- CURRENT: count todays SELECT COUNT(id) FROM Table1 WHERE DATE(registerDate)=DATE(NOW()); -- BEFORE: count...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB

  19. SSRS Zero Paddinghttps://joellipman.com/articles/microsoft/ssrs/ssrs-zero-padding.html

    5) -- "Right()" to say extract text from the right -- ".ToString" because it's likely you're doing this to a number and numbers just get rounded up without the prefixing zeros -- "00000" because we don't expect strings to exceed 5 characters. The Oracle...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *

  20. Getting the mysql where in delimited string to workhttps://joellipman.com/articles/database/mysql/getting-the-mysql-where-in-delimited-string-to-work.html

    I have a mySQL database table of room assets that has a field containing the ID numbers of images relevant to this room. The Problem? When I select specifying the statement "WHERE IN (c.RoomImages)", this is interpreted as a string and when converted to...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
Results 1 - 20 of 40

Joes Word Cloud

Please publish modules in offcanvas position.