Apptio for All

Apptio for All

A place for Apptio product users to learn, connect, share and grow together.

 View Only
Back to Library

Mapptio Puzzle #4 

Fri November 01, 2019 03:11 PM

 

 

 

To conquer the third location, help @Adam Moretz�, @Andrew Mulvaney and @Michael Darragh� find the simplest way to achieve the desired outcome.

 

 

I have a list of servers where I need to trim off the “-RX”, and keep only the characters before. 

 

 

Some servers in the list don’t have “ –RX”, thus those Server ID's should remain the same.

 

*note, the "X" after "–R" is a wildcard

 

 

Example:

 

 

DRTC18100-R11

DRTC18100

DRNZAL54545-SIO11

no change

DIAR8100RRR11

no change

 

 

What is the simplest way to achieve the desired outcome?

 

 

This location closed November 29, 2019

 

 

 

 

 

 

 

Server ID file is attached


#ApptioforAll

Statistics
0 Favorited
1 Views
1 Files
0 Shares
0 Downloads
Attachment(s)
xlsx file
Mapptio Server ID.xlsx   9 KB   1 version
Uploaded - Tue October 29, 2024
 
Download

Comments

Adam Moretz
Wed December 04, 2019 01:54 PM

Thanks everyone for your participation!  There were a few ways to solve this, but the answer that we've provided was what we determined to be the simplest way to derive our answer. 

 

Points were awarded to those who used a different formula but brought back the correct values.

 

ANSWER:

=If(Server ID CONTAINS "-R",Split(Server ID,1,"-"),Server ID)

 

 

Correct Respondents:

@James Caldwell
@Gregory Nutt

@Dheeraj Kala

@Tony Wong
@Kyle Castro

@Megan Smith
@Will Simpson

@Michelle McGuire
@Paride Zecca

@Samir Banker
@Raymond Walls

@Mark Salib
@Douglas Mahan


#ApptioforAll

Lauren Pagan
Mon November 25, 2019 10:38 AM

Hey @Will Simpson, after Nov 29 the submitted answers will be evaluated and those who answered correctly will be tagged in a comment along with the correct answer.


#ApptioforAll

Will Simpson
Mon November 25, 2019 10:05 AM

What happens with the answers after the 29th? are they evaluated and fed back?


#ApptioforAll

Apptio Community Member
Wed November 20, 2019 02:26 PM

@Adam Moretz� @Michael Darragh� @Andrew Mulvaney  Love these puzzles!!!!  


#ApptioforAll

Will Simpson
Wed November 13, 2019 05:03 AM

Only just found this little game, shame to have missed the previous ones. Lets see how this goes. :-)


#ApptioforAll

Kyle Castro
Tue November 05, 2019 06:34 PM

Oooh I like this one.


#ApptioforAll