Subfield with variable length

Tue, 04 Nov 2014 11:11:54 GMT

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 !

Re: Subfield with variable length

MK_QSL — Tue, 04 Nov 2014 11:13:03 GMT

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

Tue, 04 Nov 2014 12:28:57 GMT

Thanks lot