We eventually found the answer to this. Excel will only respect the escaping of commas and speech marks if the column value is NOT preceded by a space. So generating the file without spaces like this… Reference,Title,Description 1,”My little title”,”My description, which may contain “”speech marks”” and commas.” 2,”My other little title”,”My other description, which … Read more
Tell grep to treat your input as fixed string using -F option. grep -F ‘*^%Q&$*&^@$&*!^@$*&^&^*&^&’ application.log Option -n is required to get the line number, grep -Fn ‘*^%Q&$*&^@$&*!^@$*&^&^*&^&’ application.log
For SQL Server, from http://msdn.microsoft.com/en-us/library/ms179859.aspx : % Any string of zero or more characters. WHERE title LIKE ‘%computer%’ finds all book titles with the word ‘computer’ anywhere in the book title. _ Any single character. WHERE au_fname LIKE ‘_ean’ finds all four-letter first names that end with ean (Dean, Sean, and so on). [ ] … Read more
I recently wrote a URL encoder, so this is pretty fresh in my mind. http://site/gwturl#user:45/comments All the characters in the fragment part (user:45/comments) are perfectly legal for RFC 3986 URIs. The relevant parts of the ABNF: fragment = *( pchar / “/” / “?” ) pchar = unreserved / pct-encoded / sub-delims / “:” / … Read more
Reposting my post from How do I remove diacritics (accents) from a string in .NET? This method works fine in java (purely for the purpose of removing diacritical marks aka accents). It basically converts all accented characters into their deAccented counterparts followed by their combining diacritics. Now you can use a regex to strip off … Read more
A simple example using a regular expression which you could change to allow/disallow whatever you like. $(‘input’).on(‘keypress’, function (event) { var regex = new RegExp(“^[a-zA-Z0-9]+$”); var key = String.fromCharCode(!event.charCode ? event.which : event.charCode); if (!regex.test(key)) { event.preventDefault(); return false; } });
In my experience String.fromCharCode(e.keyCode) is unreliable. String.fromCharCode expects unicode charcodes as an argument; e.keyCode returns javascript keycodes. Javascript keycodes and unicode charcodes are not the same thing! In particular, the numberpad keys return a different keycode from the ordinary number keys (since they are different keys) while the same keycode is returned for both upper … Read more
You should start with the Wikipedia Filename page. It has a decent-sized table (Comparison of filename limitations), listing the reserved characters for quite a lot of file systems. It also has a plethora of other information about each file system, including reserved file names such as CON under MS-DOS. I mention that only because I … Read more
You have to use the right character encoding to accomplish this effect. You could try with • Update Just to clarify: use `setText(“\u2022 Bullet”);` to add the bullet programmatically. `0x2022 = 8226`
You should use the string replace function, with a single regex. Assuming by special characters, you mean anything that’s not letter, here is a solution: const str = “abc’s test#s”; console.log(str.replace(/[^a-zA-Z ]/g, “”));