Forum Discussion
Data type account number
Hi,
Im buidling a financial dashboard based on data from SAP.
My data is a transactional list from SAP where the account number is one of the columns. The issue with my data is that some of the accounts contains a dash "-" in the middle of the account number. I want to remove this dash to be able to change the account number column to "whole number" data type without errors.
Is there a way to remove this dash for all accounts in one step in the query editor, or do i have to manually add a "Replace value" for all the accounts that contain a dash?
Thanks
Just select the account number column, right-click and choose Replace Values. Put "-" in the value to replace and nothing as the replacement. By default, this will match partial cells (not the entire cell).
2 Replies
Just select the account number column, right-click and choose Replace Values. Put "-" in the value to replace and nothing as the replacement. By default, this will match partial cells (not the entire cell).