Startswith functionality

Question

Hi all,

I have a list of items from which I need to find that starts with a particular word. I am trying the startswith function but not getting the desired results.

For example, I need to find all products that start with Star - Star ABC, Star XYZ. However, I don't want products in my results like StarAA, StarCDB etc.

Am I using the right function for this requirement?

Jonathan-Sherman · Accepted Answer

Hi @GaurVitul,

The StartsWith() function sounds like a good call, could you include some sample data with the product text and the outcome you'd like from those rows in your filter?

Regards,

Jonathan

GaurVitul · Accepted Answer

I used getword function and it worked.