Good day! I’m new to knime and would like to get some help. I want to get a certain text value from a string. See example table below. I want to extract the text between the two dash and if the string dont contained two dash then the results can just be blank.
This checks if SPACE CHECK contains a pattern with a hyphen at the beginning and then two hyphens later. If it does, it returns the portion between the second and third hyphen. If not it returns an empty string.
I’m assuming the presence of the dash at the beginning of the string, but if that isn’t always there, then this would probably need to be modified.
@takbb, Just curious, when I used your code in column manipulation node it did provide blank results unlike with the string manipulation node. Can you provide me as well the correct expression that I can use in column manipulation node. So that I don’t need to use another node since my workflow last node is the column manipulation.