Tag: regexp-replace

Regex working in php 7.4 but not with mariadb 10.3.38 (though both use pcre)

Advertisements I’m currently migrating a very old typo3 cms to wordpress 6.1. In order to get links stored in the db working I have to transform them from a proprietary non-xml format to html using a regular expression: <link fileadmin/user_upload/file47.pdf – download>Linktext</link> has to transformed with this regex <link\s(fileadmin\S*?)[>\s].+?>(.+?)<\/link> to this link: <a href="fileadmin/user_upload/file47.pdf">Linktext</a> I’ve… Read More Regex working in php 7.4 but not with mariadb 10.3.38 (though both use pcre)

MRLeave a comment

REGEXP to use for String formatting to group characters and numbers separated with spaces

Advertisements Hello I am trying to format a given string so that it groups numbers and characters and puts spaces ‘ ‘ in between. For example the given string: 01ABC23fg98 should give the output: 01 ABC 23 fg 98 Any suggestions? I tried REGEXP_REPLACE(input_String , ‘ ‘, ”) which does the opposite (it removes spaces… Read More REGEXP to use for String formatting to group characters and numbers separated with spaces

MRLeave a comment

Google App Scripts – Regex – Remove all letters, replace all spaces, or new lines with comma not working

Advertisements INTRO I have a Google App Script Web App which has a form which contains a TextArea, and when submitted saves the data in a Google Sheet. This text-area collects Employee ID’s and will receive input from non-tech savvy users. The users may use the following formats when entering the ID’s into the textarea,… Read More Google App Scripts – Regex – Remove all letters, replace all spaces, or new lines with comma not working

MRLeave a comment

I want to replace the words in description with dataframe from my column and add it to my dataframe

Advertisements I want to replace the name and age in description with the data in my table. data = {‘name’ : [‘Max’,’Jim’],’Age’:[32,44],’desc’:”} desc = "My name is <name> and my age is <age>." Like this, Output: name Age desc 0 Max 32 My name is Max and my age is 32. 1 Jim 44 My… Read More I want to replace the words in description with dataframe from my column and add it to my dataframe

MRLeave a comment

Delete or replace all character inside # in python

Advertisements I want to remove all character inside of # in text. This is the regex I used. text = text.replace(‘\xa0’, ‘ ‘) text = re.sub(r"#\ [A-Za-z]*\# ", " ", text) text = re.sub(r"#[A-Za-z]*\# ", " ", text) example of data like: ‘Please direct all communications to the HR Department within Refined Resources (#URL_80d75e0d07ca8b108539318a0443bfe5d1ff472afa0c4540b77079c5d5f31eee#)\xa0#EMAIL_0b13a2cfd4718ce252c09b2353d692a73bd32552e922c5db6cad5fb7e9a2c6c3#Darren Lawson… Read More Delete or replace all character inside # in python

MRLeave a comment

Replace ")" by ") " if the parenthesis is followed by a letter or a number using regex

Advertisements import re input_text = "((PL_ADVB)dentro ). ((PL_ADVB)ñu)((PL_ADVB) 9u)" input_text = re.sub(r"\s*\)", ")", input_text) print(repr(input_text)) How do I make if the closing parenthesis ) is in front of a letter (uppercase or lowercase) it converts the ) to ), so that the following output can be obtained using this code… "((PL_ADVB) dentro). ((PL_ADVB) ñu)((PL_ADVB) 9u)"… Read More Replace ")" by ") " if the parenthesis is followed by a letter or a number using regex

MRLeave a comment

Regular expression to remove a portion of text from each entry in commas separated list

Advertisements I have a string of comma separated values, that I want to trim down for display purpose. The string is a comma separated list of values of varying lengths and number of list entries. Each entry in the list is formatted as a five character pattern in the format "##-NX" followed by some text.… Read More Regular expression to remove a portion of text from each entry in commas separated list

MRLeave a comment