This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Upgrading Server to version 22.1? We’ve enabled the faster AMP engine by default. Read about how these system settings changes might affect you.
2022-05-24 Updates: Login: If you are facing issues with logging in, please try clearing all your cookies or trying another browser. We have a fix being deployed on the evening of 5/25. Email: If you're not seeing emails be delivered from the Community, please check your spam and mark the Community emails as not junk. Thank you for your patience.
you will need to learn how to set up the pattern to match what your data looks like and what you're trying to do. you can use this tool to pick only text characters or only numbers or a lot of other patterns
One column can have only one data type. Maybe you can create two new columns. Use a select tool in order to change the data type to the number and if some of them become empty when you change the data type you should create a new column with text but only for those positions that are empty.