I found this query on GITHUB https://gist.github.com/matoakley/1092571 that converts strings into slugs, but I'm having problems when string contains EM and EN dashes, need help with this: SELECT *, LOWER(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(TRIM(name), ':', ''), ')', ''), '(', ''), ',', ''), '\', ''),…
I need functionality to "dehydrate" some user input, replacing it with placeholders, with the ultimate goal to "rehydrate" it elsewhere. For example: Visit [my page](http://example.com/posts/) Needs to have $search='http://example.com' replaced with a placeholder, like so: Visit the page [my page](%WEBSITE_URL%/posts/)…
I have nested JSON and in some string value as part of the string \n. I need to replace it with n and return the object. My brain is washed, cos I'm trying it for the whole day and can't…
I am writing a javascript function that replaces certain letters in a string. It must only replace the first instance of the letter for example software engineering is fun must become sftwr engneering is fn my function however keeps on…
I would like to replace a space after a number with hard-space " " only in p tags. I wrote this code: $pattern = "/<p>[0-9] </p>/"; return preg_replace($pattern, "$1 ", $text); But it does nothing, why? Can you please help? Example: Input…
I have thousands of string in a MySQL table in a column called query of type varchar(4096) which look always similar to the following one. The brackets are not always the same number! That means that in one query there…
I am trying to do a simple word changer. For this using a textarea, text and button. I will paste text in the textarea, for example type /red/g,'green' to textbox and click the button but something wrong and I don't…
I am trying to use str_replace() to replace consonants which are not followed by a vowel with the consonant then an e. So, lb should become leb. Conversely, a string like la should not become lea, but remain la because…
I'm trying to scrape this table of regions that support Microsoft's Speech service. I've managed to get the following character vector: region <- c("southafricanorth 6", "eastasia 5", "southeastasia 1,2,3,4,5", "australiaeast 1,2,3,4", "centralindia 1,2,3,4,5", "japaneast 2,5", "japanwest", "koreacentral 2", "canadacentral 1",…
On the page, the calendar columns are displayed with abbreviations, such as "sat" instead of "saturday". <div class="dayClass">sat, 14 may</div> <div class="dayClass">sun, 15 may</div> <div class="dayClass">mon, 16 may</div> to be like below <div class="dayClass">Saturday, 14 may</div> <div class="dayClass">Sunday, 15 may</div>…