Hi
I have a string that I need to split but this is driving me crazy
P255721Q1D25092025
Needs to be split into 3 fields
1 after the P but before Q (can be different lengths)
2 after Q but before D (can be different lengths)
3 after D (always the same length. It is a date)
Any help appreciated
Reagrds
Gus