I am try to parse out the data and the phrase "Written Assessment" out of another column but cannot come up with the code string.
sites/GPSR/2023 Written Assessments/EU Directives
Apologies for the delay in responding. There are several different ways you could approach this, and the best approach will depend on what your data is like over the entire set of records. If all the occurrences look like:
sites/GPSR/<FOUR DIGIT YEAR> Written Assessments/EU Directives
Then the simplest approach is probably to use the function
Edit column -> Add column based on this column
and then the GREL
value.split("/")[2]
This will break up the original string on each forward slash, and then pick the 3 item from the resulting array (list of values). The [2] picks the 3rd value because it starts counting at zero for the first item in the array
If the data isn't as consistent as this please do share more information and examples and I can provide some alternative approaches
Owen