Sorting Row

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.

Hi!

You can use the Regex extractor from palladin node to it…

image

An example of it

You set the regex and it split it for you as rows, column, list…

For install extension: https://download.nodepit.com/4.7

BR,

Denis

1 Like

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