Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEALast one was tricky!
These links helped:
https://help.alteryx.com/20212/designer/regex-tool
https://www.boost.org/doc/libs/1_76_0/libs/regex/doc/html/boost_regex/syntax/perl_syntax.html
My solution.
Not sure if anyone will see this here, but I had a question about using wildcards in a formula tool.
For the second output I used a formula Trim([Trimmed],": Report"), and while this works to achieve the correct output, I was trying to figure out a way to trim any text where there was a colon and any characters after.
Is there a way to achieve this using a Wildcard in the formula? Any help is appreciated, thanks!