Page 1 of 1

Expression Building to find text after a space

Posted: 22 May 2017, 13:02
by 600720544
All product contain a description followed by a space then a number and 1 or 2 letter e.g. washer 12a, washer 14bb. what i need for a stock taking list is an expression that sort by size.
i use the expression << Substring(STOCK.DESCRIPTION, Length(STOCK.DESCRIPTION) - 4) >> which gives me a list in single letter order then restarts with double letters eg 12a, 12b, 14d, 16a, 12aa, 12bb.
i understand my expression sorts the last 4 characters so space14a come before 12aa.
Can anyone help build an expression to sort text after the last space in the field.
Thanks in advanced

Re: Expression Building to find text after a space

Posted: 22 May 2017, 13:16
by 600720544
Sorted my own problem
used substring(stock.description, (lastindexof(stock.description, " "))) if anyone else needs it.