I have parts in the following format:
|ABVD-JtU5d-NR393. Where the prefix, base and suffix can be any length., but there are always two dashes.|
I need to add a column to show the prefix, base, and first letter only of suffix.
So for the above part, i want to extract