Assuming string is required, the following 141 results were found.
-
WHILE (@i 0 BEGIN -- get the delimited word SET @CaseLen = CHARINDEX(',', @CaseExceptions, @i+1) - @i SET @CaseValue = SUBSTRING(@CaseExceptions, @i, @CaseLen) -- replace it in the original text SET @Ret = REPLACE(@Ret, ' '+@CaseValue+' ', '...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
below. Add a variable (preferably to the scope of the package) called "SourceExtractFile" and give it the data type "String". Set the Value to the full path and the first file including its extension (eg. "C:\Temp\SourceFiles\File00001.txt" - although I...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
// Create a criteria object to retrieve provider Criteria criteria = new Criteria(); // Get the name of the best provider String provider = locationManager.getBestProvider(criteria, true); // Get Current Location Location myLocation =...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
support). - Fixed bug: compilation failed for servers not supporting international characters. - Fixed bug: replaced string formatting foreach statements with legacy FOR statements. - Date Uploaded: Tue, 4th Jan 2011 1.4.1- Fixed compatibility with PHP...
- Type: Article
- Author: Joel Lipman
- Category: Downloads
- Language: *
-
to this app $CLIENT_ID = ''; // expecting *.apps.googleusercontent.com $CLIENT_SECRET = ''; // expecting alphanumeric string $STORE_PATH = ''; // expecting *.json - needs to be writeable by system account $SCOPES = array($GAPIS_AUTH . 'userinfo.email',...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
This is how I was doing it previously. // get the date (eg. 1, 2, 3,... 29, 30, 31) This_Day_Date = My_Date_Field.toString("d"); // determine English ordinal English_Ordinal = "th "; if(This_Day_Date == "1" || This_Day_Date == "21" || This_Day_Date ==...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
is a case-insensitive search with the first parameter being the text to search for (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...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
Why? Here are some examples of what we want to achieve: 1 year 2 months 3 weeks 4 days 5 hours 6 minutes 7 seconds // 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...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
function in Creator: = zoho.map.distanceBetween(, , ); // where unit can be "MILE", "KILOMETRE" or "NAUTICAL" Version 2019 string fn_getMilesBetweenCoords(float p_Lat1, float p_Lng1, float p_Lat2, float p_Lng2) { v_MathPi =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
CRM Users (ActiveUsers) from Creator or other Zoho App Note the use of .toMap() required for other apps to read this JSON string response: l_Users= List(); m_UserType = Map(); m_UserType.put("type","ActiveUsers"); r_Response =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
// // invokeurl r_Coql = invokeurl [ url :"https://www.zohoapis.eu/crm/v2/coql" type :POST parameters:m_Params.toString() connection:"crm_api_v2" ]; // // retrieve results if(!isNull(r_Coql.get("info"))) { v_MatchedCount =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
A very quick article on converting a Map string into a HTML table without using a for each loop. Why? I have quite a big response from our CRM that hits a statement execution limit if I use a for loop. I have a map with 3 columns: first_name, last_name,...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Category, I'm going to say Standalone Specify the Function parameters/Arguments EXACTLY as this: crmAPIRequest of data type string. IMPORTANT! It won't work if you don't include this parameter. For the code of the function this is what I did, you can...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Line:(442) How? It is written in the documentation albeit difficult to find: an integration field returns an ID as a string. If you want to assign it to an integration field, you have to convert it to a number with .toLong(). Say I have an integration...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Record Name"); } if(l_Errors.size() > 0) { alert "Please enter the following required fields:\n" + l_Errors.toString("\n"); } else { //... code to submit form/save to record here } Then save the data by adding the record or updating the existing record...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
CRM users table, find the value of the custom field and search for this (if it is a lookup to a module - only returns as string), and updates the Opportunity/Deal/Potential record. In this example, the custom field is called "Division": // // init...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
will contain the code triggered when one of the fields is changed Add an eTag field: Will hold a 32 hexadecimal character string / a hash of the fields to monitor Add the if statement to compare etags on your main workflow. Other fields needing to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
// // convert to xml and replace root nodes x_Params = m_Params.toXML(); x_Params = x_Params.toString().replaceFirst("",""); x_Params = x_Params.toString().replaceFirst("",""); // // send the request XML as a string r_ResponseXML = invokeurl [ url...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
} ] } */ You need to select the id of the template that you want to use for the next step (will be an alphanumeric long string). The button function Create a button off the contacts record by going to ZohoCRM > Setup > Customization > Modules and Fields...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
// // convert to xml and replace root nodes x_Params = m_Params.toXML(); x_Params = x_Params.toString().replaceFirst("",""); x_Params = x_Params.toString().replaceFirst("",""); // // send the request XML as a string r_ResponseXML = invokeurl [ url...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF