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 Visual C# 2008 What? So like lots of 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 case, a...

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

Zoho Creator: Render to PDF with margins and page numbershttps://www.joellipman.com/articles/crm/zoho/zoho-creator-render-to-pdf-with-margins-and-page-numbers.html

07 May 2024 .my-table tr td:first-child{ width: 175px; } #my-header .my-table tr 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: #777;...

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

Convert to Proper Case in T-SQLhttps://www.joellipman.com/articles/database/t-sql/convert-to-proper-case-in-t-sql.html

04 June 2014 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 will be applied to names and addresses as well as job titles...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: en-GB

DBMS Random Referencehttps://www.joellipman.com/articles/database/pl-sql/dbms-random-reference.html

21 August 2012 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) X (for Alphanumeric with upper case alphabets) P (for Printable characters only)...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: *

Regular Expression Basic Usage Exampleshttps://www.joellipman.com/articles/web-development/regular-expression-basic-usage-examples.html

28 October 2013 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 for special characters such as digits or punctuation characters. The full set of POSIX...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Unix Date Format Specifiershttps://www.joellipman.com/articles/linux/unix-date-format-specifiers.html

05 July 2011 locale's date representation (mm/dd/yy) 07/4/2011 %F %Y-%m-%d 2011-07-4 Hours %l (Lowercase L) hour (12 hour clock) 1 %I (Uppercase I) hour (12 hour clock) zero padded 01 %k hour (24 hour clock) 13 %H hour (24 hour clock) zero padded 13 %p locale's...

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

Data Randomization Function in Oracle PL/SQLhttps://www.joellipman.com/articles/database/pl-sql/data-randomization-function-in-oracle-plsql.html

22 August 2012 'FLOAT') random_float, -- testing decimal UFN_DATASCRAMBLE('ABCDEFGH', 'VARCHAR') random_upper, -- testing uppercase UFN_DATASCRAMBLE('abcdefgh', 'VARCHAR') random_lower, -- testing lowercase UFN_DATASCRAMBLE('ABCDefgh', 'VARCHAR') random_both, --...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

Things to Check if Joomla Password Reminder email not being senthttps://www.joellipman.com/articles/cms/joomla/things-to-check-if-joomla-password-reminder-email-not-being-sent.html

09 May 2013 Then go under Global Configuration > Server > Mail Settings > From email (has to be the exact sender email address (check uppercase&lowercase, etc)). Check Plugin Settings: Login to your Joomla Admin Panel Navigate to Extensions > Plug-in Manager > User...

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

Zoho Deluge - Generate 5 Letter Booking Retrieval Codehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-generate-5-letter-booking-retrieval-code.html

09 May 2019 v_Output= l_Output.toString(""); return 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 into 5 numbers and...

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

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

16 January 2023 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 and only unique filenames herein. Perhaps if you...

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

Zoho Deluge: Get the Week Number if Week starts on a Mondayhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-the-week-number-if-week-starts-on-a-monday.html

06 July 2023 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 overlap at the end/start of the year need to be observed. As per the...

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