Zp gzp set cells of current column for current/selected row(s) to last clipboard value ![]() Y gy yank (copy) current/all selected row(s) to clipboard in Memory Sheet x gx cut (copy and delete) current/all selected row(s) to clipboard in Memory Sheet zy gzy yank (copy) contents of current column for current/selected row(s) to clipboard in Memory Sheet zd gzd set contents of current column for current/selected row(s) to options.null _ value zx gzx cut (copy and delete) contents of current column for current/selected row(s) to clipboard in Memory Sheet p P paste clipboard rows after/before current row Ga gza number append number blank rows/columns Use g' to freeze sheet contents in a deliberate copy.Įditing Rows and Cells a za append blank row/column appended columns cannot be copied to clipboard The rows in these duplicated sheets (except deepcopy) are references to rows on the original source sheets, and so edits to the filtered rows will naturally be reflected in the original rows. Gz" open duplicate sheet with deepcopy of selected rows " open duplicate sheet with only selected rows Gz sort ascending/descending by all key columns add to existing sort criteria Z sort ascending/descending by current column add to existing sort criteria G sort ascending/descending by all key columns replace any existing sort criteria Row Sorting/Filtering sort ascending/descending by current column replace any existing sort criteria Z, gz, select rows matching typed value of current cell/row in current column/all visible columns G, select rows matching display value of current row in all visible columns , (comma) select rows matching display value of current cell in current column Z| z\ expr select/unselect rows matching Python expr in any visible column G| g\ regex select/unselect rows matching regex in any visible column | \ regex select/unselect rows matching regex in current column Gzs gzt gzu select/toggle/unselect all rows from cursor to bottom Zs zt zu select/toggle/unselect all rows from top to cursor ![]() Row Selection s t u select/toggle/unselect current row replay-movement toggle -play to move cursor cell-by-cellįield = value replace ") within that column ![]() o, -output= file save final visible sheet to file as. b, -batch replay in batch mode (with no interface) REPLAY MODE -p, -play= cmdlog replay a saved cmdlog within the interface Rows can be selected, filtered, and grouped columns can be rearranged, transformed, and derived via regex or Python expressions and workflows can be saved, documented, and replayed. Vd + toplevel: subsheet: col: row DESCRIPTION VisiData is an easy-to-use multipurpose tool to explore, clean, edit, and restructure data. NAME VisiData - a terminal utility for exploring and arranging tabular data
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |