Table / Dimension / How to cut text

[michak80]

Hello,

I have a column with following data:

CP10CPP11CF11CM1CS1

CP1CPP1CF2CM0CS0

I need only following information:

First column: data after CF (it's mean 11 for first example and 2 for second example)

Second column: data after CM (it's mean 1 for first example and 0 for second example)

Second column: data after CS (it's mean 1 for first example and 0 for second example)

I cannot use "mid" unfortunatly. 

Data	First column	Second column	Third column
CP10CPP11CF11CM1CS1	11	1	1
CP1CPP1CF2CM0CS0	2	0	0

[Clement15 · Accepted solution]

Hello,

If your field always has the same structure this should work

[michak80]

Thank you @Clement15 !!!

Works perfect.