Search

Close

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語

IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Nice and easy. I used Regex:

REGEX_Replace([Item Number], ".*?(A\d{4}).?", "$1")

Community Challenge 443 Solution.png

Community Challenge 443 Solution.png

IMO the ideal and elegant solution is ToddW - RegEx solution:
https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Elegantly-remove-all-ASCII-cha...

Send ToddW some extra cool points to for the elegant solution! Thanks Todd!

ToddW - RegEx solution: [^x20-x7e]+

My solution. Mildly frustrating figuring what was wrong and then realising the solution was super simple.

Had to use the hints, but I'm still learning.

Solution attached.

Screenshot 2025-01-01 220235.png

I went with a sort and "join multiple" tool... I'm not sure if it's scalable, but I do think it is if the only issue is nonprintables. For this dataset it worked, anyway!

Alteryx Challenge 443.png

Solution attached

Challenge 443 Workflow Pic.png

Regex - 2 ways