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

Challenge #348: Reorder a List of Names

EN6924
10 - Fireball

My Solution -

 

EN6924_0-1670500744274.png

 

priyasmilysri
5 - Atom
Spoiler

priyasmilysri_0-1670500680190.png

 

DenisZ
11 - Bolide

Here is my solution

 

 

 

Spoiler
DenisZ_1-1670501411346.png

 

 

 

Felipe_Ribeir0
16 - Nebula
Spoiler
My solution, i am using the formula tool to check if we have a comma, and if we have, using findstring and substring formula to rebuild the name:

Felipe_Ribeir0_0-1670504883991.png

 

JBarr
8 - Asteroid

Done.

NathalieHP
8 - Asteroid

My solution on Desktop:

Spoiler
NathalieHP_0-1670511710469.png

 

Has anyone managed to import the Cloud Designer start file?

Coakles
7 - Meteor

Pretty straightforward with Text to column.

Coakles_0-1670513868889.png

 

 

Prasanth_CS
5 - Atom

Spoiler

Spoiler
Al_challenge.PNG
MilindG
12 - Quasar
Spoiler
MilindG_0-1670517702900.png

 

Jasond2022
6 - Meteoroid

For us newbies, can you explain what your RegEx did exactly? I don't have much experience with it, so to see this done so simply is very impressive.