Hi there @braunnz,
String Manipulation node can’t do it as it doesn’t have multiple if logic (not sure there is other way like regex for example) and Rule Engine can’t do it as it doesn’t have join (and substr in a result) logic. But Column Expressions got both!
Check this topic for more info on Column Expressions or search forum for any other as there are plenty of them.
Try it out and if you have any problems feel free to ask 
Br,
Ivan