Challenge #211: Generating Email Addresses

[Ian_Johnson]

More Regex skills are needed to reduce the number of tools used

Spoiler

[JohanRanschaert]

Amazing 🙂

[JohanRanschaert]

Hi Kenda,

I understand what you in the Formula tool, but don't understand the syntax of the following line "REGEX_Replace([Users], ".*\s(.*?)\d+", "$1")"

Can you please explain this or tell me where I can teach myself about this syntx.

Many Thx,

Johan

[JohanRanschaert]

Hi Ollie,

Can you explain a little more in detail the syntax of this specific line in your Formula tool.

Thx a lot,

Johan

[inaraievskyi]

Is there any other tool except Inner join to compare expected output and achieved one?

[hbraunius]

My solution attached.

[Neetu]

Spoiler

[ALexAn]

Spoiler

[RobertW]

I learned how to change case with Regex!  Thanks

Regex

Spoiler

Match
([[:alpha:]]{1}).*\s([[:alpha:]]*)


Replace
\u$1$2@testemail.com

\u will uppercase next character, \U will uppercase whole match
https://www.boost.org/doc/libs/1_64_0/libs/regex/doc/html/boost_regex/format/boost_format_syntax.htm...

Spoiler

[papalow]

Nice