Questions tagged [regex-replace]
53 questions
-1
votes
1 answer
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(--REGEX REPLACE(IMPORT XML(I…
-1
votes
2 answers
Cut out substrings of a URL in Google Spreadsheets with different characters?
I want to cut out substrings from this url XY.com/de/haus/dach-ziegel-stein/ and put the values each in its own columns in Google Spreadsheet.
I want to cut out by / and by -.
With this url example:
Column A should be de
Column B should be…
johny
- 159
- 1
- 13
-2
votes
1 answer
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: readWriteDataGroup="E_MOD_WSP_64"
So I have been doing…
Rehaan
- 5
-2
votes
1 answer
Regular expression for finding the first character of every line
I need to find the first character of all the lines and remove it using Java.
Input lines:
Z301052023KDE12 0000.062500000 0000.000000000 0000.000000000
Z301052023KDE11 0000.000000000 0000.000000000 0000.000000000
Java code:
public static…
Nijith
- 69
- 6
-2
votes
1 answer
Complex REGEXREPLACE with dots and special symbols in Google Sheets
I'm trying to extract values from the text (column A) into three columns with array formula in each column:
Name (column C)
Text with numbers, dots and special symbols (like ',&,’) written together.
First standalone number (column D)
It can have…
Max Ambinder
- 15
- 1
- 5
-2
votes
3 answers
REGEX: Transpose each word from a google sheet cell and put them one under the other (rows)
I need to extract each word (phrase) within a cell in google sheets and put each one under the other in a column (row for each one).
I have a regex code that works when testing it, but I cannot do it work in google sheet the same code. Any ideas?
Martin Hogg
- 41
- 2
-2
votes
1 answer
map a string to an object using regex
for some translations need, I need to replace a string having three brackets like
hello {{{'something'}}} world {{{'something else'}}} ...
with a string containing two brackets and the values
{
value: "hello {{1}} world {{2}}...",
params: {1:…
serge
- 13,940
- 35
- 121
- 205
-3
votes
2 answers
replace Java-regex-quantifiers
I have a string like "18+, a + b". Can I replace all symbol "+" by "\+" in Java 11.
I try replaceAll("+", "\+") but failed by Dangling meta character '+'
Exception in
thread "main" java.util.regex.PatternSyntaxException: Dangling meta character '+'…
NguyenLT21
- 3
- 2