Assuming substring is required, the following 43 results were found.
-
v_PhotoWithExt = v_PhotoFull.getSuffix("/image/").getPrefix("\""); v_PhotoFileExtension = v_PhotoWithExt.subString(v_PhotoWithExt.lastIndexOf(".") + 1).toLowerCase(); // if(l_CompatiblePhotoExtensions.containsIgnoreCase(v_PhotoFileExtension)) {...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
{ // // store user input to a CRM record m_Create = Map(); v_Title = if(v_UserMessage.length()>40, v_UserMessage.subString(0,40) + "...", v_UserMessage); m_Create.put("Title", v_Title); m_Create.put("Content", v_UserMessage.trim()); m_Create.put("Role",...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
v_LeadCreatedTime = r_LeadDetails.get("Created_Time"); // // convert to time datatype v_TimeOffset = (v_LeadCreatedTime.subString(0,10) + " " + v_LeadCreatedTime.subString(11,25)).toString("yyyy-MM-dd HH:mm:ss", v_ThisTimeZone); // // set reminder time...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
1, 1), '/', SUBSTR(MD5(img_name), 1, 2), '/', img_name) AS img_path_with_file from wikimedia_image -- where -- SUBSTRING(img_timestamp, 1, 8)>=20110922 ORDER BY img_timestamp DESC Note that I've commented out the lines which specify images modified...
- Type: Article
- Author: Joel Lipman
- Category: MediaWiki
- Language: en-GB
-
@TableDeclaration nvarchar(4000); DECLARE @SqlToExecute nvarchar(4000); -- Set variable default values SET @TableName = SUBSTRING(@SchemaTableName, CHARINDEX('.', @SchemaTableName)+1, LEN(@SchemaTableName)); SET @SqlToExecute = ''; -- Declare temporary...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
SCh.name + '.' + ST.NAME ; UPDATE @SQLTbl SET SQLStatement = 'SELECT * INTO SearchTMP FROM ' + Tablename + ' WHERE ' + substring(WHEREClause,1,len(WHEREClause)-5) DELETE FROM @SQLTbl WHERE WHEREClause IS NULL WHILE EXISTS (SELECT 1 FROM @SQLTbl WHERE...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
Concatenation CONCAT(string1,string2[,stringN]) string1 + string2 SS v2012+: CONCAT(string1, string2 [, stringN ]) String Substring SUBSTRING( string,start,length ) SUBSTRING( string,start,length ) String Length LENGTH(string) BIT_LENGTH(string)...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
@stringtoReplaceWith, REPLACE(`content_column`, @stringtoFind, @stringtoReplaceWith) )>0,'yes','no') as OldFoundInNew, SUBSTRING(`content_column`, LOCATE( @stringtoFind, `content_column` )) as OldFind, REPLACE(`content_column`, @stringtoFind,...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
keycolumn is not null and data column is not blank. Derived Column Task: Format keycolumn as per your requirements and use substring on trimmed DataColumn to retrieve each data column. Additional The TRIM in SSIS does not appear to get rid of new line...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
determine English Ordinal Ordinals = "th,st,nd,rd".toList(); English_Ordinal = Ordinals.get(0); EO_Index = This_Day_Date.substring(This_Day_Date.length() - 1).toLong(); if((EO_Index == 1 || EO_Index == 2 || EO_Index == 3) && (This_Day_Date != "11" &&...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
{ // // init l_JSONItems = List(); // // parse the data v_MainNode = "ActiveList"; x_MainNode = r_ResponseXML.subString(r_ResponseXML.indexOf("
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
add 10 minutes, re-assemble it in a format that CRM likes, and update the field: // // parse date into yyyy-MM-dd (using subString - reliable) v_LeadCreatedDate = r_LeadDetails.get("Created_Time").subString(0,4) + "-" +...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
= input.Payload.getJSON("body"); v_MainNodeName = "GetItemTransactionsResponse"; x_MainNode = x_ResponseBody.subString(x_ResponseBody.indexOf("
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
the response if(r_ResponseXML.contains("Success")) { // // parse the data v_MainNode = "Item"; x_MainNode = r_ResponseXML.subString(r_ResponseXML.indexOf("
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
display later: if(!isnull(row.Document_File)) { v_FileDetected = row.Document_File; if(v_FileDetected.contains("_")) { v_SubstringStart = v_FileDetected.indexOf("_"); v_FilenameDetected = v_FileDetected.subString(v_SubstringStart + 1);...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
// other fields to fill in for this subform row v_RateCardDisp = v_RateCard.indexOf(" (")>0 ? v_RateCard.substring(0, v_RateCard.indexOf(" (")) : v_RateCard; json_Arg.Rate_Change_Notes = v_RateCardDisp; // get existing subform with only the displayed...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
orders in response v_OrderNodePart = "Order"; v_OrderNodeName = v_OrderNodePart + "Array"; x_OrderNode = x_ResponseBody.subString(x_ResponseBody.indexOf("
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
:POST parameters:x_Params headers:m_Headers ]; if(v_Page==1) { // // get page results x_PaginationResult = x_ResponseBody.subString(x_ResponseBody.indexOf("
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
results from the first iteration/page if(v_Page == 1) { // // get page results x_PaginationResult = x_ResponseBody.subString(x_ResponseBody.indexOf("
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
= ifnull(p_DownloadImageUrl,"https://joellipman.com/tmp/icon_linkedin.jpg"); v_FileName = v_ImageToDownload.subString(v_ImageToDownload.lastIndexOf("/") + 1); // // get file object f_File = invokeurl [ url :v_ImageToDownload type :GET ]; // // upload...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF