Splitting text
Posted: 20 Aug 2020, 10:05
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
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