Incorrectly formatted phone number in OTBI table
Hello! I have noticed a situation in our Fusion tables that I'm curious about resolving. We are currently seeing two phone numbers for two different phone types that have different formatting. We're using the field in some integrations so it's being fed inconsistently downstream.
We are seeing the phone number with dashes on the front end regardless of how the person entered the information but it appears as below in the tables.
What causes the phone number to be submitted in these different formats and is there any way to normalize that format so we can send consistent data downstream?