SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://www.joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

04 October 2013 { // declare two arrays string[] exceptionArray_this; string[] exceptionArray_that; // get the value we want to transform string ValueToConvert = p.GetValue(Row, null).ToString(); // PRIMARY transformation: Applies to all words // (lowercases and...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• Language: en-GB

PHP: First name and Initial of Surnamehttps://www.joellipman.com/articles/web-development/php/php-first-name-and-initial-of-surname.html

27 March 2014 So different ways, the first thing I did was to create the logic: // default $author_name_disp=$author_name; // check and transform if(strpos($author_name, ' ')!==false){ $author_names=explode(' ', $author_name);...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

PHP & MySQL Search Enginehttps://www.joellipman.com/articles/web-development/php/php-a-mysql-search-engine.html

09 March 2011 # 2 functions to split up search terms and accepting double-quotes as phrase makers. function search_transform_term($term){ $term = preg_replace("/(\s)/e", "'{WHITESPACE-'.ord('\$1').'}'", $term); $term = preg_replace("/,/", "{COMMA}", $term); return...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

SSIS Multiple Lookups in onehttps://www.joellipman.com/articles/microsoft/ssis/ssis-multiple-lookups-in-one.html

05 August 2014 phase in the SSIS package takes data from a source database and puts it in staging in the exact form it came through. Our transform package will convert the data and output it to the target system. For our package to decode what "M" means, it needs to...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• Language: en-GB

CSS Center an iFrame Horizontally and Verticallyhttps://www.joellipman.com/articles/web-development/css/css-center-an-iframe-horizontally-and-vertically.html

23 September 2019 Horizontally and Vertically Centered Iframe CSS: body { background:red; } iframe { position: fixed; top: 50%; left:50%; transform: translate(-50%, -50%); } DEMO: See my JSFiddle demo: https://jsfiddle.net/Jlipman/u5sew3ob/21 and modify the height of the...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: en-GB

Zoho Creator: Add a subform while creating a recordhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-add-a-subform-while-creating-a-record.html

14 July 2021 so... do your own... // // get source data r_QuoteDetails = zoho.crm.getRecordById("Quotes", 123456789012345678); // // transform variables for main record v_QuoteName = ifnull(r_QuoteDetails.get("Name"),"Test Quote");...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM: Get Unique Values of a Text Fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-get-unique-values-of-a-field.html

08 October 2021 in a CRM module. Why? My use-case is a data-migration where the records exist in a staging module in CRM but I want to transform/translate one of the column values into the target How? So this is my plan: Setup a connector to CRM with the scopes...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM: Import Attachmentshttps://www.joellipman.com/articles/crm/zoho/zohocrm-import-attachments.html

16 January 2023 v_OriginalFileFull := A_LoopFileFullPath v_OriginalFilePath := StrReplace(A_LoopFileFullPath, v_FolderToSearch "\", "") ; transform FormatTime, v_TimeModified, %A_LoopFileTimeModified%, dd/MM/yyyy hh:mm:ss FormatTime, v_TimeCreated,...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Signhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-sign-send-crm-merged-template-for-zoho-sign.html

06 August 2024 each m_Result in l_SearchResults { // init v_Index = v_Index + 1; v_RelatedListXML = v_RelatedListXML + ""; // // retrieve/transform values from record v_ZohoSignDoc_ID = m_Result.get("id"); v_ZohoSignDoc_Name = m_Result.get("Name"); v_LinkName1 =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Convert Hex to RGBhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-convert-hex-to-rgb.html

11 October 2024 added to the value of the 2nd; this equals the RGB value. Given #00FF00 // // given value v_HexGiven = "#00FF00"; // // transform or format the submitted value v_HexValue = v_HexGiven.replaceAll("#", "").toUpperCase(); // // using a regular expression:...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *