rename type: manual mapping: [{№ Summer},'Total Summer Games']
extractbetweendelimiters col: column3 start: '(' end: ')' includeEnd: true limit: 1 quote: ''
replacepatterns col: column1 with: '' on: ')'
rename type: manual mapping: [column1,'Country Code']
splitpatterns col: column3 type: on on: '('
rename type: manual mapping: [column1,'Participating Country']
rename type: manual mapping: [Gold,'Total Gold Medals Summer']
rename type: manual mapping: [Silver,'Total Silver Medals Summer']
rename type: manual mapping: [Bronze,'Total Bronze Medals Summer']
rename type: manual mapping: [Total,'Total Medals Combined Summer']
rename type: manual mapping: [{№ Winter},'Total Winter Games']
rename type: manual mapping: [Gold1,'Total Gold Medals Winter']
rename type: manual mapping: [Silver1,'Total Silver Medals Winter']
rename type: manual mapping: [Bronze1,'Total Bronze Medals Winter']
rename type: manual mapping: [Total1,'Total Medals Combined Winter']
rename type: manual mapping: [{№ Games},'Total Combined Games']
rename type: manual mapping: [Gold2,'Total Gold Medals Combined Games']
rename type: manual mapping: [Silver2,'Total Silver Medals Combined Games']
rename type: manual mapping: [Bronze2,'Total Bronze Medals Combined Games']
rename type: manual mapping: [{Combined total},'Total All Medals Combined Games']