I have data something like the below
I need to display only the last four numbers that are before '-'.
Answer will be something like below.
Please find the attachment.
Solved! Go to Solution.
something like this will handle your extra requirement.
Check for the 5th char from the right if its a "-" display the 4 chars at the end of your string. I think this covers all your use cases.