You're invited to Zoomtopia 2022! Our annual user conference will take place in the Americas on November 8-9 and in APAC, Japan, and EMEA on November 17.Learn more about our hybrid event experience
Everything you need to work together, all in one place.Explore Zoom One's Collaboration Tools
Connect virtually from anywhere with Zoom Meetings
Collaborate together with Zoom Chat
Call the world with Zoom Phone
Create and brainstorm with Zoom Whiteboard
Rich conversation analytics to improve sales
Send and receive messages and calendar invitations
Bring fluid interactions to hybrid teams with Zoom Huddles
Innovative video solutions for every meeting space.
Bring meeting spaces online with Zoom Rooms
Conference Room Connector links existing rooms to Zoom
Innovative solutions for every space
Solutions to host impactful virtual and hybrid experiences.Find a Solution for Every Event
Host hybrid and virtual events with Zoom Events
Elevate your brand with single session events powered by Zoom Sessions
Broadcast at scale with Zoom Webinars
Host and attend classes, group events, and more OnZoom
An omnichannel cloud solution optimized for video.
Engage customers with Zoom Contact Center
Deliver intelligent support with conversational AI
Zoom solutions elevate collaboration across vertical use cases.Discover Zoom Industry Solutions
Enabling exciting new ways to teach, learn, and connect globally
Transforming client engagement and employee experiences
Improving collaboration between agencies, ministries and constituents
Connecting care, collaboration, and medical innovation
Real-time communication, anywhere in the world
Bridging the in-store and online experiences
Expert support and services for all your design, strategy, implementation, event, and hardware needs.
Flexible subscription plans for hardware
An open platform that allows developers to build Zoom apps and integrations.
Explore over 1,500 apps in Zoom App Marketplace
Documentation for building on Zoom's platform using APIs, Webhooks, and SDKs
Resources that help developers evaluate & build with our solutions
Post your questions and get help from our developer community
Zoom Partners bring Zoom's communications platform to market through alliance, sales, and service partnerships.
Explore Zoom's technology ecosystem
Find a trusted Partner
Learn about Zoom's Partner Programs
Access marketing & sales resources
Login to the Partner Portal and click 'Learn'
Discover new ways to use Zoom solutions to power your modern workforce.
Access expert-led tutorials on Zoom products and features.
Network with other Zoom users, and share your own product and industry insights.
Get documentation on deploying, managing, and using the Zoom platform.
Keep your Zoom client up to date to access the latest features.Download Center
Download hi-res images and animations to elevate your next Zoom meeting.Browse Backgrounds
2023-01-19 04:03 PM
Zoom's exporting unassigned numbers by default puts in 3 spaces before the phone number.
Why is that?
if I need to copy/past this info, having the spaces is going to be a problem. how do you guys get around this.
I really don't feel like having to write excel formulas to remove the spaces.
other option, open in notepad++, remove space and quote and then open in excel, but why?
Does Zoom need these 3 spaces if i want to put these numbers into a CSV to assign numbers to extensions, or assign numbers to users?
2023-01-19 04:36 PM
I assume it is an artifact of their DB system as that is not the only place where spaces get exported in some fields in CSV files.....
2023-01-19 04:41 PM
Hi @dylanhunt ,
The space is added because when importing into a spreadsheet, the default formatting for cells is usually set to "Automatic", which in my experience sets cells formatted to a numerical value (i.e. a number).
So (123) 444-1234 is converted by the spreadsheet to 1234441234, which is not great.
What I have become accustomed to doing, is to export the DIDs from the Unassigned Tab. As you know this creates a CSV file.
I then import the CSV file to a new sheet, select all cells and set formatting to "Plain Text".
An alternative method / additional step would depend on the spreadsheet you are using. Your spreadsheet application may have a command that will automatically remove whitespace from cells. I have used this a few time when I forgot to set the formatting and had already merged the Unassigned DIDs with other data.
Google Sheets calls this feature "Trim Whitespace"
Excel has the "TRIM" Command
Hope this helps!
2023-01-19 04:48 PM
I don't import the exported CSV files into actual spreadsheet software, I use the CSV's for various custom scripts - the export process on the Zoom end is what is adding in the extra whitespace for some fields for some exports; I've had to put in code to trim out the whitespace when dealing with the files.
2023-01-20 06:40 AM
thanks guys for the tips!