Tuesday, September 30, 2014
   
Text Size
Login

Search

Total: 51 results found.

Search for:
Search Only:

Page 1 of 3

  1. Category: (Transact-SQL)

    ... start with a function that just converts a string of words delimited by spaces to a table: CREATE FUNCTION dbo.[ufn_StringToTable] ( @StringInput VARCHAR(MAX) ) RETURNS @OutputTable TABLE ...
    Created on 20 August 2014
  2. Category: (XSLT)

    ...  Why? Outputting from SITS:Vision to our staging environment, the application would only output blank values using single tags so we had to find a place to introduce it. On strings this has little ...
    Created on 18 August 2014
  3. Category: (SITS:Vision)

    ... select="substring-before(stu_codc,'|')"/> </COUNTRY_OF_DOMICILE_CODE> <COUNTRY_OF_DOMICILE_DECODE> <xsl:value-of select="substring-after(stu_codc,'|')"/> </COUNTRY_OF_DOMICILE_DECODE> -- ...
    Created on 12 August 2014
  4. Category: (MS-Dos)

    Applies to: Microsoft Windows 7 Professional Ms-DOS Command Prompt (6.1.7601) What? A quick article on how to rename multiple files using the command prompt and a bit of string manipulation. ...
    Created on 09 August 2014
  5. Category: (AutoHotkey)

    ... days Else StringLeft, units, units, 1 enddate -= startdate, %units% return enddate } ; ********************************************************************************************************************************************************************** ; ...
    Created on 17 July 2014
  6. Category: (MS Integration Services)

    ... the example below. Add a variable (preferably to the scope of the package) called "SourceExtractFile" and give it the data type "String". Set the Value to the full path and the first file including ...
    Created on 13 June 2014
  7. Category: (Transact-SQL)

    ... @c= substring(@Text,@i,1), @Ret = @Ret + CASE WHEN @Reset=1 THEN UPPER(@c) ELSE LOWER(@c) END, @Reset = CASE WHEN @c like '[a-zA-Z'']' THEN 0 ELSE 1 END, @i ...
    Created on 04 June 2014
  8. Category: (MS Reporting Services)

    ... referring to converting strings to dates and incorrect data types. How? The fix is to simply get the field and both results to be of the same data type: =IIF(CStr(Fields!MyCompletionTime.Value)"", ...
    Created on 15 April 2014
  9. Category: (PHP)

    What? A note for myself on some code to convert a string of two names into a string made up of the first name and then using the initial of the second name. -- What I have John Smith Fred.Bloggs -- ...
    Created on 27 March 2014
  10. Category: (Transact-SQL)

    What? This took me a while to find so I've posted an article below detailing how to parse or extract values from a string containing XML code. Why? I'm working with a system which stores XML strings ...
    Created on 27 March 2014
  11. Category: (MS-Dos)

    ... copies only those files whose source time is newer than the destination time. /EXCLUDE:file1[+file2][+file3]... Specifies a list of files containing strings. Each string  ...
    Created on 23 February 2014
  12. Category: (Joomla)

    ... ReCaptcha: 1. Open the file: /plugins/captcha/recaptcha/recaptcha.php 2. Find the following string in the OnDisplay function: return '<div id="dynamic_recaptcha_1"></div>'; 3. ...
    Created on 24 November 2013
  13. Category: (MS Reporting Services)

    ... string to the data source is held in the parameters (though, with more time, we could have tried changing the "connection string" parameter to "shared datasource" parameter where the user can select which ...
    Created on 22 November 2013
  14. Category: (MS Windows)

    ... following image: I create another column with the symbol omitted using the formula: =SUBSTITUTE(B3, "₱", "") Which leaves the value as a literal string... Now the tricky part, how to ...
    Created on 15 November 2013
  15. Category: (MS Reporting Services)

    ... DataSource In the folder where you put your Data Sources, click on the button "New Data Source" Specify the details, especially the connection string (which the system account can use). Set "Connect ...
    Created on 11 November 2013
  16. Category: (SQL)

    ... character in each of the following strings: at bet cot The expression does not match: def Non-Matching Character List Use the non-matching character list to specify characters that ...
    Created on 28 October 2013
  17. Category: (General Joomla!)

    ... encoded the string. Note it does not encode the string, it simply strips characters that may not exist in a base 64 encoded string. STRING Removes HTML HTML Allows basic HTML ARRAY Forces value ...
    Created on 17 October 2013
  18. Category: (MS Integration Services)

    ...  { // Check type for all string properties if (object.ReferenceEquals(p.PropertyType, typeof(string))) { // declare two arrays  ...
    Created on 04 October 2013
  19. Category: (Web Development)

    ... for errors. Split the first string "myFolder" with the slash (/) as a delimiter, controlling the syntax/format of your site URLs. For Example http://www.mysite.com/blog/videos/2010/january/21.html // ...
    Created on 05 September 2013
  20. Category: (Transact-SQL)

    ...  EmployeeNo , DaysOffSick , DateOfSickness ,'1' + substring(CAST(DaysOffSick AS VARCHAR(10)), 2, 1000) AS Items FROM Employees_Attendance_Table JOIN master..spt_values ...
    Created on 23 August 2013

Latest Posts