We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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 May 25, 2022 7:19PM 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) 3-29537852971 **

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!