Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Why Export Contact Object Erases the Leading Zeros from Phone Numbers? — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Why Export Contact Object Erases the Leading Zeros from Phone Numbers?

Accepted answer
1
Views
1
Comments
edited Aug 4, 2022 5:26PM in Sales 1 comment

Summary:

Why Export Contact Object Erases the Leading Zeros from Phone Numbers?

Content (required):

**This post was created as part of a How to Service Request (SR) **

Export the contact object via Export Management, in the export output .csv file, leading zeros are erased from PhoneAreaCode and PhoneNumber fields. Why?

select owner_table_id, PHONE_AREA_CODE, PHONE_NUMBER, raw_phone_number from fusion.hz_contact_points where owner_table_id in (300000156472372,300000156519245);

 OWNER_TABLE_ID   PHONE_AREA_CODE        PHONE_NUMBER    RAW_PHONE_NUMBER

    300000156472372                                                  04112345678             1-04112345678

    300000156519245   041                                               1234567                 1-041-1234567

Instead of seeing 041 for the Phone Area Code in the output .csv file, you see 41.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!