How to extract number and letter in 1 column

how to extract number and letter from 1 column. I tried regex split and string manipulation but it didn’t work.

Number only column=regexMatcher($string-column$, “[0-9]")
Letters Only columnregexMatcher($string-column$, "[A-Za-z]
”)

LOANS-DEMAND-PURPOSE
3800,000.00- 657,934.58- 3800,000.00- 657,934.58- 0.00 0.00
150,246.45- 26,013.77- 150,246.45- 26,013.77- 0.00 0.00
1622,019.29- 280,837.52- 1622,019.29- 280,837.52- 0.00 0.00
446,798.09- 77,358.92- 446,798.09- 77,358.92- 0.00 0.00
1352,823.89- 234,228.84- 1352,823.89- 234,228.84- 0.00 0.00
LOANS-DEMAND-PURPOSE
18690,388.00- 219,173.39- 18690,388.00- 219,173.39- 0.00 0.00
LOANS-DEMAND-PURPOSE
875,145.15- 875,145.15- 875,145.15- 875,145.15- 0.00 0.00
LOANS-DEMAND-PURPOSE
896,791.81- 1636,158.09- 896,791.81- 1636,158.09- 0.00 0.00
443,747.32- 809,597.90- 443,747.32- 809,597.90- 0.00 0.00
9226,416.51- 16833,200.18- 9226,416.51- 16833,200.18- 0.00 0.00
95,890.25- 174,947.63- 95,890.25- 174,947.63- 0.00 0.00
LOANS-DEMAND-PURPOSE
11685,295.57- 15773,980.48- 11685,295.57- 15773,980.48- 0.00 0.00
5626,003.89- 7594,542.65- 5626,003.89- 7594,542.65- 0.00 0.00
12155,886.41- 16409,231.06- 12155,886.41- 16409,231.06- 0.00 0.00

Hi @seanmanzanilla -

Please post questions like these to the KNIME Analytics Platform forum. This forum is for more specialized node development issues.

Thanks!

(I went ahead and moved this and your other threads for you.)