We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Weekly Challenge

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

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

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #348: Reorder a List of Names

EN6924
9 - Comet

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
15 - Aurora
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
7 - Meteor

My solution on Desktop:

Spoiler
NathalieHP_0-1670511710469.png

 

Has anyone managed to import the Cloud Designer start file?

Coakles
6 - Meteoroid

Pretty straightforward with Text to column.

Coakles_0-1670513868889.png

 

 

Prasanth_CS
5 - Atom

Spoiler

Spoiler
Al_challenge.PNG
MilindG
11 - Bolide
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.