1,133 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
-4
votes
0
answers
45
views
Apache Nifi: replace text with regex [closed]
I'm trying to build a NiFi pipeline with a ReplaceText processor that will be able to:
Match expressions of the type:
M\t63574
where the character at the M position can be either M or W,
and the ...
0
votes
2
answers
68
views
replacing multiple lines in nvim based on an array
If I have the following content
head = cfg["head"]
head = cfg["head"]
head ...
0
votes
3
answers
66
views
MySQL: Problem with extracting first character from text field with Regular Expressions
I'm not able to get the first character of a string with the dot operator – it returns the rest of the string, not the character:
CREATE TABLE test (
name VARCHAR(10)
);
INSERT INTO test (name) ...
2
votes
3
answers
94
views
Remove empty params from URL
URL like this
https://test.com/test?username=john&x1=1234&x2=5677
I want to remove params if any of them looks like param=.
So for example:
https://test.com/test?username=&x1=1234&x2=...
-1
votes
3
answers
178
views
How do I replace the closing bracket also?
I have a couple of sentences in parentheses in a couple of files in a folder and I need to find and remove the opening bracket and replace the closing bracket of every parenthesis with a hyphen/dash (-...
user avatar
user30745941
-2
votes
1
answer
52
views
How to replace multiple slashes with backslashes in URL string in Node.js environment?
I cache images in a directory after fetching them from different URLs. The cache files must identify the URL precisely so, in my ext4 file system where NUL and / chars are not allowed in file names, I ...
1
vote
1
answer
100
views
Move multiple captures to a string without duplicates using RegEx
I have made a RegEx procedure for my company, but have recently received a request for an enhancement to remove useless information.
I am editing programs in mass using RegEx on NotePad++
Currently, I ...
2
votes
1
answer
153
views
Runtime error 5020: Replace content in cells based on contents of a different cell (using regex patterns)
At work we use a tool called FNT command for planning and documentation of cabling, server racks, network infrastructure and so on. It can export planned connections to an excel file but its filled ...
-1
votes
1
answer
66
views
Oracle regexp_substr pattern for parallel hints in dynamic queries
Hello i have the following PL\SQL Block
DECLARE
v_clob CLOB := 'This is a sample SQL query /* APPEND PARALLEL(table) hint */ with a hint. /* PARALLEL(table) hint */';
v_new_clob CLOB;
BEGIN
...
2
votes
2
answers
139
views
Multiline Regex - change only first match
A file with two columns looks like the following:
Column A
Column B
31.03.2024 01:00
1.002
31.03.2024 03:00
2.003
31.03.2024 05:00
3.007
31.03.2024 05:00
4.985
31.03.2024 06:00
2.987
--------
--------
...
0
votes
1
answer
69
views
Find and replace function contents in all pages?
Is there a way to find and replace all occurrences of the following in all default.aspx.vb pages in our web site:
Private Function fExampleA() As Boolean
‘Existing code here
‘Existing code here
‘...
0
votes
1
answer
96
views
Convert Regular Expression To Oracle
I have a string of characters (an CSV file) that contains \r\n (or chr(13)||chr(10) in PLSQL) embedded in the data. I need to ingore these embedded Carriage Return Line Feeds so I can find the actual ...
0
votes
4
answers
107
views
Extracting the matches of a regular expression and list them with comma separated
I have a table my_table with a column source_column which is a concatenation of strings joined by " ; ". It has one or more occurrences of pattern UID-xxxx (exactly four alphanumeric ...
0
votes
0
answers
44
views
Delete repeated adjacent characters from the string in snowflake?
I have a string: 'ABC/DEF-GHI/GHI/IJK-LMN/GHI'
I want to delete the repeated occurrence of GHI followed by DEF-GHI, but not delete the last GHI because it is not adjacent to another GHI.
Expected ...
0
votes
2
answers
55
views
Create a pattern to capture with a text which does not have letters or numbers behind or infront of them
I am using REGEXP_REPLACE to replace a character set which does not have a number or character infront or behind them.
Basically my reqirement is to remove the word PT, but only when it is not used in ...