reviews-table.wrangle

split col: column2 on: '\\n'
split col: column1 on: ':'
drop col: column2
rename col: column8 to: 'dealer'
set col: dealer value: proper(dealer)
delete row: isnull(dealer)
split col: column7 on: '-'
split col: column1 on: ':'
drop col: column7
rename col: column8 to: 'region'
rename col: column2 to: 'city'
split col: column3 on: ':' limit: 2
replace col: city with: '' on: '\'' global: true
drop col: column1
split col: column2 on: '\\n'
drop col: column3
rename col: column1 to: 'id'
replace col: id with: '' on: '#' global: true
settype col: id type: 'String'
split col: column7 on: '\\n'
rename col: column1 to: 'submitter'
split col: column2 on: ':'
set col: submitter value: proper(submitter)
drop col: column1
split col: column3 at: 6,7
rename col: column1 to: 'sent_time'
rename col: column2 to: 'sent_date'
merge col: column4,column5,column6 as: 'column1'
drop col: column4,column5,column6
split col: column1 on: '\\n'
drop col: column2
replace col: sent_date with: '' on: '\'' global: true
settype col: sent_time type: 'Datetime','hh:mm:ss','HH:MM'
settype col: sent_date type: 'Datetime','dd-mm-yy','dd*mm*yy'
split col: column3 on: 'תקשורת:'
rename col: column1 to: 'review'
replace col: review with: '' on: '\\n' global: true
extract col: column2 on: /([0-5])/ limit: 4 before: '\/'
rename col: column1 to: 'communication'
rename col: column3 to: 'quality'
rename col: column4 to: 'price'
rename col: column5 to: 'wait'
drop col: column2
settype col: communication type: 'Integer'
settype col: quality type: 'Integer'
settype col: price type: 'Integer'
settype col: wait type: 'Integer'
delete row: isnull(dealer)
delete row: len(dealer) <= 1
delete row: isnull(region)
delete row: isnull(city)
delete row: isnull(sent_date)
delete row: isnull(sent_time)
delete row: isnull(price)
delete row: isnull(quality)
delete row: isnull(communication)
delete row: isnull(wait)
delete row: isnull(review)
delete row: len(review) < 10
delete row: len(city) < 3
replace col: review with: '' on: '\' \''