Hello all,
I use the line information(JobNumber) field to record some information on an invoice,
The numbers could be as follow
1-1-1 ~ 1 up to 14-10-99 ~ 3000
Is there a way in the report to split these at the ~ and remove the ~ Leaving me with two parts to the JobNumber field on the report?
Thanks in advance
Splitting text
- brucedenney
- Site Admin
- Posts: 4631
- Joined: 28 Feb 2006, 09:56
- Sage Version: v28 UK/Europe/Africa
Re: Splitting text
You need to write expressions to extract the bit you want.
For the first part
For the Second
For the first part
Code: Select all
Substring(SALES_LEDGER.ANALYSIS_3, 0, IndexOf( SALES_LEDGER.ANALYSIS_3,"~"))
Code: Select all
Substring(SALES_LEDGER.ANALYSIS_3, IndexOf( SALES_LEDGER.ANALYSIS_3,"~")+1,99)
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Re: Splitting text
Hi Bruce,
Thank you, that’s absolutely brilliant.
I have been trying to workout substring all day but haven’t succeeded... will try later.
Is there any documentation regarding the operators and exactly to use them??
Thanks again
Thank you, that’s absolutely brilliant.
I have been trying to workout substring all day but haven’t succeeded... will try later.
Is there any documentation regarding the operators and exactly to use them??
Thanks again
- brucedenney
- Site Admin
- Posts: 4631
- Joined: 28 Feb 2006, 09:56
- Sage Version: v28 UK/Europe/Africa
Re: Splitting text
There is a KB article on the sage website but it is not detailed.
https://ask.sage.co.uk/scripts/ask.cfg/ ... 78&DIV=SBD
https://ask.sage.co.uk/scripts/ask.cfg/ ... 78&DIV=SBD
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Who is online
Users browsing this forum: No registered users and 1 guest