Hi All,
Problem statment is as described in the headline
Using postgresql
Example value in "Address"column
4 drive rd phoneix Arizona 34445
Needs to be extracted into differaent columns as Addressline,State,City,Zipcode
Biggest challenge is the space delimeter as all rows are not identical for ex
Row1:4 drive rd phoneix Arizona 34445
Row2 :Alm dr missouri 65034
Looking forward to hearing back
Thanks!