Challenge #332: The more ice cream, the better!

[jflanigan]

My answer for Q2 is different from the solution because I did not exclude the ingredient Coconut Cream.

Spoiler

[James_Driver9]

Spoiler

[simi22]

solved

[jpowellsd]

This is actually helpful for Dairy Free

Spoiler

[CarolynR]

I still need to figure out how to clean up the ice cream names, but in the end it didn't even matter.

Spoiler

 

[danettedavis]

team solution

[abner-sa]

My solution.

Spoiler

Q2: Filter using the following REGEX :
!(
REGEX_Match([Ice Cream Name], '^(.*[[:space:]])?cream([[:space:]].*)?$')
OR REGEX_Match([Ice Cream Name], '^(.*[[:space:]])?peanuts?([[:space:]].*)?$')
) AND
!(
REGEX_Match([Ingredients], '^(.*[[:space:]])?cream((,|[[:space:]]).*)?$')
OR REGEX_Match([Ingredients], '^(.*[[:space:]])?peanuts?((,|[[:space:]]).*)?$')
)

Q3: Order by rating asc, name desc

[NaiLo]

Spoiler

The clean up in the solution is probably a lot more elegant than what I got, but it works

[Jack_Li]

Spoiler

[putu_w_erata]

Spoiler