This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
EDUC-6733-11/EDUC-6733J-11 I need it to look like this:
I also have some that need to end up like this:
Essentially, I need to remove the course section (the section is the number 11 after the second hyphen). I've tried a number of different formulas but I either end up removing the second course or end up with the section.
What i would do is use regex to get it done, as you have a combination of letters, a hyphen and then letters (ABCD-Y1122). You just need to tokenize your field and split to rows using this regex : (\w+-\w+).
Then use summarize tool to concatenate it using "/" separator. You must have a identifier field to group and concatenae. Incase you don't have then you can use recordid tool.