Assuming string is required, the following 148 results were found.
-
This took me a while to find so I've posted an article below detailing how to parse or extract values from a string containing XML code. Why? I'm working with a system which stores XML strings in a database and rather than a separate file, it stores...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
p_original_value IN VARCHAR2, p_original_datatype IN VARCHAR2, p_original_range_1 IN VARCHAR2 DEFAULT NULL, -- no effect on strings p_original_range_2 IN VARCHAR2 DEFAULT NULL -- no effect on strings ) RETURN VARCHAR2 IS v_char_at NUMBER := 0; --...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
how do we guarantee that the system will understand the date correctly? How? It may be that when obtaining a date string and applying the method .toString("dd/MM/yyyy") is dependent on the settings. But making a date into a SQL format or from largest...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
went and carried out a benchmark test on the most popular ways of counting the occurrence of a specific word within a string of text. Source: http://hasin.wordpress.com/2007/04/30/c … functions And the result is First Run Count by Split+Count took :...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
This is a quick note to show you how to convert a given comma delimited string into a database table: Given: "Title,Forenames,Surname" Return: ID Value ------ ---------------- 1 Title 2 Forenames 3 Surname Note the below example omits the ID column and...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
post on some other regex (regular expressions) to format values in Zoho. How? The following will remove any non-digits: v_MyString = "Hello World 123"; v_MyFormattedString = v_MyString.replaceAll("[^0-9]",""); // yields 123 The following is used in...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
for this process). So first off, here's a reminder on the function that generates an access token from a refresh token: string API.fn_eBayConnect_AccessToken() { b_SandboxMode = false; v_Output = ""; if(b_SandboxMode) { r_Api =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
contact record Button Code: /* ******************************************************************************* Function: String fn_SendCreditApplication(Int p_ContactID) Label: Fn - Contact - Send Credit Application Trigger: Off a button on the contact...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
description, and set category to "Standalone": I'm calling mine "fn_Deals_RetrievePipeline" Give it the following code: string standalone.fn_Deals_RetrievePipeline(String p_DealID) { /*...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
= "fn_Accounts_GetCreditSafe"; // Prepare the parameters for the function call var m_Params = { "arguments": JSON.stringify({ "p_AccountID": v_EntityID }) }; ZOHO.CRM.FUNCTIONS.execute( v_FuncName, m_Params ) .then( function( r_SubData ){...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
mine "Fn - Submit Suspect Survey - Webhook" with internal name as fn_SubmitSuspectSurvey_Webhook and the parameter is a string called crmAPIRequest Give it the following code: string standalone.fn_SubmitSuspectSurvey_Webhook(String crmAPIRequest) { /*...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
Use this one to specify a default command timeout for the connection. Please note that the property in the connection string does not supercede the individual command timeout property on an individual command object....
- Type: Article
- Author: Joel Lipman
- Category: SQL Server
- Language: *
-
Command Prompt (6.1.7601) What? A quick article on how to rename multiple files using the command prompt and a bit of string manipulation. This example will rename files which contain the string " (Copy)" and replace it with nothing (so removes it). The...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: en-GB
-
document a HTML Entity decoder in Zoho Creator. Why? Sometimes when receiving data from a third-party, we may receive some strings containing "&" or " " and obviously want to display these as decoded HTML entities. (Zoho if you're listening)...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
and call it "Signature Image": /* ******************************************************************************* Function: String fn_Workdrive_HostImage(string p_DownloadImageUrl, string p_WorkdriveFolder) Label: Fn - Workdrive - Host Image Trigger:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
"Conversion failed when converting the varchar value 'B110' to data type int" then read on. How? So where does the 'B110' string come from, well from one of our tables which looks similar to the following: Table: DMExtractEmployeeTable...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
If you allow percents (%) or apostrophes (*) then you are asking for trouble. Note my redirect for errors. Split the first string "myFolder" with the slash (/) as a delimiter, controlling the syntax/format of your site URLs. For Example...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
through rows here but it wants the internal name here eg. "1234567890123_temp.pdf" // // build the URL l_BuildUrl = List:String(); l_BuildUrl.add(v_CreatorDownloadBase); l_BuildUrl.add(v_AppOwnerName); l_BuildUrl.add(v_AppLinkName);...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
m_SearchCriteria.put("searchOperator","After"); m_SearchCriteria.put("searchText",v_GivenDateFrom.subMonth(1).toString("dd-MMM-yyyy")); l_SearchCriterias.add(m_SearchCriteria); m_SearchCriteria = Map(); m_SearchCriteria.put("searchField","To");...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
was not working as expected. How? The quick answer is a regex that will replace any commas between two quotes with a custom string, to be exact: v_FormattedData = r_Data.replaceAll("(\"[^\",]+)[,]([^\"]+\")","$1|mySpecialComma|$2",false); The slightly...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *