Assuming characters is required, the following 52 results were found.
-
for this step. Click on Create Task... Under the General tab, for "Name" give it a general name with no symbols/special characters and preferably no spaces (I tend to give it an all lowercase name with no spaces). tick the checkbox Run with highest...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
that searched every column 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 example which outputs a...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
LEN(@Haystack)) -- yields "3.String4" Almost there, counting backwards and forwards it seems the index is just two characters off (as I don't want to include the period): SELECT LEN(@Haystack) - CHARINDEX(@Delimiter, REVERSE(@Haystack)) + 2 -- yields...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
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 will also make their system escape apostrophes (') and...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
`value` ORDER BY `total` DESC LIMIT 0,50; Additional Note(s): I have added a WHERE clause which omits words less than 5 characters in length, and some other words not to count. I have added the ORDER BY to give me the highest count first in descending...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
// remove BB Code and HTML tags $str = html_entity_decode( $str, ENT_QUOTES, "utf-8" ); // converts html entities into characters (symbols) $str = preg_replace("/&.{0,}?;/",'', $str); // removes numeric entities? $str = preg_replace('//i', '', $str); //...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
What? A quick article to stop me running into this issue again. This article serves to address the issue of importing characters from an XML in a different language character set and trying to load it in PHP with the function simplexml_load_string()....
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
// lowercase and trim preceding/trailing spaces $v_Output = strtolower(trim($p_Name)); // replace all non alphanumeric characters (except underscore) to an underscore $v_Output = preg_replace("/[^a-z0-9\_]/", "_",$v_Output); // replace any consecutive...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
code and then the inner SRL text which should be |, if you try to apply you should be prompted to convert to use gold 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...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *
-
to compare into a single field can't be done via the documented methods (base64, urlencode or AES) as this exceeds 255 characters (it could be a multiline but this would defeat the objective of an Etag). How? Well I was going to document writing a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
your Google Translation services working with your website. Why? At time of print, Google now charge for every 2,000,000 characters (2 million) every month. Microsoft's Bing has added itself to the fray pretending to offer free services but in the small...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
if you've made a mistake four or five commands back. It is marginally useful if you've made a mistake twenty or thirty characters back. And it is completely useless if your mistake is ancient history." - Learning GNU Emacs (page 42) Undoing can itself...
- Type: Article
- Author: Joel Lipman
- Category: IT Support
- Language: *