Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Subfield with variable length

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 !

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

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

View solution in original post

2 Replies
MK_QSL
MVP
MVP

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

Not applicable
Author

Thanks lot