I have a data set as follows
34782 - Wireless
38657 - Wireless
I need to remove the last 5 characters only for those items that END with (underscore and four numbers) (leaving those items that do not match the previously mentioned criteria untouched)
I tried with a String Manipulation as follows:
substr($RIMINSTANCE_NAME$, 0, (length($RIMINSTANCE_NAME$)-5))
What this does is to remove the last 5 characters regardless of what those characters are.
Any suggestions of what the syntaxis must be for this “string manipulation” node to work properly?
Maybe this can be done as well with a “Rule Engine”.