How can I add a condition to a dynamic marketing list to only include phone numbers with 12 digits?

(0) Share

Report

Posted on by Kate M

I currently have a dynamic marketing list which targets certain contacts in CRM. I want to restrict the list to only include contacts where the Mobile Number field contains 12 digits.

How can I restrict based on number of digits?

Is there a wildcard option within marketing lists that will allow me to specify the digits? I have tried ############, %%%%%%%%%%%% and ************ but these do not work as needed.

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

cloflyMao 25,210 on at

Like (0)

Report

Hi Kate,

Currently wildcard is not supported in Segment filters.

A workaround is that you could build a custom plugin to calculate length of phone field, and set a custom boolean field to "Yes" if record meets the condition.

Then we could easily find contact whose phone field contains 12 digits by the custom field value.

Regards,

Clofly

Was this reply helpful? Yes No