I have a text field which can have data in two formats:
1) 999-11111-aa111-aaa00 OR
2) 999-1111-aa-111-aaa00
In either case, the data needs to be parsed into four separate fields and all four fields are single-select drop downs.
aa111 and aa-111 should be parsed into the same (third field)
Does anybody have scriptrunner code to parse between the dashes and take into account when field three data includes a dash?
