Assuming substring is required, the following 42 results were found.
-
Column" tasks for this after 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" (YYYYMMDD)...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
= "(+01:00) Europe/Luxembourg"; v_CustomerOffset = "+01:00"; // // calculate GMT v_CustomerPlusMinus = v_CustomerOffset.subString(0,1); v_CustomerHours = v_CustomerOffset.subString(1,3).toLong(); v_CustomerMinutes =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
for CMIS Facility SELECT calendar.WeekNumber AS AcademicWeek, CAST(DATEPART(dd, calendar.StartDate) AS VARCHAR(2)) + '-' + SUBSTRING(DATENAME(mm, calendar.StartDate), 1, 3) + '-' + CAST(DATEPART(yyyy, calendar.StartDate) AS VARCHAR(4)) AS Monday,...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
HH:mm:ss"); v_ExpiryTime = "2020-03-25T21:41:07+00:00"; v_ExpiryDatePart = v_ExpiryTime.subString(0,10); v_ExpiryTimePart = v_ExpiryTime.subString(11,19); v_ExpiryTimeCheck = v_ExpiryDatePart + " " + v_ExpiryTimePart; info v_CustomTime.toTime(); info...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
assets: -- - Import banner categories from J15 and insert as assets in J30 SET @new_jos_assets_last_inc=( SELECT (SUBSTRING_INDEX(`name`, '.', -1)*1) AS lastcatid FROM `my_new_database`.my_prefix_assets WHERE `name` LIKE '%.category.%' ORDER BY...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
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`, ':|joe')-1 ) -- FROM `v34_db`.`v34_assets` a -- WHERE a.`name` LIKE '%:|joe|:%' -- Joe-Code:...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
foreach (string myValue in exceptionArray_this) { if (ValueToConvert.Contains(myValue)) { string McValue = ValueToConvert.Substring(0, ValueToConvert.IndexOf(myValue)) + myValue; McValue += ValueToConvert.Substring((ValueToConvert.IndexOf(myValue) +...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
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 into 5 numbers and get the remainder from dividing it by 26 (modulus)... This is NOT to be...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
I'd like to end up with just the last 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". How? Perhaps we...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
does not recognize CAST AS DATE) IF @OrigLen=10 AND (LEN(@OrigVal) - LEN(REPLACE(@OrigVal, '-', '')))=2 AND ISNUMERIC(SUBSTRING(@OrigVal, 1, 4))=1 AND ISNUMERIC(SUBSTRING(@OrigVal, 6, 2))=1 AND ISNUMERIC(SUBSTRING(@OrigVal, 9, 2))=1 SET...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
does not recognize CAST AS DATE) IF @OrigLen=10 AND (LEN(@OrigVal) - LEN(REPLACE(@OrigVal, '-', '')))=2 AND ISNUMERIC(SUBSTRING(@OrigVal, 1, 4))=1 AND ISNUMERIC(SUBSTRING(@OrigVal, 6, 2))=1 AND ISNUMERIC(SUBSTRING(@OrigVal, 9, 2))=1 SET...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
WHILE (@i 0 BEGIN -- get the delimited word SET @CaseLen = CHARINDEX(',', @CaseExceptions, @i+1) - @i SET @CaseValue = SUBSTRING(@CaseExceptions, @i, @CaseLen) -- replace it in the original text SET @Ret = REPLACE(@Ret, ' '+@CaseValue+' ', '...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
= LEFT(@StringInput, ISNULL(NULLIF(CHARINDEX(' ', @StringInput) - 1, -1), LEN(@StringInput))) SET @StringInput = SUBSTRING(@StringInput, ISNULL(NULLIF(CHARINDEX(' ', @StringInput), 0), LEN(@StringInput)) + 1, LEN(@StringInput)) SET @StringInput =...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
we want the rows to multiply based on the value of the column: SELECT EmployeeNo , DaysOffSick , DateOfSickness ,'1' + substring(CAST(DaysOffSick AS VARCHAR(10)), 2, 1000) AS Items FROM Employees_Attendance_Table JOIN master..spt_values n ON n.type =...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
CONCAT(r.CapexCode, ' - ', r.ResourceName) AS Resource, s.StaffActivity AS Activity, s.AdditionalNotes AS Notes, CONCAT(SUBSTRING(YEARWEEK(s.DateTimeCreated,1) FROM 5), '/', SUBSTRING(YEARWEEK(s.DateTimeCreated,1), 1, 4)) AS ActivityWeek, CASE COUNT(*)...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
ispoor, published, subscribe, source, source_id, checked_out, checked_out_time, editor ) SELECT id, parent, CASE WHEN SUBSTRING(path, LOCATE(',', path)+1, LOCATE(',', path, 2))='' THEN 0 ELSE SUBSTRING(path, LOCATE(',', path)+1, LOCATE(',', path, 2))...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
but we're missing the colon in the TimeZone value: v_TimeZone = zoho.currentdate.toString("Z"); v_TimeZoneStr = v_TimeZone.substring(0,3) + ":" + v_TimeZone.substring(3); v_InsertDateTime = zoho.currenttime.toString("yyyy-MM-dd'T'HH:mm:ss") +...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
( SELECT count(*) AS `total_count`, REPLACE(REPLACE(REPLACE(x.`value`,'?',''),'.',''),'!','') as `value` FROM ( SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(ExtractValue(t.`introtext`, '//text()'), ' ', n.n), ' ', -1) `value` FROM `mydbprefix_content` t CROSS...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
v_StartIndex = v_XeroTime.indexOf("(")+1; v_EndIndex = v_XeroTime.indexOf("+", v_StartIndex); v_UnixSeconds = v_XeroTime.subString(v_StartIndex, v_EndIndex); info v_UnixSeconds.toLong().toTime(); // yields 15-Apr-2020 17:00:00 Chained...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
v_PhotoWithExt = v_PhotoFull.getSuffix("/image/").getPrefix("\""); v_PhotoFileExtension = v_PhotoWithExt.subString(v_PhotoWithExt.lastIndexOf(".") + 1).toLowerCase(); // if(l_CompatiblePhotoExtensions.containsIgnoreCase(v_PhotoFileExtension)) {...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *