Knime string replacer, replace everything until some special string
I have a smiliar question to this. I am also using the string manipulation node.
Right now I have the following strings (in a column):
Order[NN(STTS)]
523:10[CARD(STTS)]
Euro12[NN(STTS)]
I want to have the output:
[NN(STTS)]
[CARD(STTS)]
[NN(STTS)]
How can I use stringManipulation to do so, right now I am using:
regexReplace($List(Term)$, "/(.*?)\[" , "[")
The output I get currently is:
?
?
?
If i am checking it online with the java regex: https://regex101.com/r/z6eOHv/1
The output looks fine:
What is my mistake?
A "quick fix" is regexReplace($List(Term)$, "(.*?)\\[" , "["): the / looks to be a remnant of the regex literal notation used in the online regex testing services, you do not need one here as Java regexps are defined with mere string literals, and the last [ should be double escaped in a string literal.
However, you may just use
regexReplace($List(Term)$, "^[^\\[]+" , "")
The regex string is ^[^\[]+, see the regex demo. It matches
^- start of string[^\[]+- 1 or more (+quantifier matches 1 or more occurrences) characters other than[(the[^...]is a negated character class matching all chars other than specified in the class).
Since the string literals support string escape sequences (like a tab, \t, or newline, \n) backslashes must be doubled to introduces single literal backslashes.
- extract string emojis from text
- gawk hangs when using a regex for RS combined with reading a continuous stream from stdin
- notepad++ regex mode: insert new line to some hex code
- Replace all image urls with <img> tags
- Regex Greedy from right to left
- Get all integers which follow certain symbols in a string with multiple delimiters
- How do I check if a filename matches some wildcard pattern?
- Replace named captured groups with arbitrary values in Python
- .htaccess redirect from site root to public folder, hiding "public" in URL?
- Program to generate regex easily?
- What's the regular expression that matches a square bracket?
- Add a new class to img tag's class list
- Wrap <img> tag in a new tag and add alt attribute to the <img>
- Remove non-<img> tags from string
- Remove excess newlines/whitespace from multi-line <img> tag in HTML string
- Get whole img tag including its attribute declarations from a string
- regex for match all <img> tag and extract the "src" attribute
- Trying to match src part of HTML <img> tag Regular Expression
- Find and kill a process in one line using bash and regex
- RegEx problem or maybe another solution altogether?
- Regex split where \# splits and \\# does not
- textfield text (one or more than one) regex check Swift UIKit
- Get the src value from all img tags
- How to extract img src, title and alt from html using php?
- Regular Expression to validate a CAGE Code
- Get telephone number from a string containing labelled contact details
- String matches method - forward slash not working
- How to make a REGEX pattern in mysql for 3 or more digits that are in sequence?
- Regex pattern with optional segments failing to match slash-delimited string
- Validate that a string is wholly alphanumeric and has a qualifying length