Visokio website     Downloads     Video tutorials     KnowledgeBase  
SearchRegex Formula not working - Visokio Forums
SearchRegex Formula not working
  • JohnMR September 18, 2017 6:30AM
    Hi Omniscopers,

    I'm trying to use Searchregex formula to pull

    =searchregex("^.{3}[A-Za-z0-9 ]+\K.",[Campaing],1)

    Searchregex usually works but not when I add the "\" in \K I get an error: Error with formula: Invalid text """ - an open bracket, literal number, reference or function was expected.

    When I remove the slash the formula works but I need that slash in it. Why is this not working?
    Thanks,
    John.
  • 3 Comments
  • JohnMR September 18, 2017 6:46AM
    Just as a follow up. I now know I need to do \\K but it still doesn't recognise \K as a command.
    Thanks,
    John.
  • JohnMR September 18, 2017 10:03AM
    Hi, Still isn't supporting \K. Is there a reason for this?
    Thanks,
    John.
  •     paola September 18, 2017 12:29PM
    Hi John,
    Could you please confirm what exactly you're trying to achieve, as there might be other ways do do it.

Welcome!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership