Is there a node that can extract specific value with this kind of sample data
||Sample Output File
Hi @seanmanzanilla ,
If I look at the pattern from your sample data, it looks like there are 2 patterns:
00XXX and 0XX68
Are these the only 2 patterns that your whole data has? Or is this a case where we provide a solution and then you come back with other patterns?
EDIT: Here’s a quick solution:
Input (Same as yours):
Here’s the workflow: Extract value based on pattern.knwf (6.9 KB)
Alternatively you could also use regexreplace in column expressions
I guess we all love KNIME because there is always more then one way to skin the cat
Hi @bruno29a @Daniel_Weikert ,
Thank you for your great idea’s, really appreciated. And both works,
I like how regex works, Right now I’m still studying regex formula in udemy.
Hi @seanmanzanilla @Daniel_Weikert , using regex is definitely interesting and another way to do this.
I chose to use substr() instead because in this case, it’s positional enough, and should be faster than regex.
Hi @seanmanzanilla , @bruno29a
there are always more then one way to solve it. And to be frank I would always go with @bruno29a solutions here in the forum. They are well explained, get the correct result and include the workflow. The time he dedicates here in sharing knowledge and helping people is highly appreciated. Kudos
I would not necessarily use regex if not needed because not everyone understands them. (I just love them and like to contribute here from time to time as well
best regards and enjoy your weekend guys
Thanks @Daniel_Weikert , you are too kind
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.