67 questions
0
votes
1
answer
69
views
How to regex replace a repeated sequence?
For example, if there a sequence of 2 or more :0000: then I like to replace them with :.
In the code below, the result should be 2a00:1450:4028:805::00001111:2005 but it just ignores the replacement.
...
- 1,235
0
votes
0
answers
30
views
Regex expression for Mariadb query
I am trying to do a replace on the following string where the last five digits are different in each row-
Stipends
I understand that I should be able to do this with Regex replace but am struggling ...
0
votes
1
answer
54
views
How Do I End My Powershell Regex Syntax Torture? [duplicate]
I want a Powershell regex replace command to convert strings such as these...
RedHerringFallacy
SunkenCostFallacy
FalseDilemmaLogic
AnyOtherCamelCapString
to...
Red_Herring_Fallacy
...
- 13
-3
votes
2
answers
89
views
Regex to replace specific word in delimited list [closed]
I'm trying to get Java regex working to replace specific phrases in a comma delimited list.
For example I have a string of "BIG BOAT , GREEN CAR,BIG BOAT, YELLOW TRUCK, BIG BOAT, AMAZON ECHO, ...
- 1,710
1
vote
1
answer
58
views
Powershell Remove part of Video filename containing Square/Round brackets and everything inside those brackets
I have several videos that has either round brackets and/or square brackets with some text inside those like (ANTYHING HERE) OR [ANTHING HERE]:
For example:
MOVIENAME 2024 LANG [SOMETEXTHERE] 1080P....
- 2,243
-1
votes
1
answer
163
views
Google Sheets: Use a Conditional Function to separate a sentence in one cell into multiple parts in subsequent cells
I want to separate a one-cell sentence into cells of 4 words each in the same row.
If the sentence has more than 12 words, the 12th word should append "..." and add no more words. SPECIAL ...
- 67
1
vote
2
answers
127
views
Regular expression with negative lookahead and negative lookbehind to check if my match IS NOT between [[ and ]]
I'm trying to write a Python script which replaces occurrences of given keywords, in given md file, by themself between [[ and ]].
It will be used several times on the same files, so I don't want to ...
- 348
0
votes
1
answer
178
views
How to extract a figure from a long line of text with different kinds of characters using REGEXREPLACE in ACL (Highbond)
I have strings in this format in a column called "Charge_Details" with minor differences: SBLC FEE
<> 1 - 360 day*!<> 400,000.00 USD<> 08/02/18 - 17/12/18 312 <>9
I'...
-1
votes
1
answer
102
views
How to replace a part of a string maintaining the other one intact in IntelliJ or VSCode? [duplicate]
I'm developing a Flutter app.
I have used a function written by me to calculate the sizes of every stuff. This was called scaleAdapter and its signature was this one:
scaleAdapter(aNumber)
This is ...
- 1,731
-2
votes
1
answer
69
views
Using regex to replace a string that is not the replace string
I would like to replace all string that do not equal this: readWriteDataGroup="Everyone" on a file I have open in Notepadd++. One of the strings that it will need to replace has this string: ...
- 3
0
votes
0
answers
32
views
RegEx Replaces Duplicate Character Sequences but Removes Dots and Commas Entirely (but Shouldn't)
I'm trying to write a regex for replacing sequential occurrence of specified characters with single ones. I used a backreference and character class for that. However, some of the characters (. and ,, ...
- 1,198
0
votes
1
answer
225
views
Replace nth regex match in C++
I've found this topic which only explains how to replace the first regex match. What about some n'th match?
Say I have a string and a regex like these:
std::string str = "fast cast dust crust ...
- 2,075
0
votes
1
answer
68
views
Regexreplace $ in address
I would like to get rid of "$" in several cells.
A cell contains f.e. "$q$3", but I would to change it into "Q3"
How to fix this with function regexreplace?
Anyone? ...
3
votes
3
answers
747
views
How to replace repeating words with single version of that word
I am trying to process transcripts that appears to use voice to text with C#. One major issue I am running into is repeating words and or phrases. I would love to use a RegEx expression to replace ...
- 139
0
votes
1
answer
56
views
regex stop continuous match when reach specific symbol
I want to remove character other than letters and number between two symbol which are < and > with empty string. The string is <F=*A*B*C*>
(?<=F=|\G(?!^))[A-Za-z1-9]*\K[^A-Za-z1-9]+
/...
- 2,004
0
votes
1
answer
81
views
Highlighting dots in a string using Python's regex and termcolor causing jupyter to crash
This is a simple code which uses regex to identify a pattern and termcolor to replace the pattern with the highlighted version of the same, basically used for highlighting a required text. The code ...
- 23
1
vote
1
answer
71
views
Need a regex that captures date & amount fields & ignore blank lines & other miscellaneous data
Goal:
Capture only the purchase date, amount, and purchased item name(s).
Ignore all blank lines
Ignore Reference # & SHIPPING AND TAX string
Then, repeat this on the next grouping of purchases.
...
- 13
0
votes
1
answer
101
views
Want file in CSV. I need a Regex to change a space to a comma on each line EXCEPT the Description Field which should remain with a space
Goal:
I want a CSV file as my result. I want to change the space char to a comma on each line of data. BUT, I also need the data for the 3rd field (Description) to remain as is with original space ...
- 13
1
vote
2
answers
72
views
regular expression to remove all other words except the words between special characters in notepad++
I am trying to create a regex in Notepad++ to remove words except those enclosed between special characters. I am using this regex \<.*?\> which removes the words along with text.
Eg:
Sample ...
0
votes
3
answers
985
views
Extract text from a cell without extracting punctuation in Google Sheets
In Column F, I have a list of states and their abbreviations.
enter image description here
I want to use a regex function to extract the state and the state code so the output looks like the contents ...
0
votes
1
answer
362
views
How can I comment all the uncommented lines in a file using puppet module?
I have a sshd_config configuration file which contains commented as well as uncommented lines. I want to comment all the uncommented lines in that file using puppet. Is there any optimal/simple way to ...
- 313
3
votes
3
answers
97
views
Regexreplace all lowercase words not working with german umlauts
Trying this to replace all lowercase words is not working properly
=regexreplace(A1;"\b[a-züöäß]+\b";"")
Example sentence:
Mit Sätzen wie Gewinne laufen lassen Verluste begrenzen ...
- 644
0
votes
1
answer
257
views
How to use regexp_replace with contains?
I use this function to find if the pattern is in the column and replace it with the replacement but it does not give.
Can someone tell where I make the mistakes?
patterns = [
'15/19',
'14/11',
...
- 159
0
votes
1
answer
965
views
How would I import YouTube video views into google sheets?
I have a list of videos for which I want to easily see the number of views. Is there a way to do that with REGEXREPLACE, or some other way?
-1
votes
1
answer
429
views
How use REGEXREPLACE in google sheets?
I import data via IMPORTXML and get it in the form as shown in column A:B
How can I use REGEXPREPLACE to bring them into the form as I showed in columns D:F ?
With the price I tried
ARRAYFORMULA(--...
