I have two string fields that each has a list of states separated with semi-colons that I would like to combine into one field but without duplicating any of the states. For instance, the data coming into the reformat would looke like this:
RecordID LicensedStates LocationStates
100 PA;AZ;CA PA;AZ;AL
101 PA PA
102 AZ;CA CT
The result I would like to get out of the reformat would be:
I've tried to find ways of doing this but after looking through the documentation for Normalizer, Denormalizer, and a few Java lines of code and just have no idea what i'm doing.
Any advice you have would be appreciated.
Please sign in to leave a comment.