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 #402: Parsing Equipment Tags

Amy_smart
10 - Fireball

Here is my solution. 

Yoshiro_Fujimori
14 - Magnetar

My solution.

Spoiler
Workflow
Challenge_402_1.png
Formula Tool 1
Start = CharToInt(Substring([tag],4,1))
End = IF [Start] = 0 THEN 0 ELSE CharToInt(Right([tag], 1)) ENDIF

Formula Tool 2
New_Tag = Left([tag], 4) + CharFromInt([Start])

anggapramana
6 - Meteoroid

fun challenge,

 

i think i might overused the tool.

Spoiler
Screenshot 2023-11-30 143040.png
Begin_22
6 - Meteoroid

Thank you.

TurboToad
9 - Comet

My solution.

Spoiler
402.PNG
Pete_Rodgers
Alteryx
Alteryx

Great challenge

 

Spoiler
 

assumed that all tags of 5 characters or less was correct, and used generate rows, converting the suffix letter to unicode number

 
 

image.png

 

 

Joe-Smith-JLL
5 - Atom
Spoiler
Challenge_402.PNG
DaisukeTsuchiya
13 - Pulsar
Spoiler
スクリーンショット 2023-12-01 165605.png

Tofel
8 - Asteroid
Spoiler
Challenge 402.JPG