regex and custom query

Options
mohan ramanujam
mohan ramanujam Member ✭
in ? Transforming data
I am using custom query and regex match. If my query is " john doe" and I want that to match "john1 doe", how can I do that? 
· Share on Twitter

Comments

  • Christian Bird
    Christian Bird Member ✭
    Options
    Hi Mohan,

    After looking through the documentation I think this may help you get on the right track; have your regex value set to '/(\w+)\d\s(\w+)/'. This checks for word characters followed by a number, then a whitespace, then more word characters. Test it out and let me know if it helps!
    · Share on Twitter
  • mohan ramanujam
    mohan ramanujam Member ✭
    Options
    will do. I tried lambda filters and it allows running reg exp in a split. So I will use the same mechanism to check this out. Thx
    · Share on Twitter

Categories