Split a string

Hi, i am pulling some data and have used the regexp to pull out a string of numerical values.

so for example, ive got the following,

269.00
1500.00
789.00
2600.00

i would like to create an if statement, so i could separate the values in to groups, for example, i would like to group all values below 1000.00, all values between 2000.00 and 1001.00, etc.

is this possibe? Thanks, Sam

i’m almost sure you have to convert to values first.

then there are multiple ways to Select what ever you want.

the 2nd approach seems more elaborate but keep that epsilon feature of the = (Value) in mind…

SamSelect.v4p (14.6 kB)

thats right, alphabetic sorting would only be possible, if the numbers had leading zeros.