Search Specific String in Table View Node

[William_Alexand]

Good day

In the Table View node, I would like to know if there’s a way to strictly search for a specific string.

For example, I have a table in which a column value is either “header” or “non_header”. I’d like to display the rows which only have the “header” value but of course “non_header” also contains the string “header”.

What I’d like to know is, is it possible to, in the search bar of the node, to specify a string string which it should search? I know if you search in Google you can encapsulate a string in inverted commas to strictly search for something.

To put it into SQL, currently it’s searching for ‘%header%’ and I want to force it to search for ‘header’.

I know that I can use a rule engine node to filter out results but I’m wondering if there is perhaps this functionality built into the table view node itself. It would save my alot of time.

[ipazin]

Hello @William_Alexand,

don’t think there is some hack on this matter in Table View node but maybe I’m wrong!

Idea that comes to my mind is to use String Manipulation and and add some character before or behind. For example add exclamation point before:
regexReplace($column1$,"^header$" ,"!header" ). Then in Table View you won’t have any problems identifying these values.

Another thing you can do (if it really saves enough time) is to write your own view in Generic JavaScript View node.

Additionally I think this (wildcard and regex search options in Table View node) is a nice and natural improvement for this node.

Br,
Ivan