Search - Joel Lipman .Com

1. Windows OS: Alt Codes / Symbols / Special Characters: / Windows OS /; .joellipman-alt-code-table{ width:100%; max-width:400px; margin:0 auto; border:1px; } .joellipman-alt-code-table td:first-child{ width:40px; } .joellipman-alt-code-table td:nth-child(2){ width:300px; } What? ...; Created on 03 June 2021
2. Foreign Characters create symbols in PHP and MySQL: / Personal Home Page /; ... the funny question marks in diamond symbols and how I solved it in my case. Why? My company has started using international country and region names which include foreign characters. When we ...; Created on 25 January 2016
3. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... accurate representations of heraldic symbols, attention to detail, consistent with heraldic rules::3 deformed, unrealistic symbols, lack of detail, inconsistent with heraldic rules::-2 thumbnail: ...; Created on 11 February 2023
4. Make bootstrap carousel responsive to swipe: / Bootstrap /; ... You have to tap on the left and right symbols... How? Some will suggest to load the jQueryMobile library but that started messing up the template layouts for me. I really like the solution (and ...; Created on 14 December 2016
5. Joes Word Cloud (JWC) Download: / Downloads /; ... one (strip_punctuation and strip_symbols) - - Omit words of minimum length and don't index - Re-fixed module class suffix parameter ??? - Reworded "Display SQL Query" to "Debug Mode" - - Added word ...; Created on 07 September 2015
6. 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
7. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCase: / SQL Server Integration Services /; ... symbols) ValueToConvert = textInfo.ToTitleCase(ValueToConvert.ToLower()); // add a trailing space to catch below exceptions (eg. "Director of It ") ...; Created on 04 October 2013
8. MySQL: Find all non-alphanumeric rows: / MySQL /; What? Quick note on how to do this. I was tasked with cleaning up an english database by replacing all special alphabets (ë to e) and non-alphanumeric symbols with URL friendly characters. How? ...; Created on 09 September 2013
9. SSIS Skip Blank Rows in Flat File Source: / SQL Server Integration Services /; ... The TRIM in SSIS does not appear to get rid of new line and carriage return symbols!!! Use the Replace(String, "\r", "") and Replace(String, "\n", ""). Feedback This solution took me two days ...; Created on 23 April 2013
10. Administrator Program Shortcut without Prompt: / Windows OS /; ... Create Task... Under the General tab, for "Name" give it a general name with no symbols/special characters and preferably no spaces (I tend to give it an all lowercase name with no spaces). tick the ...; Created on 25 February 2013
11. DBMS Random Reference: / Oracle PL/SQL /; ... myAlias from dual; -- yields string of 10 printable characters (includes symbols/punctuation) Source: derived from: http://www.databasejournal.com/features/oracle/article.php/3341051/Generat ...; Created on 21 August 2012
12. SSRS AlphaNumeric Parameter Validation: / SQL Server Reporting Services /; Intro If you ever want to check the parameters submitted with a report for alpha numeric characters (so it doesn't contain symbols, punctuations, etc) then you should do this at the database level, and ...; Created on 07 November 2011
13. T-SQL Record Separator: / Transact-SQL /; ... and me replying "why would you want to do that?". Anyway, I was looking for something like the record separator in Oracle SQL*Plus where a row of data (blank or made of symbols) separates two sets ...; Created on 11 October 2011
14. Stop Excel Row Height Self-Adjust on Refresh: / Excel /; ... with CHAR(10) and although it displayed and printed properly, when saving as a PDF, CHAR(13) would return weird question mark symbols instead. Bonus All rows with this would be about 3 lines of ...; Created on 30 September 2011
15. PHP & MySQL Search Engine: / Personal Home Page /; ... $str, ENT_QUOTES, "utf-8" ); // converts html entities into characters (symbols) $str = preg_replace("/&.?;/",'', $str); // removes numeric entities? $str = preg_replace('//i', '', $str); // ...; Created on 09 March 2011
16. Change default order of weblinks: / Joomla /; ... title only without crazy symbols url - could be an issue if some of your links have http and some don't description - not recommended! date - the one I use for most recent created ...; Created on 15 November 2009