Need more, need help now? we offer pay-as-you-go support, no contract, tenth of an hour billing, expert help, fast service, no call queue
We can offer lower cost Sage50cloud subscriptions for customer using pay-as-you-go support or who are self-supporting.
Need integration, your shipping system, your website, your invoicing system, your crm.
Need a bespoke solution, Mini Manufacturing, Spreadsheet order import, Back to back orders.
Want web hosting, email, your own domain name, a shop, we do it all!

Expression Building to find text after a space

Report design issues and solutions.
Post Reply
600720544
User
User
Posts: 6
Joined: 13 Mar 2017, 10:26
Sage Version: v2012 18 UK/Europe/Africa

Expression Building to find text after a space

Post by 600720544 » 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

600720544
User
User
Posts: 6
Joined: 13 Mar 2017, 10:26
Sage Version: v2012 18 UK/Europe/Africa

Re: Expression Building to find text after a space

Post by 600720544 » 22 May 2017, 13:16

Sorted my own problem
used substring(stock.description, (lastindexof(stock.description, " "))) if anyone else needs it.

Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests