Retrieve a character string after a character string in a data

[toony63]

hello everyone sorry for the translation,

I cannot retrieve a string inside a data

example :
I have a text like (in my data):
"1-leaf door - Frame color: RAL 1001 - Interior finish: RAL 1001 - Exterior finish: RAL 1001 - Non-contractual photos"

I would like to recover the RAL values
once after "Frame color:"
once after "Interior finish:"
and the last "Exterior finish:"

But I can't find the right formula

in advance thank you for your feedback

[Max Shamanov]

Hello,

We need time to prepare an answer for you.

Thank you.

[toony63]

thank you for your comeback
I look forward

[Max Shamanov]

Hello,

Please see the attached report.

Thank you.

[toony63]

Thank you for the feedback
after adaptation of the code it's perfect
thanks a lot

[Max Shamanov]

Hello

You are welcome.
Please let us know if you need any additional help.

Thank you.