Check if text field begins with a range of letters

Follow

Nathan Velasquez

• August 16, 2018 01:26

I have a dilemma. I need to check if a text field containing an Email address, begins with a certain letter range, let's say a-m, then return the value of the email IF the first letter of the Email address falls within the range a-m or n-z or an integer. I will need to make at least 2 if not 3 calculation fields. If true it just needs to return the Email address.

WHY: I have some automated Emails being pumped out with Globiflow, HOWEVER, with Office365 can only send to 500 recipients at the same time. I am trying to break up the list and send 2-3 Emails which is within the limits of Office365. I will at least need to break this up in half, but I also have some emails beginning with numbers and need to include them as well either separately or together with one of the alphabet ranges.

0

• 

  Paul Renshaw

  • September 24, 2018 12:41

  e.g. for first letter in a-m:

   

  var range = "abcdefghijklm";

  if ( range.indexOf(@fieldname.substr(0,1)) > -1 ) {

      var result = @fieldname

  } else {

      result = ""

  }

  result

  0

  Comment actions Permalink

Please sign in to leave a comment.