[Stackoverflow] [Progress OpenEdge ABL] Using num-entries() with more than one possible delimitor

[Felice]

I have a list of email addresses that I am reading in from a csv file, that are sometimes separated by commas and sometimes by semicolons when the person has more than 1 email address.

Examples:

Pin email_address
11  heidi@gmail.com,hh@yahoo.com
12  tom@osu.edu;TQ@gmail.com
13  lisa@yahoo.com
14  linda@me.com;llewis@gmail.com,lvlv@yahoo.com

Let's say I am reading these into a variable and counting them per person with another variable:

DEFINE VARIABLE emailString AS CHARACTER NO-UNDO.
DEFINE VARIABLE iEmailCount AS INTEGER.

I want to count the number of emails for the person. I know that I can use this syntax to count the entries between semi-colons, and between commas respectively.

iEmailCount = NUM-ENTRIES (emailString, ";").
iEmailCount = NUM-ENTRIES (emailString).

But how can I best say...

iEmailCount = Num_ENTRIES(emailString,";" OR ",").

Continue reading...