Search - Joel Lipman .Com

1. Include a carriage return in a column heading: / SQL Server /; Applies To: MS SQL Server 2008 R2 MS Windows 7 Enterprise (Client) MS Excel 2010 What? A really quick note on how to insert a carriage return or new line into the column name/alias (the header). ...; Created on 07 July 2014
2. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines): / Zoho /; What? This is an article to demonstrate how to handle commas in a CSV file that were enclosed between two double-quotes. I've added to this the handling of new lines or carriage returns in between a ...; Created on 26 August 2021
3. Zoho Deluge - Some Useful Regular Expressions: / Zoho /; ... = v_MyString.replaceAll("\r","",false); // carriage returns v_FormattedString = v_MyString.replaceAll("\n","",false); // line feeds v_FormattedString = v_MyString.replaceAll("\f","",false); // form ...; Created on 31 May 2019
4. Accessing Apimo WebService API: / API Miscellaneous /; ... XML declaration from results $output = substr($output, stripos($output, '?>') + 2 ); // remove leading spaces, carriage returns $output = trim($output); // process if type specified was xml if($apimo_type=='xml'){ ...; Created on 29 March 2016
5. XML Schema Reference: / Extensible Markup Language /; XSD Elements Element Explanation all Specifies that the child elements can appear in any order. Each child element can occur 0 or 1 time annotation Specifies the top-level element for ...; Created on 13 August 2014
6. Trim in T-SQL and SSIS: / SQL Server Integration Services /; What? Some methods of removing trailing spaces, tabs, carriage returns and line feeds (new lines). How? First in Transact-SQL: SELECT RTRIM( REPLACE( REPLACE( REPLACE( @myString, CHAR(9), ...; Created on 14 May 2013
7. SSIS Skip Blank Rows in Flat File Source: / SQL Server Integration Services /; ... Almost! A problem not covered by many sites was happening to me when I had blank rows in a flat file, where it appeared to add the special carriage return or line feed characters to the next viable ...; Created on 23 April 2013
8. Error 1065: Query was Empty: / MySQL /; ... Why? Bespoke systems are the usual suspects. Developers will have told the system what to do when newline, carriage returns and tab characters are entered in the data. Those who are security-conscious ...; Created on 13 December 2012
9. PHP & MySQL Search Engine: / Personal Home Page /; ... removes MS Office style html comments (and everything in between) $str = str_replace(array("\r\n", "\r", "\n", "\t"), ' ', $str); // remove carriage returns, line feeds, tabs and double-spaces # ...; Created on 09 March 2011