# 159|ALTERYX – Parsing Patterns with Regex **URL:** \ **Category:** Challenges\ **Tags:** alteryx, regex, intro, parse\ **Created:** [March 12, 2024, 2:07am UTC](https://www.techhub.training/t/159-alteryx-parsing-patterns-with-regex/2253 "2024-03-12T02:07:42Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Sterling\_Lane](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/sterling_lane/32/399_2.png) [@Sterling\_Lane](https://www.techhub.training/u/Sterling_Lane)\ **Post date:** [March 12, 2024, 2:07am UTC](https://www.techhub.training/t/159-alteryx-parsing-patterns-with-regex/2253/1 "2024-03-12T02:07:42Z")
_BYU Student Author_: @Sterling_Lane _Reviewers_: @Marta_Ellsworth, @Andrew_Wilson _Estimated Time to Solve:_ 40 Minutes This is an intro challenge that is part of the [Alteryx Learning Path](https://www.techhub.training/t/alteryx-learning-path/2214). We provide the solution to this challenge using: - Alteryx Need a program? Click [here](https://www.techhub.training/t/information-about-software-used-on-techhub-training/138). **Overview** Welcome to your data analyst internship at Simple Screenprinting! At Simple Screenprinting, we prioritize having comprehensive and accurate data to uncover insights that keep us ahead in the screenprinting market. Your task is to support our marketing team in achieving its strategic goals. Jenny, our Director of Marketing, is concerned about Simple Screenprinting’s branding efforts and seeks assistance in optimizing her team’s spending. She has granted you access to the company’s order data and authorized the use of Alteryx to address her inquiries, recognizing the potential of Alteryx’s parsing tools to help in your analysis. Your objective is to create an Alteryx workflow that addresses all her questions, enabling you to discuss the findings with Jenny. **Instructions** 1. One of our partners, Harmons Grocery, has undergone a branding update, transitioning to the new name of Harmony Grocery. To uphold our commitment to precision and brand integrity, it’s imperative that we reflect this change across all touchpoints, including our orders database. In our system, job entries for Harmons Grocery are denoted as “HARMONS #xx,” with xx indicating the store location. Help us ensure our branding alignment by updating the Job Names for each Harmons location. 2. We are starting to sell a lot more prints on items that come in multiple sizes. We want to expand our consumer base outside of Utah to increase our brand presence. Our Item SKU numbers have the following format, which should help you in locating these for us: 3. We want to further expand our consumer base to focus more on college age kids in Utah who enjoy BYU football, since we feel that segment of the market has untapped potential. As such, we want to do A/B testing on BYU students to see which prints are more impactful to this demographic. Provide me a report showing BYU gear we have screen-printed in the past which was sold during the football season (September – December) so we can get an idea of what we have done in the past. **Data Files** - [Challenge159\_Data.yxzp](https://byu.box.com/shared/static/r2b7sp62z3i4n27ne6iuemyzd3auseyp) > **Suggestions and Hints** > > - Alteryx has built in examples of each use of the Regex Tool. Click on the Regex tool in the tool palette and click Open Example to view examples of how each Regex output method works. > - For the Replace output method, don’t forget about how Alteryx handles Regex grouping. When defining a pattern, you can group characters in parentheses () and call those groups in the Replacement Text as follows: $1 (group 1) $2 (group 2). > - If a column contained a word followed by a number and I wanted to return the word, followed by a comma and a space, and then the number, I would format my Replacement Text as $1,\s$2. See the image below for a visual representation of this. > ![Challenge159_Image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/7/7b7e5284b464f83f4a37dd0a8d6f4ce8994548a0.png) > - For the Match output method, remember that the tool is looking for cells which match the entire pattern, not just a portion of the pattern. > - For the Parse output method, remember to use the same grouping strategy as the replace tool. Each ‘group’ represents a new column of data that will be generated. > - When specifying the format in the DateTime parse tool, you will need to use a custom format to just get the month number. Looking at the suggestions given in the DateTime tool may help you see what custom format will give you the month number. > - Keep in mind the month number will be output as a string by default. This may be important for your filter on the months. **Solution** > **Solution Image** > > ![Challenge159_Solution_Image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/3/36e2aa2c70f3fa5fd38482bee2d654e6ef2cf9a4.png) [Challenge159\_Solution.yxmd](https://byu.box.com/shared/static/655jtmd57ukm04ibkwkt6eqtclyqnhqc) _Solution Video:_ [Challenge 159|ALTERYX – Parsing Patterns with Regex](https://youtu.be/F0C5_YQZ6fs) ---
**Author:** ![Andrew\_Wilson](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/andrew_wilson/32/5487_2.png) [@Andrew\_Wilson](https://www.techhub.training/u/Andrew_Wilson)\ **Post date:** [March 12, 2024, 8:49pm UTC](https://www.techhub.training/t/159-alteryx-parsing-patterns-with-regex/2253/2 "2024-03-12T20:49:55Z")
Great beginner challenge. I was reminded of the usefulness of RegEx and the syntax of that in Alteryx. After reviewing your solution, it looks like I took a little bit longer route and made my RegEx a little more explicit. Overall a great challenge! ![image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/e/e4829ce3921ea4d8d474114d4e8d65d3f0b3f6bf.png) ---
**Author:** ![Marta\_Ellsworth](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/marta_ellsworth/32/5512_2.png) [@Marta\_Ellsworth](https://www.techhub.training/u/Marta_Ellsworth)\ **Post date:** [March 25, 2024, 8:38pm UTC](https://www.techhub.training/t/159-alteryx-parsing-patterns-with-regex/2253/3 "2024-03-25T20:38:27Z")
This was a good challege to help me practice my RegEx. I learned some new things I could do with it that I hadn’t before. ![image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/1/1703501ff2d30d5a9df862743f6d1c4dd2b0c2a9.png) ---
**Author:** ![Coleman\_Halls](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/coleman_halls/32/7025_2.png) [@Coleman\_Halls](https://www.techhub.training/u/Coleman_Halls)\ **Post date:** [March 29, 2025, 1:05am UTC](https://www.techhub.training/t/159-alteryx-parsing-patterns-with-regex/2253/4 "2025-03-29T01:05:50Z")
![image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/a/a8bdb2741accd8324419e7c2d538a672b2685e03.jpeg) ---
**Author:** ![Samantha\_Cassell](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/samantha_cassell/32/7448_2.png) [@Samantha\_Cassell](https://www.techhub.training/u/Samantha_Cassell)\ **Post date:** [March 30, 2025, 4:13pm UTC](https://www.techhub.training/t/159-alteryx-parsing-patterns-with-regex/2253/5 "2025-03-30T16:13:23Z")
Time to complete: 20 minutes ![regex problem](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/7/7444f4c53da00f4761ff767ec6cd4eac236e538b.png) ---
**Author:** ![Meilan\_Rhoton](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/meilan_rhoton/32/7386_2.png) [@Meilan\_Rhoton](https://www.techhub.training/u/Meilan_Rhoton)\ **Post date:** [March 31, 2025, 2:30pm UTC](https://www.techhub.training/t/159-alteryx-parsing-patterns-with-regex/2253/6 "2025-03-31T14:30:00Z")
Time to complete: 30 minutes ![Screenshot 2025-03-31 082805](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/0/0b4a02bcc4923795aad0da6de61071f54963afe5.png) ---
**Author:** ![Leah\_Robertson](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/leah_robertson/32/7637_2.png) [@Leah\_Robertson](https://www.techhub.training/u/Leah_Robertson)\ **Post date:** [March 31, 2025, 4:59pm UTC](https://www.techhub.training/t/159-alteryx-parsing-patterns-with-regex/2253/7 "2025-03-31T16:59:21Z")
Time to complete: 25 minutes ![image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/9/9f8d1a8f22e764aeabd8383b18d6d74883a24b1c.png) ---
**Author:** ![Clara\_Fletcher](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/clara_fletcher/32/7283_2.png) [@Clara\_Fletcher](https://www.techhub.training/u/Clara_Fletcher)\ **Post date:** [March 31, 2025, 8:51pm UTC](https://www.techhub.training/t/159-alteryx-parsing-patterns-with-regex/2253/8 "2025-03-31T20:51:04Z")
Time to Complete: 30 min ![Screenshot 2025-03-31 145047](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/a/ad4a4daec93f26f13dee3901e9cd88a4e99f7991.png) ---
**Author:** ![Rachel\_Lopez](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/rachel_lopez/32/7388_2.png) [@Rachel\_Lopez](https://www.techhub.training/u/Rachel_Lopez)\ **Post date:** [April 1, 2025, 1:49am UTC](https://www.techhub.training/t/159-alteryx-parsing-patterns-with-regex/2253/9 "2025-04-01T01:49:58Z")
time: 30 minutes level: beginner ![Screenshot 2025-03-31 at 7.49.50 PM](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/d/d2be28dca786f27fa674795799b9fec55b320712.png) ---
**Author:** ![Cannon\_Harmer](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/cannon_harmer/32/7458_2.png) [@Cannon\_Harmer](https://www.techhub.training/u/Cannon_Harmer)\ **Post date:** [April 1, 2025, 2:43am UTC](https://www.techhub.training/t/159-alteryx-parsing-patterns-with-regex/2253/10 "2025-04-01T02:43:30Z")
![image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/1/1a1016694884e156d2c2d23ac9f820430f413947.png) ---
**Author:** ![Addison\_Kingston](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/addison_kingston/32/7559_2.png) [@Addison\_Kingston](https://www.techhub.training/u/Addison_Kingston)\ **Post date:** [April 1, 2025, 2:59am UTC](https://www.techhub.training/t/159-alteryx-parsing-patterns-with-regex/2253/11 "2025-04-01T02:59:59Z")
Time to complete: 25 minutes Difficulty: intermediate ![image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/3/3c5a8e6202d320557956f23087bcb4f9c6eeeed1.png) ---
**Author:** ![Cash\_Clark](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/cash_clark/32/7558_2.png) [@Cash\_Clark](https://www.techhub.training/u/Cash_Clark)\ **Post date:** [April 1, 2025, 3:27am UTC](https://www.techhub.training/t/159-alteryx-parsing-patterns-with-regex/2253/12 "2025-04-01T03:27:16Z")
Great challenge! ![image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/2/291a708e30d1d782c7ed4012bb5e4a2163de9b26.png) ---
**Author:** ![Kendall\_Curtis1](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/kendall_curtis1/32/7682_2.png) [@Kendall\_Curtis1](https://www.techhub.training/u/Kendall_Curtis1)\ **Post date:** [April 1, 2025, 4:04am UTC](https://www.techhub.training/t/159-alteryx-parsing-patterns-with-regex/2253/13 "2025-04-01T04:04:26Z")
Difficulty: Beginner Time to Complete: 30 mins ![Alteryx 159 screenshot 215748](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/c/ced57e124b1e5bc8c43f01c20733bf9f837c9492.png) ---
**Author:** ![Caleb\_Spiers](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/caleb_spiers/32/7605_2.png) [@Caleb\_Spiers](https://www.techhub.training/u/Caleb_Spiers)\ **Post date:** [April 1, 2025, 4:12am UTC](https://www.techhub.training/t/159-alteryx-parsing-patterns-with-regex/2253/14 "2025-04-01T04:12:08Z")
![image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/f/ff978c8c5503f83fb1f5351f4a5118d95311c331.png) ---
**Author:** ![Johnathan\_Mulvey](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/johnathan_mulvey/32/7241_2.png) [@Johnathan\_Mulvey](https://www.techhub.training/u/Johnathan_Mulvey)\ **Post date:** [April 1, 2025, 5:12am UTC](https://www.techhub.training/t/159-alteryx-parsing-patterns-with-regex/2253/15 "2025-04-01T05:12:12Z")
Time to Complete: 45 Rating: Intermediate Made me really have to breakdown the questions and understand the data. ![challenge 159 regex in alteryx](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/a/a5186aa820a4142ab98c1bca4caf97b9393bd6b1.png) ---
**Author:** ![McKenna\_Hall](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/mckenna_hall/32/7378_2.png) [@McKenna\_Hall](https://www.techhub.training/u/McKenna_Hall)\ **Post date:** [April 1, 2025, 7:09am UTC](https://www.techhub.training/t/159-alteryx-parsing-patterns-with-regex/2253/16 "2025-04-01T07:09:48Z")
Time to complete: 25 minutes Rating: Beginner ![image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/b/bdead3ecf183bf2a6b4b69338262018d4e428d67.png) ---
**Author:** ![Landon\_Wells](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/landon_wells/32/7537_2.png) [@Landon\_Wells](https://www.techhub.training/u/Landon_Wells)\ **Post date:** [April 1, 2025, 1:04pm UTC](https://www.techhub.training/t/159-alteryx-parsing-patterns-with-regex/2253/17 "2025-04-01T13:04:00Z")
30 minutes Intermediate ![Alteryx](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/1/1f88dc04041ef7601e2904ee1ae8dc517b65faec.png) ---
**Author:** ![Sam\_Jezik](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/sam_jezik/32/7583_2.png) [@Sam\_Jezik](https://www.techhub.training/u/Sam_Jezik)\ **Post date:** [April 1, 2025, 4:14pm UTC](https://www.techhub.training/t/159-alteryx-parsing-patterns-with-regex/2253/18 "2025-04-01T16:14:09Z")
Time: 30 minutes Difficulty: Easy Good regex practice and exposure to the DateTime tool! ![Screenshot 2025-04-01 101325](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/c/caef126a6f3a1c415ac52d1794b83234f85ed386.png) ---
**Author:** ![Austin\_Smith](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/austin_smith/32/7406_2.png) [@Austin\_Smith](https://www.techhub.training/u/Austin_Smith)\ **Post date:** [April 1, 2025, 5:12pm UTC](https://www.techhub.training/t/159-alteryx-parsing-patterns-with-regex/2253/19 "2025-04-01T17:12:20Z")
![Screenshot 2025-03-31 145047](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/a/ad4a4daec93f26f13dee3901e9cd88a4e99f7991.png) ---
**Author:** ![Adeline\_Christensen](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/adeline_christensen/32/7431_2.png) [@Adeline\_Christensen](https://www.techhub.training/u/Adeline_Christensen)\ **Post date:** [April 1, 2025, 11:49pm UTC](https://www.techhub.training/t/159-alteryx-parsing-patterns-with-regex/2253/20 "2025-04-01T23:49:25Z")
Time to complete: 30 minutes Difficulty: Intermediate ![image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/e/eb99a574ded378554945587cf8b5d60abf991de5.png) [Next page](https://www.techhub.training/t/159-alteryx-parsing-patterns-with-regex/2253.md?page=2)