Display data only before the last hyphen in a list of values in an otbi report
There is a column with department name. Department name consists of a name followed by a hyphen, followed by the dept number. In some cases the department name has a hyphen in it as well. So at max, 2 hyphens in a value. I need to create two separate columns, department name and department number.