Assuming trim is required, the following 33 results were found.
-
the string ":|joes|" UPDATE `my_new_database`.my_prefix_assets b, `my_new_database`.my_prefix_categories a SET b.`title`=TRIM(SUBSTR(b.`title`, 1, LOCATE(' :|joes|', b.`title`))), b.`name`=CONCAT('com_banners.category.', a.`id`) WHERE b.`title` LIKE '%...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
+ "/" + SUBSTRING(This_Date,9,2) + "/" + SUBSTRING(This_Date,1,4)) -- Assuming [This_Date]="21032012" (DDMMYYYY) (TRIM(This_Date)=="")? (DT_DBTIMESTAMP)"1901-01-01 00:00:00" : (DT_DBTIMESTAMP)(SUBSTRING(This_Date,7,4) + "-" + SUBSTRING(This_Date,4,2) +...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
x1 (eg. if word is twice then 2000pts) // + 60 pts if in introtext // + 40 pts if in fulltext $sql_keyword = strtolower(trim($db->Quote($db->escape($text, true), false))); $query->select(' (1000*((LENGTH(TRIM(a.title)) -...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
methods of removing trailing spaces, tabs, carriage returns and line feeds (new lines). How? First in Transact-SQL: SELECT RTRIM( REPLACE( REPLACE( REPLACE( @myString, CHAR(9), ''), CHAR(10), ''), CHAR(13), '') ) -- CHAR(9) = Tab -- CHAR(10) = Line Feed...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
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. Unfortunately, the MS Excel software adds tab characters to delimit...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
NVL(student_accounts.studentID, 0) INTO v_studentreference FROM student_accounts WHERE student_accounts.studentUsername = trim(:p_myinparameter); SELECT NVL(student_details.studentFirstname, 'John') "FORENAMES", NVL(student_details.studentSurname,...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
my_date_field FROM my_table WHERE my_id='$this_id'"), 0, "my_date_field"); $this_date_array=explode("-", trim(substr($this_date, 0, strpos($this_date, " ")))); $this_time=trim(substr($this_date, strpos($this_date, " ")+1));...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
the Message Handler code ChatGTP 3.5 Turbo // // initialize m_Response = Map(); l_Messages = List(); v_Message = message.trim(); // // if the message contains a question mark, send it to OpenAI if(v_Message.contains("?")) { v_Question = v_Message; // //...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Other
- Language: *
-
{ ValueToConvert = ValueToConvert.Replace(exceptionArray_this[i], exceptionArray_that[i]); } } // trim to remove the trailing space ValueToConvert = ValueToConvert.Trim(); // Use a method to set the value of each String type property // Make sure the...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
v_returnedval := SUBSTR(v_returnedval,1,LENGTH(p_original_value)); ELSIF p_original_datatype='VARCHAR' THEN IF LENGTH(TRIM(TRANSLATE(p_original_value, 'abcdefghijklmnopqrstuvwxyz ', ' '))) IS NULL THEN -- Determined submitted value as 'ALPHALOWER';...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
; loop until there are no more double spaces while InStr( v_NewName, " ") v_NewName := StrReplace( v_NewName, " ", " ") ; trim any leading/trailing spaces and put back the extension v_NewName := Trim( v_NewName ) v_NewNameWithExt := v_NewName "."...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
the idea that the Carriage Return (CR) or Line Feeds (LF) are being inserted, simply extract the entire row as a column and trim it. I separate out the first column as my index/key field so I can check if this is a valid data row (the blank ones may...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
and underscores. Note that the PHP doesn't need a database connection here: function getUrlAlias($p_Name){ // lowercase and trim preceding/trailing spaces $v_Output = strtolower(trim($p_Name)); // replace all non alphanumeric characters (except...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
File_Ref=v_ThisFileCrmID Expiry_Date_Time=v_ExpiryTime File_Download=r_DownloadFile ]; v_NewCreatorID = if(r_HoldInCreator.trim()!="", r_HoldInCreator.toLong(), 0); if(v_NewCreatorID != 0) { // re-get this record (to get the internal file name)...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
in l_Exceptions { v_LastName = v_LastName.replaceAllIgnoreCase(v_Exception, v_Exception, false); } v_LastName = v_LastName.trim(); // // join all together v_FullName = trim(v_FirstName + " " + v_LastName); info v_FullName; // // yields: Billie-Jo...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
level checks for alphanumeric values: -- ORACLE -- 0 if is alphanumeric, 1 or more if not alpha numeric. SELECT (LENGTH(TRIM(TRANSLATE(:ParameterToCheck, 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789', ' ')))) AS NotAlphaNumeric FROM...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
is as helpful as the Microsoft paperclip, in other words, not worth the time or effort to try (didn't work anyway). The TRIM() function will not work for you either, nor with the VALUE() function.... The culprit was a suspicious space which had been...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
example below, we're going to query a message to the ChatGPT bot: // // initialize m_Response = Map(); v_Message = message.trim(); v_ChatID = ifnull(chat.getJSON("id"),0); // // get conversations from last 10 minutes v_MinutesAgo = 10; v_FromTime =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Other
- Language: *
-
= List(); for each r_PicklistOption in r_DealDetails.get("My_MultiPicklist") { v_PicklistOption = r_PicklistOption.trim().replaceAll(",", ",",true); l_MyMultiPicklist.add(v_PicklistOption); }...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
if it is then I proceed with the automations otherwise I stop it. // get given eTag v_eTag = zoho.encryption.md5(input.Title.trim()); // // now compare to stored eTag if(v_eTag != input.eTag_Title) { input.eTag_Title= v_eTag; input.Audit_Change =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *