Search - Joel Lipman .Com

1. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCase: / SQL Server Integration Services /; ... people on the net, I've been given a datasource with names and addresses all in UPPERCASE. Initially, no one seemed bothered but now the request came through asking if this could be restored to a normal ...; Created on 04 October 2013
2. Zoho Deluge: Convert Hex to RGB: / Zoho /; ... value v_HexValue = v_HexGiven.replaceAll("#", "").toUpperCase(); // // using a regular expression: split into pairs of characters or if short hex given, then split into 3 characters l_HexParts = v_HexValue.replaceAll("(?)",",",false).toList().subList(1,4); if(v_HexGiven.toString().len()>4) { l_HexParts ...; Created on 11 October 2024
3. Zoho Creator: Render to PDF with margins and page numbers: / Zoho /; ... td:nth-child(2){ font-size: 7pt; text-transform: uppercase; } #my-header .my-table tr td:nth-child(3){ text-transform: uppercase; font-size: 36pt; font-weight: 100; color: ...; Created on 07 May 2024
4. Zoho Deluge: Proper Case for Names: / Zoho /; ... Zoho Apps are incredibly case-sensitive and consider some records containing people's names as duplicates, when actually they are the same entity but may have uppercased a letter in their name while the ...; Created on 13 July 2023
5. Zoho Deluge: Get the Week Number if Week starts on a Monday: / Zoho /; ... we're generating a reporting year and week, we have to look at the difference between .toString("y") and .toString("Y"). Lowercase 'y' is the year and uppercase 'Y' is the year the week is in. Weeks which ...; Created on 06 July 2023
6. ZohoCRM: Import Attachments: / Zoho /; ... the Attachments.zip This needs to be a ZIP / compressed file of a folder called "Attachments" (uppercase A and the word Attachments - no other option). The Attachments folder must contain no subfolders ...; Created on 16 January 2023
7. Windows OS: Alt Codes / Symbols / Special Characters: / Windows OS /; ... 0167 † Dagger 0134 ‡ Double Dagger 0135 – en-dash 0150 — em-dash 0151 ¶ Paragraph Symbol (Pilcrow) 0182 Western Languages À Uppercase A grave 0192 Ã Uppercase A tilde 0195 Ä Uppercase ...; Created on 03 June 2021
8. Zoho Deluge - Generate 5 Letter Booking Retrieval Code: / Zoho /; ... v_Output; } This is my preferred method and it will return a string of 5 random uppercase letters. Method #2: Convert time to letters I've previously used substring to extract the milliseconds ...; Created on 09 May 2019
9. Zoho CRM: APIv2 using PHP & cURL: / Zoho /; What? This is an article documenting how to access ZohoCRM with API v2 using PHP and cURL. The first few functions are to manage OAuth v2 and generate the refresh and access tokens. The second snippet ...; Created on 30 January 2019
10. Convert XML UTF-16 to JSON UTF-8 with PHP cURL: / Personal Home Page /; Previously titled Fix PHP cURL: parser error: Document labelled UTF-16 but has UTF-8 content What? This is an article with notes for me on how to convert some received XML encoded in UTF-16 to ...; Created on 28 March 2015
11. Android Java: Remove first two entries from Google News feed in SimpleRssReader: / AndroidOS /; ... 11).toUpperCase()); holder.newsItemDesc.setText(items.get(position).getDesc()); return convertView; } static class ViewHolder { TextView newsItemTitle; TextView ...; Created on 24 October 2014
12. XML Schema Reference: / Extensible Markup Language /; ... than zero length Specifies the exact number of characters or list items allowed. Must be equal to or greater than zero maxExclusive Specifies the upper bounds for numeric values (the value ...; Created on 13 August 2014
13. Convert to Proper Case in T-SQL: / Transact-SQL /; What? So this is an article exploring how to convert UPPERCASE text into mixed case. The feed is originally for a personnel feed so it won't be converting long paragraphs of English text. Instead it ...; Created on 04 June 2014
14. PHP: First name and Initial of Surname: / Personal Home Page /; ... ' ')!==false){ $author_names=explode(' ', $author_name); $author_name_disp=ucfirst($author_names[0]).' '.strtoupper($author_names[1][0]).'.'; }elseif(strpos($author_name, '.')!==false){ ...; Created on 27 March 2014
15. Regular Expression Basic Usage Examples: / Web-Development /; ... within a character list that is a member of a specific POSIX Character Class. You can use this operator to search for characters with specific formatting such as uppercase characters, or you can search ...; Created on 28 October 2013
16. Things to Check if Joomla Password Reminder email not being sent: / Joomla /; ... email address (check uppercase&lowercase, etc)). Check Plugin Settings: Login to your Joomla Admin Panel Navigate to Extensions > Plug-in Manager > User – Joomla! Ensure “Notification Mail ...; Created on 09 May 2013
17. Data Randomization Function in Oracle PL/SQL: / Oracle PL/SQL /; ... v_rand_param2); ELSIF LENGTH(TRIM(TRANSLATE(p_original_value, 'ABCDEFGHIJKLMNOPQRSTUVWXYZ ', ' '))) IS NULL THEN -- Determined submitted value as 'ALPHAUPPER'; ...; Created on 22 August 2012
18. DBMS Random Reference: / Oracle PL/SQL /; ... sensitive data. How? SELECT DBMS_RANDOM.option1[(option2)] FROM DUAL; option1 can be: RANDOM VALUE STRING option2 can be: U (for Uppercase) L (for Lowercase) A (for AlphaNumeric) ...; Created on 21 August 2012
19. Returning Oracle Stored Procedure Resultset in SSRS: / SQL Server Reporting Services /; ... INITCAP(b.p_title) || ' ' || INITCAP(b.p_forenames) || ' ' || UPPER(b.p_surname) || ' (' || INITCAP(To_char(b.p_dob, 'DD-MON-YYYY')) || ')' "p_STUDENT_DETAILS", ...; Created on 19 January 2012
20. T-SQL Record Separator: / Transact-SQL /; ... = (SELECT TOP 1 WeekNumber FROM [pretendDatabase].[pretendSchema].[WEEKSTRUCTURE] WHERE StartDate BETWEEN DATEADD(day, 1, GETDATE()) AND DATEADD(day, 6, GETDATE())) ) AND upper(sd.[Descrip]) not ...; Created on 11 October 2011