Expression Building to find text after a space
Posted: 22 May 2017, 13:02
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
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