I’m strugging with a regex pattern, which works normally. However, If I enter it in the Regex Split-Node in order to split a column into multiple new columns based on a regex, it just won’t accept it and print an warning like “1 input string(s) did not match the pattern or contained more groups than expected”.
My string is for example “A BCDEFGH IJKLM” and I want to add a pipe “|” after "A " and “BC”, based on the pattern “\w{1,2}”. My initial idea was to splitt the column, add the pipe and then join the strings together again.
Does anyone have an idea or a tip, how to solve this obstacle? Thank you in advance.
It would help if you explain logic behind adding pipe into your string. Are you adding pipe after “A” and “BC” or adding pipe after first and third char or something else?
if I got you right you want to count every occurrence of string "A " and “BC” in your string? Then you can avoid adding pipe and use count() function in String Manipulation node maybe?
