I want to split the below address from single column to multiple columns using talend from csv file to database table.
Input
|ADDRESS|
2660 9 SHERWOOD HEIGHTS DR W OAKVILLE ON L6J 7Y8
Expected Output
|STREET_NUMBER | UNIT_NUMBER |STREET_NAME|STREET_DIRECTIONS|STREET_TYPE|CITY|PROVINCE|POSTAL_CODE
|2660|9| SHERWOOD HEIGHTS|W |DR|OAKVILLE|ON| L6L 7Y8 | .
To be done in talend studio. I have about 60 different rows with different addresses. They all have same city and province but only some have the direction like W or S
New contributor
Sushant Schwann is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.