Retrieve a character string after a character string in a data
Posted: Tue Dec 21, 2021 12:00 pm
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
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