... 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 documen ...
What?
A super quick article to show how to link to the thumbnail image of a Google Drive file, in this case a video file.
How?
The hardest part of this is to get the Google Drive File ID (which ...
...
"id": "1srXLU-lotsofalphanumericcharacters_",
"name": "my_video.mp4",
"mimeType": "video/mp4"
}
Additional:
Why not? Let's add a description and some security where we disable download, sharin ...
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 ...
What?
A quick article on how to trim in MySQL along with getting rid of any leading or trailing tab characters.
Why?
I use MS Excel for organizing data and then converting to MySQL commands. ...
... 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 different case is not ...
Previously titled
Fix PHP cURL: parser error: Document labelled UTF-16 but has UTF-8 content
What?
This is an article with notes for me on how to convert some received XML encoded in UTF-16 to ...
... 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 (the value ...
... 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 in the database, this works accordingly. If however, ...
What?
So this is an article exploring how to convert UPPERCASE text into mixed case. The feed is originally for a personnel feed so it won't be converting long paragraphs of English text. Instead it ...
... /256 :: turn off very long path (> 256 characters) support.
/MON:n :: MONitor source; run again when more than n changes seen.
/MOT:m :: MOnitor source; run again ...
... 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, ...
... 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 you do not ...
... is to remove any non-alphanumeric characters...
In your component, create a PHP file in /administrator/models/fields/ (eg. "userprojects.php"). Rename "userprojects" with the name of your field ty ...
... and numbers only. No special characters)
CMD Forces the value to be alphanumeric plus the following three special characters _ (underscore) . (dot) - (dash)
BASE64 Forces the value to be a base64 ...
What?
Quick note on how to do this.
I was tasked with cleaning up an english database by replacing all special alphabets (ë to e) and non-alphanumeric symbols with URL friendly characters.
How? ...
...
Almost!
A problem not covered by many sites was 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 ...
... understanding the last two characters on the row (CR & LF).
Fixes of interest:
-- assuming This_Decimal="00000.00" or "123456.78" (Do NOT use "Replace" and instead "Add as new column")
(DT_DECIMAL,2)TRIM(This_Decimal)
-- ...
... 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 ...
... 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 "25"
SELECT SUBSTRING(@Haystack, LEN(@Haystack) ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.