Sheets - Spliting data from 1 cell into many adjacent columns

Webix JS
#1

Hi,

We have a usecase where a cell has two types of data which can be copied into it or imported, and we need it parsed or separated into NEW columns or spread out into New cells

Example: A1 has a bunch of data copied to it, it has “/” as a separator and we need to build a small process which would move each into a new column like B1 and C1 etc

Example 2: A1 has a bunch of data separated by a SPACE and maybe has hidden chars which we need removed. Then it also separates into columns

#2

Hello,

Assuming that your data comes from the outside (it’s not the data from another Spreadsheet cell, yeah?), I can suggest pasting data manually using the mapCells method of inner datatable, which will override the default pasting logic:

Please, check the snippet: https://webix.com/snippet/0ca83f59

#3

Works good. This plus regex pre-processing solves it!

Thanks and sorry about the delayed reply