Subfield with variable length

[#1]

Hello everyone,

I want to use the subfield function to extract the last string after the character "\".

To do this, I am using this function :

=subfield([Category], '\' ,3)

However, sometimes the string isn't in the 3rd position, but can be to the first or the second.

Do you know if it is possible to do, in fact, "extract the last string. If there is not "/", take all the string"

Thank you !

[MK_QSL · Accepted solution]

=subfield([Category], '\' ,-1)

[#3]

Thanks lot