How to make array from semikolon-separated text

[OnlyOne]

Hello,

i have a text with multiple lines. The lines are separated with \r\n.

In each line is the same number of values that are separated with semikolons ;

How can i (easy) make arrays of each value in a line?

Currently i solved it by creating a loop and using match-pattern, shift register, insert to array...... But this looks very big.

How can i make this easier?

Thanks for the help

[MikeS81]

Hi OnlyOne,

you can use the "Spreadsheet String to Array" function.

Mike

[OnlyOne]

How do i use this?

Attached my current version (LV 8.2)

[MikeS81 · Accepted solution]

Hi,

you have to define the seperator.

See the attached image.

Mike