Visokio website     Downloads     Video tutorials     KnowledgeBase  
Help writing a fomula - Visokio Forums
Help writing a fomula
  • samconvergex November 22, 2010 3:21PM
    I am having trouble writing a formula that would be akin to a conditional statment in excel or a like statement in SQL.. Can anyone help?

    I'd like to do one of the following--

    Formula 1: IF([field A] like 'xyz', 250, 0)
  • 4 Comments
  •     tjbate December 1, 2010 11:37AM
    Sam - This is done using Regular Expressions, and the SEARCHREGEX( ) function. We have sent you various versions of RegEx that do this with increasing degrees of sophistication.
  • Guy_Cuthbert        Guy_Cuthbert December 13, 2010 5:36PM
    Tom - it would be useful to see those options... I think RegEx is one area where non-programmers can feel a little daunted, but it's such a powerful capability.

    A couple of resources that I find very handy when developing/testing RegEx, for non-programmers like me:

    1. http://www.regular-expressions.info/ - provides a great overview and tutorials on Regular Expressions
    2. http://gskinner.com/RegExr/ - on online RegEx editor/test environment... cut and past Omniscope data into the large mult-line window and then enter RegEx above and test as you go!
    Atheon Analytics Ltd
    w: www.atheonanalytics.com
    e: guy.cuthbert@atheon.co.uk
    t: +44 8444 145501
    m: +44 7973 550528
    s: guycuthbert
  •     steve December 13, 2010 5:58PM
    ... regex is good, but not as good as Javascript...
  •     steve December 13, 2010 5:58PM
    see the new SCRIPT tag.
Add a Comment

Welcome!

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

Sign In Apply for Membership

Categories