Assuming find is required, the following 168 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: *
-
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 Creator
- Language: *
-
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
-
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 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
-
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 CRM
- Language: *
-
- Type: Article
- Category: Static Items
- 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: *
-
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
-
on both the deal/opportunity and products module. A multi-user lookup will tend to have something like "ModuleName_X_Users". Find records relevant to this module: l_LinkedRecords = zoho.crm.searchRecords("Opportunities_X_Products","(Opportunity:equals:"...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- 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 CRM
- 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 Creator
- Language: *
-
Took us a while to find this and perhaps others would have a quicker way but here's the instructions on getting the records from the performance module in Zoho People API. Why? Cos it took us a while. The online forums seem to go back over a decade and...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
record on this invoice var o_LinkedDeal = ZDK.Page.getField('Deal_Name__s'); // if linked deal is blank, then see if we can find a relevant deal if (o_LinkedDeal.getValue() == null) { // if deal on the quote is not blank, then let's associate that one...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
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: *
-
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: *
-
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