Hi,
I need to clean the information from a column to result the string after the second > from the right. Examples below.
Data: Promotion > Promotion > Promotion > Performance
Result: Promotion > Performance
Data: Transfer > Transfer > Transfer > Career progression
Result: Transfer > Career progression
Data: Request compensation change > Compensation change > Market Adjustment
Result: Compensation change > Market adjustment
Hope you can help me.
Thanks a lot!
I need to clean the information from a column to result the string after the second > from the right. Examples below.
Data: Promotion > Promotion > Promotion > Performance
Result: Promotion > Performance
Data: Transfer > Transfer > Transfer > Career progression
Result: Transfer > Career progression
Data: Request compensation change > Compensation change > Market Adjustment
Result: Compensation change > Market adjustment
Hope you can help me.
Thanks a lot!