Skip to main content

I have two objects with Phone fields in them. Object A's phone field contains "1234567890" in it and Object B has "123-456-7890". I have a flow that compares the two phone fields in a Decision element and finds that they are not equal. 

 

Is there an easy way to compare two phone fields so that it only compares them numerically? I'm planning on creating a Standardized Phone Number field in each object and creating a flow that extracts the numeric part of the phone numbers and puts it into the Standardized Phone Number field, but am hoping there's a simpler way.

 

Thanks!

#Data Management

5 件の回答
  1. 2022年5月19日 2:50

    So basically something kinda like this? 

     

    SUBSTITUTE(

    SUBSTITUTE(

    SUBSTITUTE(

    SUBSTITUTE(

    SUBSTITUTE(

    SUBSTITUTE(Phone_Field_A,

    "(", NULL),

    ")", NULL),

    "-", NULL),

    " ", NULL),

    "+", NULL),

    ".", NULL)

    <>

    SUBSTITUTE(

    SUBSTITUTE(

    SUBSTITUTE(

    SUBSTITUTE(

    SUBSTITUTE(

    SUBSTITUTE(Phone_Field_B,

    "(", NULL),

    ")", NULL),

    "-", NULL),

    " ", NULL),

    "+", NULL),

    ".", NULL)

0/9000