Search - Joel Lipman .Com

1. Windows OS: Alt Codes / Symbols / Special Characters: / Windows OS /; ... that are to be entered in their specific order. Search for "Alt Codes" or "Symbol Codes" in a search engine for a full list. Meanwhile, here's some that you may need frequently: Currency ¢ Cent ...; 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. Zoho Creator: Render to PDF with margins and page numbers: / Zoho /; ... could be the same under price total. Where a price is applied, values should be retained in decimal format with currency symbol prefixed if value is greater than zero. Source(s): To convert Page ...; Created on 07 May 2024
4. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... Painting Screenprint Shadow Art Smoke Form Sticky Notes Strobe Suprematism Symbolism Tin Foil Translucent Triptych Waterwork X-Ray Own prompts: Used for the fire mage above: custom1: full ...; Created on 11 February 2023
5. 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
6. 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
7. 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
8. MS-DOS: Copy folders without overwriting files: / MS-DOS /; ... :: Inter-Packet Gap (ms), to free bandwidth on slow lines. /SL :: copy symbolic links versus the target. /MT[:n] :: Do multi-threaded copies with n threads (default 8). ...; Created on 23 February 2014
9. MS Excel: Convert a text to a number: / Excel /; ... to British pounds (sterling). When I multiply the Philippine peso by the conversion rate, it returns #VALUE! How? The problem is that I have a column which includes the currency symbol as per the ...; Created on 15 November 2013
10. 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
11. 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
12. 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
13. 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
14. 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
15. 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
16. 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
17. 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
18. 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
19. 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