Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Query error editor

Hallo everybody,   I have some rows that contains some simple errors. some colums have the number properties. in some of the rows are filled with -. This creates an error. so i want to replace - ...
Need Help
Tips and Tricks
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi Anonymous,

     

    Please change the data type of that field from "Any" to "Text" before replacing values. Then, you can replace "-" with "0" or empty. After replacing, you can change the data type to "Whole number".

     

    Best regards,

    Yuliana Gu

themistoklis's avatar
themistoklis
Icon for Community Champion rankCommunity Champion
7 years ago

Why dont you replace '-' with zero as it is a number column?

 

Is it going to cause you any problems?

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    in the replace values command it will not accept '-' as a value to find and replace.

    it most be a number to find and replace.

     

    • PattemManohar's avatar
      PattemManohar
      Icon for Community Champion rankCommunity Champion
      7 years ago

      Anonymous Tried the same and able to replace '-' with 0

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        your replace values interface is different than my.

         

        im using the last update. what version are you using?

        or is this some configuration?