Assuming replace is required, the following 100 results were found.
-
typed/sounding words. How? Here's just a splurge of SQL but I use this often enough: UPDATE `myTable` t SET t.`myColumn`=REPLACE(t.`myColumn`, 'À', 'A'); UPDATE `myTable` t SET t.`myColumn`=REPLACE(t.`myColumn`, 'Á', 'A'); UPDATE `myTable` t SET...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
to split up search terms and accepting double-quotes as phrase makers. function search_transform_term($term){ $term = preg_replace("/(\s)/e", "'{WHITESPACE-'.ord('\$1').'}'", $term); $term = preg_replace("/,/", "{COMMA}", $term); return $term; }...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
For those of you who use Preg_Replace. Preg_replace is a function that uses regular expressions to search and replace a string. Why? Because my understanding with regular expressions is shady and varies from language to language, I've written this...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
-- TABLE OF CONTENTS -- I. Help on using the queries below -- -- 1. replace all database names in the scripts below -- -- 2. checking before you commit changes -- II. Copy content from the old database to the new database and tweak: -- -- 1. setting...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
WHERE WEEKDAY(s.DateTimeCreated)=0 AND YEARWEEK(s.DateTimeCreated)=YEARWEEK(NOW()) - $w_value AND s.StaffUserID='STRING_TO_REPLACE_PER_ITERATION' ) AS 'Monday', ( SELECT SEC_TO_TIME(SUM(TIME_TO_SEC(s.EstimateTimeFinish)-TIME_TO_SEC(s.DateTimeCreated)))...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
T-SQL Record Separatorhttps://joellipman.com/articles/database/t-sql/t-sql-record-separator.html
I now need to add an actual row separating the different days which is either blank or full of hyphens/dashes. Stage #2: Replace values in last data row with blanks The trick to this is to get Stage #1 working for you with your query and then for every...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
This is an article on how to replace a string with another in all your joomla articles without modifying other data such as modified date and author. Why? I used to have a third-party plugin that would replace my HTML tags with . Not I want to switch...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
Trim in T-SQL and SSIShttps://joellipman.com/articles/microsoft/ssis/trim-in-t-sql-and-ssis.html
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
-
in the database. If you only have the -- ones from an Out-of-the-box Joomla! CMS then this is what I use: -- -- Copy and replace the below script per category -- -- this example is for one "uncategorized content" category --...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
Deluge to parse the data in the appropriate columns was not working as expected. How? The quick answer is a regex that will replace any commas between two quotes with a custom string, to be exact: v_FormattedData =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
A quick article on how to replace the return key on a soft keyboard (software based) on a touch-device. Why? I have an editText where a user can enter any text value but if they typed a return character, the app would crash because it didn't understand...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
me. Found it a bit boring but here's a short bit of code to speed it up which I now use: update table_name set field_name=REPLACE(field_name,'string_to_find','string_to_replace'); Source:...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
= strtolower(trim($db->Quote($db->escape($text, true), false))); $query->select(' (1000*((LENGTH(TRIM(a.title)) - LENGTH(REPLACE(LOWER(TRIM(a.title)), '.$sql_keyword.',\'\'))) / LENGTH('.$sql_keyword.'))) + (60*((LENGTH(TRIM(a.introtext)) -...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
foreach (string myValue in exceptionArray_this) { if (ValueToConvert.Contains(myValue)) { ValueToConvert = ValueToConvert.Replace(myValue, myValue.ToLower()); } } // tranformation exceptions: words to be UPPERCASED // note the first letter case and...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
= " #copyright a{ margin: 10px 0 0 85px; box-shadow: 5px 5px 5px 0px rgba(51, 51, 51, 0.3); }"; $v_AppStyleFormatted = preg_replace('/\s+/', ' ', $v_AppStyle); and a few str_replace arrays: // exceptions $a_ReplaceFrom1 = array("px ", "0 ", " a");...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
What? An article on how to quickly adapt an array code and sort by its values. Surprising how many examples are on the web and everyone saying you're doing it wrong... Which is true but quite unhelpful. The original code is not my own either but that's...
- Type: Article
- Author: Joel Lipman
- Category: JavaScript
- Language: *
-
feed would be done on the respective social network's site. How: This simply displays the feed... (no write back) Facebook Replace https://www.facebook.com/myfacebookpage with your facebook URL and replace My Facebook Page with the title of your...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
in Zoho. How? The following will remove any non-digits: v_MyString = "Hello World 123"; v_MyFormattedString = v_MyString.replaceAll("[^0-9]",""); // yields 123 The following is used in searches to escape special characters with a backslash: v_MyString =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
m_Params.put("WarningLevel","High"); m_Params.put("ErrorLanguage","en_GB"); // // convert to xml and replace root nodes x_Params = m_Params.toXML(); x_Params = x_Params.toString().replaceFirst("",""); x_Params = x_Params.toString().replaceFirst("","");...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Count by Split+Count took : 0.44112181663513 Seconds Count by Preg_Match+Count took : 0.46423101425171 Seconds Count by str_replace took : 0.23512482643127 Seconds Count By str_ireplace took : 0.39766597747803 Seconds Count By Explode+Count took :...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *