Hello all. I use String manipulation node with such expression: regexReplace($Description$, “.?(\d+(.\d+)?)\s(uF|nF|pF).*”, “$1”), but it doesn’t replace anything and simply return the same string.
Example of initial string: COQ X7S 10.0 uF 50V 10% 1210 ST FLEX. I need to extract the value before uF, in this case it is 10.0
Hi @mak_782,
here is a possible solution to your problem using the regex extractor.
Have a nice day,
Raffaello Barri
1 Like
Thank you. But Knime couldn’t find extension for using Regex Extractor
Hello @mak_782
If extracting the substring “10.0” from the test string, “regex split node” can be used.
regex.knwf (7.0 KB)
2 Likes
1 Like
Hello @mak_782,
Please correct your expression:
It worked with a small change in your expression.
I’ve also attached images for your reference.
Input:
Configuration:
Output:
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.