Challenge #181: Ingredients of an Old Southern

[hbraunius]

My solution attached.

[kelsey_kincaid]

Spoiler

[viveknshah]

Spoiler

Ended up using CrossTab because I like my drink shaken not stirred. 

[LordNeilLord]

My solution

Spoiler

[JORGE4900]

Hello @T_Willins 

That must have been a pretty good class on web scrapping; the only thing that I don't undersand much is the use of two REGEX operators on the Ingredients group (.*?)

The asterisk operator should match the preceeding character zero or more times, and the ? operator should match it zero or one time. I am a little confused on the purpose of the ? operator following the asterisk. It seems that with or without it pulls the same results. Is there any strategy behind it?

https://www.boost.org/doc/libs/1_64_0/libs/regex/doc/html/boost_regex/syntax/basic_extended.html

[T_Willins]

Hi @JORGE4900.  I used the (.*?) as habit as I have had too many times when my wildcard .* returned to long of a string.  In this specific data set it is not needed and (.*) would return the same results.  Adding the ? makes the operator non-greedy.  There is a great page on Perl Syntax at:

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/RegEx-Perl-Syntax-Guide/ta-p/1288

If you get a chance to take the webscraping (or any other pre-conference classes) at #Inspire I would strongly recommend them. 

[LukeG]

Spoiler

Niceeeeee

[JORGE4900]

Hi @NicoleJohnson 

I really enjoyed looking at your application. Very nice job, and I have to say Frozen Strawberry Daiquiris sound pretty good for a sunny day.

[paulckennedy]

My first challenge. Not a bad way to learn about how to work in the designer.

[garthn555]

Spoiler