You have asked several regex data transformation questions on the forum. Give us all some “tanxs” by putting in the effort to learn why @astrosofista 's technique worked on your data, so that in the future you can maybe solve this type of problem (a fairly simple one) without coming here for help.
Some nice resources are found HERE.