How to replace the negative numbers with blanks?

Welcome to our Forums Technical Support Getting Started How to replace the negative numbers with blanks?

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #4653
    petercreate
    Participant

      Hi dgteam,

      I have a dataset shown in below. I want to replace all negative numbers with blanks. But I cannot make it in Data -> Find and Replace.

      Screen Shot 2020-08-07 at 23.53.52

      #4654
      dgteam
      Moderator

        You could use a mask column (or use a mask in a command to exclude them).

        Mask Column

        If you want to remove entirely (which it sounds like maybe you do), you can select the columns using the Find bar, select the rows, and then use Replace selected rows with empty.

        Here are the steps …

        1- Click Command-F

        2 – Set the filter, Value < 0

        3 – Click any row, and then use Command-A to select all

        Remove Neg

        4 – Click Done in the Find bar. This will show all the rows again.

        Remove Neg2

        5 – Right click on the column header and select Empty selected rows

        Remove Neg3

        You’re done!  If you use this approach, you can only do one column at a time.  Hide all other columns from view.

        Remove Neg4

        Hope that helps!

        #4655
        petercreate
        Participant

          Yes, it helped. Thanks.

        Viewing 3 posts - 1 through 3 (of 3 total)
        • You must be logged in to reply to this topic.

        Welcome to our Forums Technical Support Getting Started How to replace the negative numbers with blanks?