Velocity "Contains" operator case sensitive? | Community
Skip to main content
Chris_Wilcox
Chris_Wilcox
New Participant
April 29, 2019
Solved

Velocity "Contains" operator case sensitive?

  • April 29, 2019
  • 2 replies
  • 11916 views

Is there a way to write a "contains" command in velocity that is NOT case sensitive? For example:

#if !$lead.Variable.contains("Value")
    Output
#else
Default
#end

In that logic, the contains "Value" is case sensitive. Any way to write the command to bypass case sensitivity? I've tried a few variations with no luck.

Thanks,

Chris

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Chris_Wilcox

Hey Sanford,

I was chatting with someone else about this and they offered the solution of using the matches function and some regex instead of "contains." Specifically, using:

$lead.Variable__c.matches(".*(?i:value).*")

In all my testing, appears to work exactly as expected. Any thoughts on this? I've never used regex in velocity and wasn't sure if there's a reason this approach isn't a good option.


Appreciate your input!
Chris

2 replies

SanfordWhiteman
SanfordWhiteman
New Participant
April 29, 2019

Mark's recommendation of toLowerCase()-ing both sides is, unfortunately, the best we've got within Marketo's Velocity deployment.

toLowerCase() is not 100% accurate across the Unicode range (in Greek, for example) and perhaps more important, is wildly inefficient for long strings (for reasons that should be obvious when you think about it ). A compiled regular expression is better on the efficiency side (though not the accuracy side) but compiling is complex in Velocity so best to skip that.

There used to be another way to do this that's both accurate and fast... but with some upcoming changes, that way will no longer work in Marketo.

What exactly are you trying to do where you need to match string-in-string? There may be a better way.

    Chris_Wilcox
    Chris_WilcoxAuthorAccepted solution
    New Participant
    May 1, 2019

    Hey Sanford,

    I was chatting with someone else about this and they offered the solution of using the matches function and some regex instead of "contains." Specifically, using:

    $lead.Variable__c.matches(".*(?i:value).*")

    In all my testing, appears to work exactly as expected. Any thoughts on this? I've never used regex in velocity and wasn't sure if there's a reason this approach isn't a good option.


    Appreciate your input!
    Chris

    SanfordWhiteman
    SanfordWhiteman
    New Participant
    May 1, 2019

    An uncompiled regex is significantly slower with no increase in accuracy. It also takes more memory (though you wouldn't notice until the haystacks are 1000+ characters).

    If you could compile the regex (Pattern.compile), or better yet use compiled Java code that uses regionMatches, that would be superior to lowerCase. But we don't have those luxuries in Velocity.

    The regex String.matches is harmless for small strings and I might well use it myself for readability (important in Velocity!) but we need to be aware it's not best design-wise.

    M
    Mark_Price
    New Participant
    April 29, 2019

    Usually, I just lowercase it before the #if block. This came about because I didn't want to make rules for: Value, value, VALUE, VaLuE etc.

    hope it helps!

    Chris_Wilcox
    Chris_WilcoxAuthor
    New Participant
    April 29, 2019

    Ok that could help! So you take all of the variables you're going to use in the logic, set them as lowercase, then reference the #set value in your contains? Or is there another way to do lowercasing that you're mentioning.

    Thank you very much!

    M
    Mark_Price
    New Participant
    April 29, 2019

    Yes, so long as your use case is fairly simple, that works: 

    ##toLowerCase example
    #set( $var = $fieldName__c.toLowerCase() )
    #if( $var == "pickup" )
    ##do work
    #elseif( $var == "delivery" )
    ##do other work
    #end

    ##toLowerCase example
    #if( $fieldName__c.toLowerCase() == "pickup" )
    ##do work
    #elseif( $fieldName__c.toLowerCase() == "delivery" )
    ##do other work 
    #end

    If you have a lot of potential values, you might use a list to make it more scalable.

    Note: I vaguely remember an issue where: $var.toLowerCase() may have limitations if you are sending emails in a foreign language such as French although I'm not 100% certain as my current instance is English only. Just wanted to mention it may be worth a test if needed for you.

      Terms & ConditionsAccessibility statement

      Loading footer...