Forum Discussion
I would use the Part function, as well as some Left function. Would be a long code, but repetitive so not too bad.
So your field that is extracting your 9 or 16 would look like this
var text TaxYear = [Tax Year Field];
var text SummaryField = ToText([The Summary Field]); //this only needs the ToText if it is a combined text field or something other than text
var text PartOneSummary = Trim(Part($Summary, 1, ";" ));
var text PartTwoSummary = Trim(Part($Summary, 2, ";" ));
.
.
var text PartThirtySummary = Trim(Part($Summary, 30, ";" ));
If(
contains($PartOneSummary, $TaxYear), Left(PartOneSummary, "/"),
contains($PartTwoSummary, $TaxYear), Left(PartTwoSummary, "/"),
.
.
contains($PartThirtySummary, $TaxYear), Left(PartThirtySummary, "/")
)
------------------------------
Mike Tamoush
------------------------------
Thanks Mike, that code makes sense and seems to be working a charm.
Much appreciated.
Joe
------------------------------
Joe Alderson
------------------------------