Scompose string in each character

[micheledenardi]

Dear all,
i have a record like this:

Field1

AB123/$_§*5G

and i would like to split each character on different row, to obtain this:

Split

A

B

1

2

3

/

$

_

§

*

5

G

How to achieve it?

Thanks

[Clement15 · Accepted solution]

Hello,

You can use something like this.

Data:
LOAD * INLINE [
Field1
AB123/$_§*5G
];

SplitData:
LOAD
Mid(Field1, IterNo(), 1) AS Split
RESIDENT Data
WHILE IterNo() <= Len(Field1);