Split a value into multiple rows
Hi
I have full addresses split by ; that I want to split out into new rows ready for the Address Validate step.
An example of the data layout ...
"Address1 Address2 Address3 Town County Postcode;Address1 Address2 Address3 Town County Postcode"
This should become two rows
"Address1 Address2 Address3 Town County Postcode"
"Address1 Address2 Address3 Town County Postcode"
Does anyone know if this is achievable in Aperture?
Thanks
Luke
0
Answers
Hi Luke
Roughly how many addresses are there in that semi-colon separated list?
Two ideas:
Hoping someone will reply with a better suggestion!