I decided to Change the “;” to spaces and then right trim the field
If your data is formatted inconstantly you may have to use this piecemeal approach, However, if the data is consistent you have another option
Let’s try a different approach