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

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        I would like too share it. But i got alot of sheets in it. Will 1 excel sheets will be enuff?

        Maybe this is the source of the problem?