Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals

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 11 guests