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

get ASCII code of character
#2

Hi,

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

:blush:

1 Like
#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:

1 Like
#5

Many thanks for the explanation

1 Like
#6

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.