Grouping By Not exact text

Hi, everyone!

This is my problem. I have some data from an API call. These data are grouped by a text field (let’s say “category”, and is text type because is from an API) in a repeating group. It works like I want but sometimes the category is capitalized and sometimes is not (e.g. Clothes <> clothes). So the grouping takes that like 2 different categories and for my purposes that is not correct.

So, has anyone figured out how to solve this kind of grouping?

P.S. I’m not sure if this is the right sub-topic for this problem, but I couldn’t find a better fit.

1 Like