0

Filter part of a field from another table

Hi guys,

 

I want to filter part of a field which is separated by a wild character. In my scenario this is separated by ";".

 

Example:

BG_1234_P;Spare-parts

Filter based on the part of the field in bold.

In order to find the actual part of the field (in my case this is the "Description" field), I use the formula below:

=LEFT(I9;FIND(";";I9)-1)

 

The problem is incorporating this in my formula because, 1) I want to filter only part of the field which is easy as I use the formula above as my filtering value and 2) how do I reduce the data I want to be matched with in my field which is the hard part.

I have read the thread below that didn't work. Maybe because I'm trying to fit a nested excel formula in JET and messes up.

https://support.jetglobal.com/hc/en-us/community/posts/115008502908-How-do-I-filter-and-retrieve-part-of-field- 

 

Thanks!

8 comments

Please sign in to leave a comment.