我有以下数据:
RecommendationID TPID OwnerPersona RecommendationOwner
1936946 2494777 AE,AE DEHARRIS,AACORREL
2327768 16345463 AE,AE FLNG,CAZHIWEI
我希望修改它以获得以下结果,在分割逗号分隔的字符串RecommendationOwner
之后:
RecommendationID TPID OwnerPersona RecommendationOwner
1936946 2494777 AE,AE DEHARRIS
1936946 2494777 AE,AE AACORREL
2327768 16345463 AE,AE FLNG
2327768 16345463 AE,AE CAZHIWEI
注意 - 我只想分割 RecommendationOwner 列。