Assuming find is required, the following 159 results were found.
-
apostrophes and double-quotes. You can change this but remember to put two double-quotes if you are searching on it, eg: FIND(""",B1) // will NOT work! FIND("""",B1) // will work FIND("″",B1) // will work You could merge all the statements into one but...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
Any Character — Dot The dot operator '.' matches any single character in the current character set. For example, to find the sequence--'a', followed by any character, followed by 'c'--use the expression: a.c This expression matches all of the...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
The Why So I find myself writing increasingly complex SQL scripts and it's at the stage where we need to optimize the queries because some scripts are noticeably slow (as observed by the customer...) and then others not. The What I'm going to run these...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
This is a quick note on finding the last occurrence of a string in a longer string. This has to be in Transact SQL for a SQL Server instance only and not filtered by other code. Why? I have a string such as the following (column positions added for demo...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
a dataset of 20k+ contact records and that's only half of the production system's contacts. I needed a quick bit of code to find any duplicates, all within the Zoho Creator app using Zoho Deluge and avoiding the use of any third-party APIs. How? My team...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
This issue happened with a friend who was trying to upload extensions. You should find that the configuration file is unwriteable (and that you can't change it using the joomla interface). In the end to resolve this, he had to do a fresh install and...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
What? A quick note on how to compare two columns for values that are not found in another. I have a column with old values, and now that I have a new list, I want a quick way to see what values are in the old column and which ones are new... Why?...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: *
-
What? Quick note on how to do this. I was tasked with cleaning up an english database by replacing all special alphabets (ë to e) and non-alphanumeric symbols with URL friendly characters. How? -- return all records that contain non-alphanumeric...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
ZohoCRM: Import Attachmentshttps://joellipman.com/articles/crm/zoho/zohocrm-import-attachments.html
An article for myself really as I couldn't find much online to address the errors I encountered below but also to document the import process of a bunch of files into a ZohoCRM system. Why? Our use-case here is a data migration for a client from a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
GDPR Privacy Policyhttps://joellipman.com/static-items/gdpr-privacy-policy.html
To periodically send promotional emails about new products, special offers, or other information which we think you may find interesting using the email address you have provided. From time to time, to contact you for market research purposes via email,...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
Privacy Policyhttps://joellipman.com/static-items/privacy-policy.html
We may periodically send promotional emails about new products, special offers or other information which we think you may find interesting using the email address which you have provided. From time to time, we may also use your information to contact...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: en-GB
-
Source: http://forum.joomla.org/viewtopic.php?f=431&t=401086&p=1693742#p1693742 It's been difficult to find an easy solution to hide menu items from registered users. Finally, I found a solution that works 100% for me using the MetaMod tool without...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
your current page. F5 or Ctrl+R Reloads your current page. Esc Stops the loading of your current page. Ctrl+F Opens the find bar. Ctrl+G or F3 Finds the next match for your input in the find bar. Ctrl+Shift+G, Shift+F3, or Shift+Enter Finds the previous...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
and Groups) which actually only means some minor database alterations. I've googled, yahood and binged, but still can't find a good way to upgrade my site from Joomla version 1.5 to 1.6 so as usual I find myself writing the first migration script. Why...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
webpages using JavaScript is not the primary aim of this tutorial, but it will prove valuable because you should be able to find plenty of useful JavaScript examples online. This will be helpful because in my opinion, the simplest way to start using COM...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
+ l_Params.toString("&")); // // if we got a response from the third-party API, let's go through the CRM picklist options to find the relevant one if(!isnull(r_Timezone.get("zoneName"))) { v_TimeZone = r_Timezone.get("zoneName"); // // get all the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
} if (queryParams.p_ShopifyID !== undefined) { v_ShopifyID = queryParams.p_ShopifyID; } // Setup a config to find this record (use a custom report that only has the 2 searchable fields) var config = { appName : "joes_quote_builder", reportName :...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
There may be other articles out there documenting this but I can't keep trying to find these in Google so referring to my own website, this is a doddle for me to find each time. Why? I have to do this so often that it deserves an article. Though writing...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: en-GB
-
for a friend and going through forums to investigate this error. After you've checked your database connection details, I find what FisherC said below is the most probable cause for the error. FisherC says: I have the same problem, but I'm not sure for...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
It took a few google searches until I could find out how to change the default weblinks order. A lot of websites showed how to do this via the admin back-end panel in the advanced configuration... I can't see this panel, there is no advanced parameters...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *