How to extract a number from a text column
Dear all,
I would like to extract a number from a text-column which contains many other numbers.
Example => Date: 01.01.2024 / 11:55:22 submitted by example company XY 123/456/789 80 1.111.111,50 81 222.222,22
Number to extract => 1.111.111,50 & 222.222,22
I always need the number following ‘80’ and ‘81’. But not all columns contains that numbers.
Does it work with the ‘column expression’ node?
I have no idea how to do this.
Thank you in advance if you can help!