ctrl+shift+p filters: :st2 :st3 :win :osx :linux
Browse

Data Wizard

by nickklaskala ALL

ST3/ST4 package for advance data manipulation of flat files. supports pivot datagird, pop columns to end (cycle), justify columns, collapse columns, data masking(suffle list, suffle characters in column vertically to preserve format string). This Package is especially helpful for ETL or any task that interfaces with delimited flat files in which you are constantly opening files and inspecting them. Allows for instant human readability and analysis.

Details

Installs

  • Total 16
  • Win 8
  • Mac 7
  • Linux 1
Jul 26 Jul 25 Jul 24 Jul 23 Jul 22 Jul 21 Jul 20 Jul 19 Jul 18 Jul 17 Jul 16 Jul 15 Jul 14 Jul 13 Jul 12 Jul 11 Jul 10 Jul 9 Jul 8 Jul 7 Jul 6 Jul 5 Jul 4 Jul 3 Jul 2 Jul 1 Jun 30 Jun 29 Jun 28 Jun 27 Jun 26 Jun 25 Jun 24 Jun 23 Jun 22 Jun 21 Jun 20 Jun 19 Jun 18 Jun 17 Jun 16 Jun 15 Jun 14 Jun 13 Jun 12
Windows 0 0 0 1 2 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 1 0 0 0 0 0 1 2 0 0 0 0 1 0 0 0 0 0 1 0 0 0 0 0 0
Mac 0 0 0 0 0 0 0 0 0 0 0 1 0 0 1 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 1 0 1 1 0
Linux 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Readme

Source
raw.​githubusercontent.​com

DataWizard

ST3/ST4 package for advance data manipulation of flat files. supports pivot datagird, pop columns to end (cycle), justify columns, collapse columns, data masking(suffle list, suffle characters in column vertically to preserve format string). This Package is especially helpful for ETL or any task that interfaces with delimited flat files in which you are constantly opening files and inspecting them. Allows for instant human readability and analysis.

Notes: it is strongly recommended to key bind the pivot, pop, justify, and collapse commands. Recommended Key Bindings

[
    { "keys": ["alt+\\"], "command": "datawiziardjustifycolumns"},
    { "keys": ["alt+shift+\\"], "command": "datawizardcollapsecolumns"},
    { "keys": ["alt+shift+p"], "command": "datawizardpivotjustify"},
    { "keys": ["alt+p"], "command": "datawizardpivot"},
    { "keys": ["alt+o"], "command": "datawizardpop"}
]

Justify Columns (auto detects delimiters) Justify

Collapse Columns Collapse

Pivot Pivot

Pivot and Justify PivotAndJustify

Pop pop

LeadingZerosAddRemove LeadingZerosAddRemove

Random data Random

Shuffle Columns ShuffleColumnVertically

Shuffle Characters vertically within equal length strings ShuffleCharsVertically

Sample Delimited Sample

Sample JSON Sample

Distinct Characters Sample

Other misc function Read Py Variables PyVarToText

SQL Inserts PyVarToText