Extend Text and Remove Text After Comma

[AngelBenitez]

Hello,

I am trying to create one rule that does the following two things:

• I would like the rule to remove everything after the comma and the comma itself
• VP to change to Vice President & AVP to Assistant Vice President

Example Text:

VP, Creative Manager

AVP, Digital Media Specialist

Output

Vice President

Assistant Vice President

[Dan Korn]

var s = "AVP, Digital Media Specialist";
return s.split(',')[0].replace(/(A?)(VP)/, function(m, A, VP) { return (A ? "Assistant " : "") + "Vice President"; } )

Or:

var s = "AVP, Digital Media Specialist";
var result = s.split(',')[0];
var parts = result.match(/(A?)(VP)/);
if (parts)
    result = (parts[1] ? "Assistant " : "") + "Vice President";

return result;

 

[AngelBenitez]

Hello @Dan Korn; thank you for your help. If the value is being pulled from an Excel sheet, what would be the rule to remove the variable in the Excel sheet?

[AngelBenitez]

Hello @Dan Korn, thank you so much for your help. I really appreciate it.