Search
-
Category: (MS 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 -
Category: (Transact SQL)
... on. How? So where does the 'B110' string come from, well from one of our tables which looks similar to the following: Table: DMExtractEmployeeTable ------------------------------------------- ID ...Created on 14 May 2013 -
Category: (MS Integration Services)
... Split Task: Check keycolumn is not null and data column is not blank. Derived Column Task: Format keycolumn as per your requirements and use substring on trimmed DataColumn to retrieve each data column. ...Created on 23 April 2013 -
Category: (MS Windows)
... Then it wouldn't be evaluated as an expression and perhaps Excel will be forced to treat it as a string: Another alternative to round brackets, square brackets! Additional: I have ...Created on 12 April 2013 -
Category: (AutoHotkey)
... split the table into rows StringReplace,ReturnedHTMLTableRows,ReturnedHTMLTable,</tr>,|,A ReturnedHTMLTableRows=%ReturnedHTMLTableRows% StringSplit,ReturnedHTMLTableRows,ReturnedHTMLTableRows,| ...Created on 30 March 2013 -
Category: (MS Integration Services)
... conversion working in an SSIS package which read from a text file. Note that the example below converts a string in European Date Format (ie. "ddmmyyyy" to "dd/mm/yyyy"). Also, my data flow imports two ...Created on 14 March 2013 -
Category: (PHP)
What? For those of you who use Preg_Replace. Preg_replace is a function that uses regular expressions to search and replace a string. Why? Because my understanding with regular expressions is ...Created on 07 February 2013 -
Category: (MySQL)
What? This is an article on how to replace a string with another in all your joomla articles without modifying other data such as modified date and author. Why? I used to have a third-party plugin ...Created on 03 February 2013 -
Category: (SQL)
... Strings String Replace REPLACE(haystack,needle,replacement) REPLACE(haystack,needle,replacement) String Position INSTR(haystack, needle) LOCATE(needle, haystack [, offset]) PATINDEX(%needle%, haystack) ...Created on 31 January 2013 -
Category: (Transact SQL)
What? This is a quick note on finding the last occurrence of a string in a longer string. This has to be in Transact SQL for a SQL Server instance only and not filtered by other code. Why? I ...Created on 28 January 2013 -
Category: (General Joomla!)
... = $db->loadRowList(); // $db->loadAssocList(); -- $rows['0']['username'] -- foreach( $rows as $row ) { -- $this_user = $row['username']; -- $user_list_string.= "<li>$this_user</li>"; -- ...Created on 27 January 2013 -
Category: (PHP)
What? Just a quick note on how to format a given filesize and to reduce the display output to a small string, eg: 196 bytes : displays as => "196 bytes" 12945 bytes : displays ...Created on 03 January 2013 -
Category: (Transact SQL)
... DECLARE @Rand int; DECLARE @RandString varchar(max); -- for dates/times DECLARE @MinYear int; DECLARE @MaxYear int; DECLARE @RandYear int; ...Created on 07 December 2012 -
Category: (Transact SQL)
... DECLARE @ColToProcess varchar(max), @SqlToExecute varchar(max), @myXml xml; -- Parse comma delimited string into a table SELECT ...Created on 26 October 2012 -
Category: (Transact SQL)
What? This is a quick note to show you how to convert a given comma delimited string into a database table: Given: "Title,Forenames,Surname" Return: ID Value ------ ---------------- ...Created on 26 October 2012 -
Category: (Transact SQL)
... containing strings in the database and we are somewhat limited in Sql Server 2008 R2 by 4000 characters in a variable (so I couldn't store it in a local variable). So the idea here is to run the below ...Created on 11 October 2012 -
Category: (SQL)
... SQL scripts that can simply be used to search an entire database for a particular string of word(s). I've posted my own as well as some others I've lifted from elsewhere, as they worked with my environment, ...Created on 08 October 2012 -
Category: (Joomla! Tutorials)
... string * @since 1.6 */ protected $type = 'Modal_Article'; /** * Method to get the field input markup. * * @return string ...Created on 27 August 2012 -
Category: (Oracle SQL)
... NULL, -- no effect on strings p_original_range_2 IN VARCHAR2 DEFAULT NULL -- no effect on strings ) RETURN VARCHAR2 IS v_char_at NUMBER ...Created on 22 August 2012 -
Category: (Oracle SQL)
... sensitive data. How? SELECT DBMS_RANDOM.option1[(option2)] FROM DUAL; option1 can be: RANDOM VALUE STRING option2 can be: U (for Uppercase) L (for Lowercase) A (for AlphaNumeric) ...Created on 21 August 2012