Search - Joel Lipman .Com

41. Convert XML UTF-16 to JSON UTF-8 with PHP cURL: / Personal Home Page /; Previously titled Fix PHP cURL: parser error: Document labelled UTF-16 but has UTF-8 content What? This is an article with notes for me on how to convert some received XML encoded in UTF-16 to ...; Created on 28 March 2015
42. Android: Replace return key with done, go, send...: / AndroidOS /; ... return character, the app would crash because it didn't understand the data. I tried replacing the new lines but just stopping the return key or trying to catch it is an obsolete method. How? The ...; Created on 03 November 2014
43. T-SQL functions to convert Strings to Tables: / Transact-SQL /; ... DECLARE @StringValue VARCHAR(MAX) -- Trim and remove last pipe character SET @StringInput = LEFT(RTRIM(LTRIM(@StringInput)), LEN(RTRIM(LTRIM(@StringInput))) - 1) WHILE LEN(@StringInput) ...; Created on 20 August 2014
44. XML Schema Reference: / Extensible Markup Language /; ... than zero length Specifies the exact number of characters or list items allowed. Must be equal to or greater than zero maxExclusive Specifies the upper bounds for numeric values (the value ...; Created on 13 August 2014
45. SITS: Export field code and name: / Extensible Markup Language /; ... characters: Test the XET export and you should get something like: 5826|England Almost! If the code and it's short name/full name exist in the database, this works accordingly. If however, ...; Created on 12 August 2014
46. Batch Process to rename multiple files using Windows DOS: / MS-DOS /; ... This example will rename files which contain the string " (Copy)" and replace it with nothing (so removes it). The challenge here is the space character and delimiting by a string. The Gist -- ...; Created on 09 August 2014
47. Include a carriage return in a column heading: / SQL Server /; ... 21-Jul-2014 22-Jul-2014 23-Jul-2014 24-Jul-2014 25-Jul-2014 ... How? To do this in a select query resultset, you insert the special character references "CHAR(10)" [line feed] and "CHAR(13)" ...; Created on 07 July 2014
48. Convert to Proper Case in T-SQL: / Transact-SQL /; ... DECLARE @i INT; DECLARE @c VARCHAR(2); -- specify reset SELECT @Reset = 1, @i=1, @Ret = ''; IF (UPPER(@Text)=@Text Collate Latin1_General_CS_AI) BEGIN -- cycle through each character, ...; Created on 04 June 2014
49. MS-DOS: Copy folders without overwriting files: / MS-DOS /; ... /256 :: turn off very long path (> 256 characters) support. /MON:n :: MONitor source; run again when more than n changes seen. /MOT:m :: MOnitor source; run again ...; Created on 23 February 2014
50. Regular Expressions in SQL: / Databases /; ... REGEXP_LIKE(S_SURNAME, '[^a-zA-Z0-9]') -- returns all rows where the student surname contains non-alphanumeric characters -- eg. O'Brien will be returned SELECT * FROM STUDENTS WHERE REGEXP_LIKE(S_SURNAME, ...; Created on 09 January 2014
51. Contact Form: Created on 03 June 2015