SORE ROW.xlsx (9.3 KB) Hello, Could you please help me to sort column A to column C pattern? Thanks, Yen

I would split the letters and numbers into different columns either by Regex or position, and then use the Sorter node to sort by numbers first / then by letters. [image] split list with data on character and number KNIME Analytics Platform 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

Hi! You can use the Regex extractor from palladin node to it… [image] An example of it [image] You set the regex and it split it for you as rows, column, list… [image] Regex Extractor — NodePit Extract fragments from text using regular expressions. For install extension: https://download.nodepit.com/4.7 BR, Denis

Sorting Row

KNIME Analytics Platform

iCFO May 25, 2023, 3:02am 2

I would split the letters and numbers into different columns either by Regex or position, and then use the Sorter node to sort by numbers first / then by letters.