I have a string of text data CustomerName:Job Number:SubJobNumber
I need to make a formula to extract each piece to its own field IE
Everything is against:
All Characters left of the first :
All Characters between the first and last :
All Characters to the right of the last :
Formula 4 (Most Important)
Taking the Last 3 numbers if they occur after a - (not everything has subjobs) and being able to sort that as an integer.