Assuming characters is required, the following 51 results were found.
-
at bet cot The expression does not match: def Non-Matching Character List Use the non-matching character list to specify characters that you do not want to match. Characters that are not in the non-matching character list are returned as a match. For...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
Databases initially setup with collation 'latin1_swedish_ci' What Another article trying to help people display foreign characters on their website without the funny question marks in diamond symbols and how I solved it in my case. Why? My company has...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
I did looking for a solution to this. Maybe it's just me but this is the scenario: Joomla works fine with international characters A Module Extension I wrote for Joomla! displayed funny characters. The Joomla! articles were displaying the correct...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
A quick article showing my MySQL statement when I want to remove all the accents from foreign characters and return the English equivalent. Why? A content management system (CMS) that I'm working on has just gone international and started including the...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
company name. The issue is that if you use zoho.crm.searchRecords() this will work fine for company names without special characters such as the ampersand or parentheses. But what if amongst your records you may want to find: Company Name: Father & Sons...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
What? This is a simple article to demonstrate how to type special characters not found on your keyboard or on a Qwerty UK/US keyboard layout. Why? Being able to type international characters from other alphabets is necessary when dealing with languages...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
or shipping address in you should get the following error: Please ensure that the shipping_address has less than 100 characters. How? If you get the above error, the community forums will advise you to get the ID of the Shipping Address... But let's say...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
however gives me the following error: { "code": 15, "message": "Please ensure that the billing_address has less than 100 characters." } How? So the quick answer is 2 separate API calls after you have sent the code to either create or update the estimate...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
A quick post on how I managed to build a regex to extract all non-numeric characters (all non-digits) from a string. Why? I only want the digits/numbers from a string: v_PaymentTerms = "Credit Note - 30 Days"; // we want the 30 from the above string...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Maximum non-zero values: 1.7976931348623157E+308 Numeric Decimal Varies Maximum width + 2 bytes String Char Range 1-255 characters Always filled max width String VarChar Range 1-255 characters Length of string + 1 byte String TinyBlob, TinyText Max...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
a Data-Scrambling Function but it depends on what you mean by "scrambling". This is a function which merely uses the same characters but switches their order randomly, so I've renamed it DataJumble as opposed to my article on Data-Scrambling. Why? We...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
XML Schema Referencehttps://joellipman.com/articles/web-development/xml/xml-schema-reference.html
the maximum number of decimal places allowed. Must be equal to or greater 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...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: en-GB
-
that is not letters (including numbers) ALNUM Forces the value to be alphanumeric (Letters and numbers only. No special characters) CMD Forces the value to be alphanumeric plus the following three special characters _ (underscore) . (dot) - (dash)...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
Regular Expressions in SQLhttps://joellipman.com/articles/database/regular-expressions-in-sql.html
WHERE 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, '[^a-zA-Z0-9\'']') -- returns all rows...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
happening to me when I had blank rows in a flat file, where it appeared to add the special carriage return or line feed characters to the next viable row, see my original data file here (sample data): And this is what a Data Viewer returned when...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
function for old MySQL. - Enhancement: Check for W3C Validation and force fix "&". - Double-check that unicode characters work in exclusion list. (they do) - Date Uploaded: Mon, 8th Aug 2011 1.6.6- Bug Fix: "Case-sensitive=No" now checks that word in...
- Type: Article
- Author: Joel Lipman
- Category: Downloads
- Language: *
-
= v_MyString.replaceAll("[^0-9]",""); // yields 123 The following is used in searches to escape special characters with a backslash: v_MyString = "Joe's \"Amazing\" Skill & Sidekick (1)"; v_FormattedString =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
code on the deal record to be listed in the "Lead Conversion Mapping" page. In the Leads module, the Zip field is 30 characters; in the deal module, the Zip field is 20 characters... but we need these to match if we want to map them in the "Lead...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
the given string and convert it to its RGB value. Replace letters A to F with their numeric equivalents. Made up of 2 characters to convert to an RGB subset, the 1st value is to be multiplied by 16 and then added to the value of the 2nd; this equals the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
which also help scramble database tables sent to suppliers/developers, this is a function which simply finds random characters and inserts these. I would recommend using the DataTumble script over this one as this leaves data very difficult to work...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB