I'm having trouble creating a formula that will split a field value after a number.

 

The database holds information on refuse collection day and the content of the field to be split is always in the format

 

"Domestic Round X Y Week Z"

 

where X is a number from 1-6
Y is a day of the week from Monday-Friday
Z is either "1" or "2"

 

eg
Domestic Round 1 Friday Week 2
Domestic Round 5 Monday Week 1

 

I want to split the field after the number so that in the two examples above it would return
"Friday Week 2"
"Monday Week 1".

 

I can split it based on a set number eg after "Domestic Round 1" using the formula below

stringVar array Size := Split({PPV_ROUTE.ROUTENAME},"1 ");
if UBound(Size)>=2 then
Size[2] else "";

 

but how would i set it up to say split after any number?