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?

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

        Anonymous

         

        It does work. Can you please share the workspace with us to see what is wrong?

        Maybe it is another character there