Need more help now? use pay-as-you-go support, call now 03333 445950

We offer rebates on Sage50 subscriptions, discounts on products, service sagecover (not renewals) and stationery.

We also provide Sage 50 integration and email/web services.

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 1 guest