2015-05-26 01:20 PM - edited 2015-05-26 01:21 PM
I need to be able to replace a user input with just part of the users input.
In this case it's aggregate selection. Somewhere in every aggr name is either a1,a2,a3,or a4. Unfortunatly its not always in the same place.
I was hopeing for something like;
if( inputStr = [a1])
that way Aggr1_a1_oracle_prod and filer2_15k_esx_fcp_a1 would each let me replace them with a1. This doesn't work, and programing isn't my strong suite. I have to do something similar for several diparent examples so if a regex match could be shown it would really help me out. There are at least a hundread aggregates and I dont' want to have to do if/else for all of them.
Solved! SEE THE SOLUTION
2015-05-26 07:16 PM - edited 2015-05-26 10:54 PM
You can define a function as below and use it in your workflow. Its also ignore case senstivity for A1 and a1 in the aggr names. If you don't want that then remove toLowerCase() from the below and it should be fine.
if( str.toLowerCase().contains("a1") ) return "a1";
else if ( str.toLowerCase().contains("a2") ) return "a2";
else if ( str.toLowerCase().contains("a3") ) return "a3";
else if ( str.toLowerCase().contains("a4") ) return "a4";
else return str;