Victor_Herrero

Hi!  I have been having issues trying to split a series of strings in one line by different delimiters.  This is the code I am using:    #set ($latestMeetingTimeFromArray = $latestMeetingTimeFrom.split("\s|[:\.]")) #set ($latestMeetingTimeFromArrayString = $convert.toString($latestMeetingTimeFromArray)) array : $latestMeetingTimeFromArrayString <br>   (I'm printing out the array for debugging) $latestMeetingTimeFrom can have values like the following:    12:00 PM 1:30 AM 11.00 PM   My aim is to store hours minutes and the meridiem in three separate variables, and as you can see, the delimiters are colon, dot and space.  I have tried all sorts of supposedly valid regex expressions to indicate all possible delimiters (with character set, three individual chars in OR, one char set with all three... ) and I have even tried passing a limiter of 0 and 3, but still the array ends up containing only one character: the hours value.  Example output: The only way I have managed to get this to work is by replacing all delimiters with the same one (i.e. a space), then simplyfying the regex to just that one character.  Additionally, those three lines of code already break the email when there is a "." separating hours and minutes. Here is the error   Any idea why this is happening?  ... View more

Hi,    Is it possible to create a smart list and segment it by attributes from a related object?  Is it possible to do the same thing with Velocity at least?  Alternatively, could a report in salesforce automatically and periodically (or perhaps at runtime) update a list in Marketo?   The whole problem is not being able to tune a communication to a target audience based on information that is stored in a related object.   Here is the scenario we are struggling with:   Our business operates with two types of customers (Hosts and Guests) and our business model is about matching them for a cultural exchange.  We want to send a communication to Hosts in a specific opportunity stage (we call it Finalled), but we want to segment this communication depending on an attribute from their Guest: their type (which can be say "A" or "B").    In Salesforce this could be solved with a query, but in Marketo I haven't found a way to Create a smart list like this:  Finalled Hosts whose Guest is of type A.    This would mean querying a related object in Salesforce and I haven't figured out how to do this in Marketo.  I was exploring the possibility to use SOQL in Velocity (but haven't found an answer yet). If this were possible, maybe I could just create one email with a script token that outputs different text depending on the guest type.    Thanks for your help in advance! ... View more

    Hi,    I have been having an issue with links in some of our emails. The link contains an important parameter for an id that can be in two different fields but i don't know which, so I check both in the script token and get the first non-empty match.    The link inside the email looks like this:  {{my.ar_referral_url} } ?ls=Referral&lsd=Au+Pair+Referral&utm_source=Referral&utm_medium=Email&utm_campaign=AR_direct+referral_AR+Referral+Campaign_PreDeparture&apid={{my.aupairID_master} } &reftype=Aupair&sfc=7013q000001kOgt&sfcs=Responded     The script token looks like this:    ## Returns the first populated Au Pair Id / Au pair ## from either the Lead, Contact, Account or Opportunity objects ## ## ## Define possible variables ## // Au Pair Number should be used instead of Au Pair ID, ## // since Au Pair ID can be different in Tellus sometimes #set($AupairNumber = "initial value") #set($empty = "") ## ## Determine the first not empty value #if(${lead.AP_Au_Pair_Number__c} != $empty) #set($AupairNumber=${lead.AP_Au_Pair_Number__c}) #elseif(${company.AP_Au_Pair_Number__c} != $empty) #set($AupairNumber=${lead.Au_pair_number__c}) #elseif(${OpportunityList.get(0).Au_Pair__c} != $empty) #set($AupairNumber=${OpportunityList.get(0).Au_Pair__c}) #else #set($AupairNumber = "unknown") #end ## ## Return not empty value $AupairNumber     And in preview renders correctly (valid url and 'apid' correclty rendered):  But the real email either redirects to this in gmail when I click, before I replaced the first regular token with a splled-out url (url invalid)     Or this after replacing the initial regular token (url valid but 'apid' is now empty)     Any insights into why this is happening? I deactivated link tracking as well for this link, since I already noticed that breaks links with script tokens  Perhaps you @SanfordWhiteman ?   Thanks! ... View more