Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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.