Text String --> Regex --> Collection --> Array in one stop?

How To
1

Hi,

I have a string like “A 1 B 2 C 3 D 4”… variable length.

And I created a DataStore in which one column is of the following structure:
RowField1: Type Array
Array of Collection
* CollField1: String
* CollField2: Number

Do I have a way to fill this Array Field directly:

  • from the DataStore Add row
  • or alternatively in just one additional operation
    for example by parsing the string using regex, generating the structure and updating the row field?

Many thanks for your support!

2

I finally did it with one additional operation:
JSON Parser:

  • Input string: parse it to clear unwanted data
  • Generate collection JSON structure as { key1:value1, key2:value2}
  • Generate JSON array of collections
  • Don’t select a structure in the parser

DataStore AddRow module:

  • In map mode, assign directly the output of the JSON Parser module to the cell supposed to contain the array of collections
3 Likes
3

Brilliant stuff @Beaver , thanks for sharing the solution with the community! :purple_heart:

1 Like
4

I would love to see this in a screen shot tutorial.