Advanced Search

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 words is required, the following 52 results were found.

  1. Joes Word Cloud (JWC) Downloadhttps://www.joellipman.com/component/content/article/joes-word-cloud-jwc-downloads.html?catid=105&Itemid=165

    - Date Uploaded: Fri, 7th Dec 2012 1.6.8 - Enhancement: Integration: Include jEvents. - Bug Fix: Inclusion List now displays words in different sizes. - Date Uploaded: Thu, 27th Oct 2011 1.6.7.1 - Minor fixes for previous release - Date Uploaded: Mon,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Downloads
    • Language: *
  2. MySQL: Count occurrences of words in a columnhttps://www.joellipman.com/articles/else/database/mysql/mysql-count-occurrences-of-words-in-a-column.html

    This is an article to document how to output the most frequently used words in a MySQL database column. How? Note this only applies to MySQL. So the following query will return a count of each word in your database column by order of most used first...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  3. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://www.joellipman.com/component/content/article/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html?catid=74&Itemid=165

    we want to transform string ValueToConvert = p.GetValue(Row, null).ToString(); // PRIMARY transformation: Applies to all words // (lowercases and capitalizes first letter taking into account punctuation symbols) ValueToConvert =...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  4. PHP & MySQL Search Enginehttps://www.joellipman.com/articles/cms/website-development/php/php-a-mysql-search-engine.html

    $b){ $ax = $a["Score"]; $bx = $b["Score"]; if ($ax == $bx){ return 0; } return ($ax > $bx) ? -1 : 1; } # get the words we're going to display function search_return_keywords($str) { $search = array ( '@ @si', // Strip out javascript '@ @si', // Strip...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  5. Excel - Check a column for values found in another columnhttps://www.joellipman.com/component/content/article/excel-check-a-column-for-values-found-in-another-column.html?catid=110&Itemid=165

    (can be a range) and the second the string to search (in this case a single cell value). Sheet2!$A$1:$A$4 is the range of words to find from Sheet2. Note that there is a dollar in front of both column name (eg. "A") and the row number (eg. "1") so that...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  6. AutoHotkey: App GUI Listview to Rename Fileshttps://www.joellipman.com/component/content/article/autohotkey-app-gui-listview-to-rename-files.html?catid=48&Itemid=165

    Windows 7 Professional ; AutoHotkey: v1.33.02 ; Author: - ; Description: This program will remove the word EDIT and words containing an underscore (eg. 01_23) ; and then add an increment to the file name if a file with the same name exists. ; ; Date...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  7. Anti-Spam override for all submitted datahttps://www.joellipman.com/articles/cms/joomla/anti-spam-override-for-all-submitted-data.html

    getting a lot of spam, or junk messages sent via your Joomla site? I know certain components of Joomla let you put banned words but I know of even more that don't. If you find all your forms need extra plugins and captchas (such as JezRecaptcha), then...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  8. T-SQL functions to convert Strings to Tableshttps://www.joellipman.com/articles/else/database/t-sql/t-sql-functions-to-convert-strings-to-tables.html

    I'd note them on my site so I can refer to them more easily. How? Let's start with a function that just converts a string of words delimited by spaces to a table: CREATE FUNCTION dbo.[ufn_StringToTable] ( @StringInput VARCHAR(MAX) ) RETURNS @OutputTable...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  9. Preg_Replace all strings between two tagshttps://www.joellipman.com/articles/cms/website-development/php/preg-replace-all-strings-between-two-tags.html

    = preg_replace('#('.preg_quote($startPoint).')(.*)('.preg_quote($endPoint).')#si', '$0', $string_original); Replace all @words Convert: Hello @World » Hello @World $string_formatted = preg_replace( '/@[a-z]+/i','$0', $string_original); -- METHOD #2:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: *
  10. Joel's Reference to MidJourney v4 Promptshttps://www.joellipman.com/component/content/article/joel-s-guide-to-midjourney-prompts.html?catid=115&Itemid=165

    you can direct it to focus on the elements you want from a brief. How? A "prompt" is a text-to-image expression using words and phrases to instruct the Midjourney Bot (or any other AI text-2-image generator) which the bot can break down into "tokens"...

    • Type: Article
    • Author: Joel Lipman
    • Category: Graphic Design
    • Language: *
  11. Quadcopter App with Flight Restrictions (JQA)https://www.joellipman.com/component/content/article/quadcopter-app.html?catid=53&Itemid=165

    military air bases added Known Greek and French air bases added News Feed The news feed is a search on Google News for the words "Quadcopter" and "Drones". I use this to keep up-to-date with new legislation and developments on "drones". Tap once to see...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  12. Zoho Deluge - Generate 5 Letter Booking Retrieval Codehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-generate-5-letter-booking-retrieval-code.html

    Notes: As this was for a client who arranged outdoor activities for kids, I need to add a filter which blocks out swear words and the such. Experimental - DO NOT USE: string generateRetrievalCode() { //... refer to above functions } string...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  13. Zoho Deluge - Some Useful Regular Expressionshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-some-useful-regular-expressions.html

    World!"; v_FormattedString = v_MyString.replaceAll("[ ]+"," ",false); // yields Hello World! Remove consecutive duplicate words: // replace consecutive duplicates v_MyString = "Hello Hello Joe"; v_FormattedString = v_MyString.replaceAll(("([A-Za-z]+)...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  14. Zoho Deluge: Regex Rounding and/or Removing Trailing Zeroshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-regex-rounding-and-or-removing-trailing-zeros.html

    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 need to replace the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  15. Convert foreign characters to English alphabethttps://www.joellipman.com/articles/else/database/mysql/convert-foreign-characters-to-english-alphabet.html

    work properly as it thinks "riviere" is different to "rivière". We need to ensure that a search for any of these kind of words will return results of similarly typed/sounding words. How? Here's just a splurge of SQL but I use this often enough: UPDATE...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  16. Convert Past Date to Time Ago in PHPhttps://www.joellipman.com/articles/cms/website-development/php/convert-past-date-to-time-ago-in-php.html

    // full string 1 year 3 weeks 5 hours 7 seconds // where shown values are not zero Actually we just want the first two words of those strings: 3 days ago // where event is 3 days ago or just over but less than 4 days ago 1 week ago // where event is...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  17. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPUhttps://www.joellipman.com/component/content/article/pc-build-2022-5-monitors-connected-to-1-pc-using-1-gpu.html?catid=45&Itemid=165

    then another cable from the 1st monitor to the 2nd, and lastly another cable from the 2nd monitor to the 3rd (in other words, a Daisy Chain). New Setup Diagram: The graphics card (RTX 3060) can support up to 4 monitors but I only need 2 of the DP ports...

    • Type: Article
    • Author: Joel Lipman
    • Category: Articles
    • Language: *
  18. Forum Ruleshttps://www.joellipman.com/component/content/article/forum-rules.html?catid=50&Itemid=165

    No Profanity or Obscene Content - Such content does not belong on TEU. A censor system is in place as a backup. If you see words in your post being replaced with ****, you have done something wrong. Please edit your post and tone it down before your...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  19. Joes Word Cloud (JWC)https://www.joellipman.com/component/content/article/module-joes-word-cloud-jwc.html?catid=53&Itemid=165

    The further steps below are how to configure it to match yours or your clients brief. Style & Colors: Articles & Content: Words & Link: 3rd-Party Integration: Problems?:

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  20. Joes Syntax Styler (JSS)https://www.joellipman.com/component/content/article/joes-syntax-styler-jss.html?catid=53&Itemid=165

    that simply lets me style content within the tags: Use PHP or JavaScript (avoiding Framework conflicts) You select what words are highlighted what color. Uses separate CSS file for overall look. This is still in development! Currently this plugin is...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
Results 1 - 20 of 52