Newbie here. I have two simple fields each contains a string. I need to know via the filter if string in 8.title can be found in sting Q. My problems that the string relates to clothes sizes so if I have string “XS” in 8 it finds matches in Q which might be XS but if the string in 8 is S, it still finds a match in Q. How do i get whole phrase only match? Is this a regex type thing. Can that be done in filters.
Also as an aside how do I get around quote marks being part of the string. I have sizes such as 40" and teh fitler seems to turn this into “40"” which then fails.
Yea you need to use regex. Use the text operator Matches pattern and use regex to filter it
Welcome to the Make community!
You can use a word boundary delimiter \b with a “Text Operator: Matches Pattern” operator.
(also you want to find Q (size) in Title, not Title in Q (size))
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Did you know, the concepts of about 70% of questions asked on this forum are already covered in the Make Academy. Investing some effort into it will save you lots of time and frustration using Make later!
2 Likes
many thanks, that worked. Could not get my head around the regex part at all.