How to split "1.2.11.3" into "1" + "2" + "11" + "3"

Need help Database
1

Hi,

wow can I split a String Text in my DB into several columns? So it should work somehow with split but I don’t get it. And how would I than “assign” it into my Columns:

1 into C1
2 into C2
11 into C3
3 into C4

???

3

Hi there, @lars1… if I understand your post correctly, you are either going to be creating a new thing in a data type or making changes to an existing thing. In the workflow where you are creating or making changes, you would update each field in the appropriate thing with an expression that looks something like C1 = string text:split by(.):item#1, C2 = string text:split by(.)item#2, and so on.

Hope this helps.

Best…
Mike

4

@mikeloc is correct, but I will still share an example I threw together

Here is the example:

Here is the editor: