HI All So firslty, i’m new to Knime, and i am coming form teh perspective of an Alteryx power user. So i while on teh face of it, it appears Knime can do most of what Alteryx can do, certain really simple things are very difficult. Whether this is a nomenclature issue (node naming etc…) or simply missing features i am as yet unsure. I’m hoping that the good people in here can help point me in the right direction and help me get over my learning curve. I am trying to do something simple. I have a file full or urls and i need to extract a list of all the query keys found. I am using the regex split node to extract the query keys using regex tried and tested on regex101 Now in Alteryx i simply use a regex tool set to parse, enter the string below and it automatically parses each capture group into a column. (?[^=]+)(&[^=]+) In knime i get a mysterious warning message: 1589 input string(s) did not match the pattern or contained more groups than expected Can anyone decipher or point me in the right direction? thanks Gavin

Thanks @qqilihq for setting me on teh path to success. Ok So here is what i learnt. Out of the box Knime does not have the tool that can adequately carry out this processing. However there is an extension pack you can download which has loads of useful nodes, in particular a regular expression node that does exactly what you would expect and also has a built in preview function. The extension is Palladian - Highly recommed you install this. Gavin

Regex Parsing - How??

KNIME Analytics Platform

qqilihq May 15, 2020, 6:04am 4

Also check out this thread:

2 Likes