7 months, 2 weeks ago 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.7 months, 1 week ago 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.7 months, 1 week ago jordanParticipant
I look forward to improvements with Find and Replace, but this work around solves my problem. Thanks!7 months ago 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 1NaNNaN7 months ago jordanParticipant
Thanks so much!
You must be logged in to reply to this topic.