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!
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)