Fill empty cells with a particular value

[adamrp]

Improvement Description The particular value might be user-defined, or pre-defined (e.g., NaN)

[jairideout]

:+1: this would be really handy for e.g., QIIME, which doesn't support empty cells.

[jairideout]

This can be accomplished by using the search-and-replace functionality built into Google Sheets. Turn on regex mode and enter ^$, then hit "replace all" to replace all empty cells with a particular value. You can also restrict the search-and-replace by selecting only a portion of the sheet.

@adamrp does this work for your use case? If so I'll close the issue.

[adamrp]

Works for me! I would suggest putting the workaround (if it can be called that) in the keemei documentation, even if it is already in the google docs documentation, so that users know about it, since I do think that this will be a common task for keemei users

On Wed, Apr 1, 2015 at 6:13 PM, Jai Ram Rideout notifications@github.com wrote:

This can be accomplished by using the search-and-replace functionality built into Google Sheets. Turn on regex mode and enter ^$, then hit "replace all" to replace all empty cells with a particular value. You can also restrict the search-and-replace by selecting only a portion of the sheet.

@adamrp https://github.com/adamrp does this work for your use case? If so I'll close the issue.

— Reply to this email directly or view it on GitHub https://github.com/jairideout/Keemei/issues/35#issuecomment-88672340.

[jairideout]

Good idea! I'll add some instructions to the docs.

[adamrp]

Thanks, Jai, I think this can be closed!

On Thu, Apr 2, 2015 at 8:53 AM, Jai Ram Rideout notifications@github.com wrote:

Good idea! I'll add some instructions to the docs.

— Reply to this email directly or view it on GitHub https://github.com/jairideout/Keemei/issues/35#issuecomment-88935238.

[jairideout]

I'm going to leave it open for now until I can add the instructions to the documentation.