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

Answers

Sign In or Register to comment.