Can you try out the below expressions:
If the differentiators will not exist in the returned number, then you can use below expression:
Part1: Set(Part1, Last(FirstN(Split(Substitute(Substitute(Substitute(Substitute(Label7.Text,"01",";"),"240",";"),"17",";"),"10",";"),";"),2)).Result)
Part2: Set(Part2,First(LastN(Split(Substitute(Substitute(Substitute(Substitute(Label7.Text,"01",";"),"240",";"),"17",";"),"10",";"),";"),2)).Result)
Part3: Set(Part3,Last(Split(Substitute(Substitute(Substitute(Substitute(Label7.Text,"01",";"),"240",";"),"17",";"),"10",";"),";")).Result)
In case, the number of characters in the returned string will be same, you can use:
Part1: Set(Part1, Mid(Label7.Text,2,12))
Part2: Set(Part2, Mid(Label7.Text,16,5))
Part3: Set(Part3, Mid(Label7.Text,23,8))
You need to replace Label7.Text with the control/field returning the value.
Hope this Helps!
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
