split list with data on character and number

KNIME Analytics Platform
1

Hello i have a list with data like this
A11
B3
AG3
AD34
N6

Now I like to split the data in two columns like this
A 11
B 3
AG 3
AD 34
N 6

In excel there is a function like left() or right() or mid().
How can you do this in KNime

2

Hi,

Use this regex in Regex Split node:
([^\d]*)([\d]*)

:blush:

3

Thanks works fine, but not clear to me how it does it

4

\d means any digits.
[\d]* means zero or more digits. The brackets [] are unnecessary here.
[^\d]* means zero or more non digits.

When you want to split a string using the Regex Split node, you have to put each regex corresponding to each part in parentheses.

:blush:

5

Many thanks for the explanation