I am looking for an example of splitting an address into the different parts.
I have an address that consists a single line of address in the following format.
Theoretically it can contain a combination of the following.
Address Line1, Address Line2, Address Line3, Address Line4, Address PostCode
And I would like to transform this into the following columns
Address Line1 – data before the first “,” as long as it is not a numeric
Address Line2 – data between the first “,” and second “,” as long as it is not a numeric
Address Line3 – data between the second “,” and third “,” as long as it is not a numeric
Address Line4 – data after the third “,” as long as it is not a numeric
Address PostCode – the last 4 characters of the string that is a numeric
Any suggestions would be extremely helpful.