Data type account number

[Anonymous]

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

[Greg_Deckler · Accepted solution]

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).

[Anonymous]

Thanks, tried this first, but it did not do anything. Had to convert the column to text before replacing. Then converted back to whole number