Search - Joel Lipman .Com

1. CSS Ordered List 1, 1.1...1.10 Formatting and Alignment: / Cascading Stylesheets /; What? A quick article to remind me on how create an multi-level ordered list that indents and aligns correctly. Why? I'm finding that I need to do this quite often for some clients who want to ...; Created on 10 July 2019
2. Formatting a date in an MDX query: / Transact-SQL /; ... is about formatting dates and times but if you want a NOW timestamp in a specific format, try... =Format(now(), "ddd, dd MMMM yyyy HH:mm:ss") =Format(now(), "dd/MM/yyyy") The reserved expression ...; Created on 11 January 2011
3. ZohoCRM: Import Attachments: / Zoho /; ... of an "Attachments.csv" file that needs the correct values in each column and the "Attachments.zip" containing the files to attach that needs some formatting as well: Note that any IDs used in the snippets ...; Created on 16 January 2023
4. Zoho Deluge: Push a value to a datetime field in CRM: / Zoho /; ... some formatting examples: Creator to CRM: v_CreatorTime = zoho.currenttime.toTime(); v_CrmTime = v_CreatorTime.toString("yyyy-MM-dd'T'HH:mm:ss") + v_CreatorTime.toString("Z").subString(0,3) + ":" ...; Created on 10 September 2021
5. Zoho CRM & Zoho Books: Custom Related Lists Deluge: / Zoho /; ... need to be adapted for your needs. Note that I have used 2 URL methods of linking to the Creator app and some data formatting that I tend to use regularly for my benefit later on when I simply copy & ...; Created on 30 July 2021
6. Windows OS: Alt Codes / Symbols / Special Characters: / Windows OS /; ... alphabets is necessary when dealing with languages other than English. Preserving files in unicode or utf-8 encoding will help but there will be times when you have lost the formatting and get weird question ...; Created on 03 June 2021
7. Zoho Deluge: Convert Map to HTML Table without a FOR loop: / Zoho /; ... = l_Data.toString(); info v_Data; // yields // , Some formatting and a lot of replaceAll: l_Keys = List(); l_Keys = v_Data.toMap().keys(); v_DataHtml = v_Data.replaceAll("},{", true); v_DataHtml ...; Created on 11 January 2021
8. Windows 10: Shortcut Apps to Settings: / Windows OS /; ... Region ms-settings:regionformatting Language ms-settings:keyboard ms-settings:regionlanguage ms-settings:regionlanguage-bpmfime ms-settings:regionlanguage-cangjieime ms-settings:regionlanguage-chsime-pinyin-domainlexicon ...; Created on 30 July 2020
9. Excel - Check a column for values found in another column: / Excel /; ... to other cells. You should end up with something like this (I have added some conditional formatting which colors the cells red or green for demonstration purposes): If you understand this ...; Created on 14 February 2019
10. Joes Word Cloud (JWC) Download: / Downloads /; ... Fixed bug: compilation failed for servers not supporting international characters. - Fixed bug: replaced string formatting foreach statements with legacy FOR statements.- Date Uploaded: Tue, 4th Jan 2011 ...; Created on 07 September 2015
11. Convert XML UTF-16 to JSON UTF-8 with PHP cURL: / Personal Home Page /; ... fetch some XML and return it in JSON formatting as long as the XML is encoded in UTF-8. // set headers for JSON file // header('Content-Type: application/json'); // seems to cause 500 Internal Server ...; Created on 28 March 2015
12. Submit form as a server and not the client with cURL: / API Miscellaneous /; What? A quick article on how to create a middleware script which accepts the values from a submitted HTML form and sends it to a server on another domain for processing. This applies to Linux Apache ...; Created on 20 February 2015
13. 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
14. T-SQL Record Separator: / Transact-SQL /; ... perform formatting to extract the minimum data here (eg. datetime into date, etc) * FROM [pretendDatabase].[pretendSchema].[pretendTable] t0 WHERE [pretendField]='elephantastic' -- ...; Created on 11 October 2011
15. SQL Calendar in Business Intelligence Development Studio: / Transact-SQL /; ... Formatting In other words, making it look pretty. I'm doing this now because you may not need parameters or events. The above should create your calendar, the steps that follow are to display ...; Created on 14 January 2011
16. Blank columns issue when exporting to Excel (Data Only) from Crystal Reports: / Excel /; ... the same alignment. Export the report to Excel and there will be no extra blank columns in the worksheet. Cause 4: Fields or objects with different font size and formatting (bold, ...; Created on 15 June 2010
17. Keyboard and mouse shortcuts in Google Chrome: / Google /; ... your cursor in a text field, then press Ctrl+Shift+V. Paste content from the clipboard without formatting. Highlight content in a text field, then press Ctrl+X or Shift+Delete. ...; Created on 23 September 2009