RickPutnam
5 years agoQrew Cadet
How to convert a set of Text fields to an Address field
Greetings,
I have a linked table that pulls in CSV data from another system. Included in the data set are 5 text fields that define an address: Address1, Address2, City, State, and PostalCode. I'm wondering how I could go about converting those into a field of type Address either in the linked table or in another table.
I'm dreaming of a Formula-Address field which would support concatenating the 5 fields referenced above -- but alas no such formula field exists. Is there another way?
Thanks in advance.
------------------------------
Rick Putnam
------------------------------
I have a linked table that pulls in CSV data from another system. Included in the data set are 5 text fields that define an address: Address1, Address2, City, State, and PostalCode. I'm wondering how I could go about converting those into a field of type Address either in the linked table or in another table.
I'm dreaming of a Formula-Address field which would support concatenating the 5 fields referenced above -- but alas no such formula field exists. Is there another way?
Thanks in advance.
------------------------------
Rick Putnam
------------------------------