... as `total`, `value`
FROM (
SELECT count(*) AS `total_count`, REPLACE(REPLACE(REPLACE(x.`value`,'?',''),'.',''),'!','') as `value`
FROM (
SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(ExtractValue(t.`introtext`, ...
... v_Output;
}
This is my preferred method and it will return a string of 5 random uppercase letters.
Method #2: Convert time to letters
I've previously used substring to extract the milliseconds ...
What?
This code snippet took me a while to do and the documentation is flaky so I thought I'd make a note here just in case I need to refer to it again.
Why?
I want to modify a picklist and fill ...
...
AND t1.`extension`='com_content'
AND t2.`extension`='com_content'
SET
c1.`catid`=t1.`id`;
-- Joe-Code: LIST Rows to be affected (for test purposes)
-- SELECT SUBSTRING(a.`name`, 1, INSTR(a.`name`, ...
What?
An article on how to declare an XML element as NULL using the attribute "xsi:nil". I'm going to use a very short example by providing a blank date of birth value:
-- What I have:
//
-- ...
Applies to:
Microsoft Windows 7 Enterprise
SITS:Vision Students (v8.7.0)
What?
You might be able to work it out from the online manuals but it took me a while, we wanted to bring back both the ...
... is not null and data column is not blank.
Derived Column Task: Format keycolumn as per your requirements and use substring on trimmed DataColumn to retrieve each data column.
Additional ...
... giving up with a "Data Conversion" task. I then parse the date, month and year out using SUBSTRING:
-- Assuming [This_Date]="21/03/2012"
(DT_DATE)(This_Date)
-- Assuming [This_Date]="20120321" ...
... part of this, ie "String4". So I need to delimit based on the dot/period (.) and use substring in a sort of reversed form.
For argument's sake, I'm assigning this string to the variable "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.