Page 1 of 1

Retrieve a character string after a character string in a data

Posted: Tue Dec 21, 2021 12:00 pm
by 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

Re: Retrieve a character string after a character string in a data

Posted: Wed Dec 22, 2021 2:56 pm
by Max Shamanov
Hello,

We need time to prepare an answer for you.

Thank you.

Re: Retrieve a character string after a character string in a data

Posted: Wed Dec 22, 2021 5:58 pm
by toony63
thank you for your comeback
I look forward

Re: Retrieve a character string after a character string in a data

Posted: Thu Dec 23, 2021 12:24 pm
by Max Shamanov
Hello,

Please see the attached report.

Thank you.

Re: Retrieve a character string after a character string in a data

Posted: Thu Dec 23, 2021 1:55 pm
by toony63
Thank you for the feedback
after adaptation of the code it's perfect
thanks a lot

Re: Retrieve a character string after a character string in a data

Posted: Thu Dec 23, 2021 2:13 pm
by Max Shamanov
Hello

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

Thank you.