splitrows col: column1 on: '\n' quote: '\"'
split col: column1 on: ',' limit: 9 quote: '\"'
replace col: * with: '' on: '\"' global: true
header
delete row: ismissing([Index])
set col: First_Name value: proper(First_Name)
split col: Date_Of_Birth on: '.' limit: 2
set col: Date_Of_Birth3 value: if(len(Date_Of_Birth3) < 4, Date_Of_Birth3 + 1900, Date_Of_Birth3)
merge col: Date_Of_Birth1,Date_Of_Birth2,Date_Of_Birth3 with: '.' as: 'Deate_Of_Birth'
drop col: Date_Of_Birth3
drop col: Date_Of_Birth2
drop col: Date_Of_Birth1
replace col: Small_Shirt_Size with: 'S' on: 'X'
replace col: Medium_Shirt_Size with: 'M' on: 'X'
replace col: Large_Shirt_Size with: 'L' on: 'X'
merge col: Small_Shirt_Size,Medium_Shirt_Size,Large_Shirt_Size as: 'column1'
drop col: Small_Shirt_Size
drop col: Medium_Shirt_Size
drop col: Large_Shirt_Size
rename col: column1 to: 'Shirt_Size'