Find&Replace Integers

[jordanParticipant]

I think that the find and replace implemented is very useful, and I like it a lot. I think that the find and replace could potentially use some tweaking when finding and replacing numbers. In the example screen shot, the intention is to replace the integer “0” with NaN, but you can see that the find and replace actually inserts NaN into other integers that include a numeral “0”. This does not make sense as “0” is not that same as “101”. It may be nice to make an option to deal with this. It did not seem like quotes for exact match or other syntax has been implemented to solve this problem. Thanks for the consideration.

 

[dgteamModerator]

That is a great point – an exact match would be a good addition.

For the moment you could select a row that contains a zero and control-click (right-click).

What ever you are clicking on you will see this option….

Then only those rows are selected …

Now when you open Data > Find & Replace  only the rows with ‘0’ are shown.

That said we agree having more options in the Find and Replace would make sense, rather than always having to preselect.

[jordanParticipant]

I look forward to improvements with Find and Replace, but this work around solves my problem. Thanks!

[davidModerator]

This has been addressed in the beta. You can specify that you need an exact match, so 0 will be converted to NaN and 100 will not be converted to 1NaNNaN

[jordanParticipant]

Thanks so much!

[Author]

Posts