AnsweredAssumed Answered

Address Cleaning and Import

Question asked by JackRodges on Jan 31, 2017
Latest reply on Feb 6, 2017 by JackRodges

I am importing addresses from web pages by copying, pasting into word, cleaning up, copying and pasting into a global in a table. I then create one record for each line, define it as name, company, etc. This is needed due to the rampant non-standardi data on pages.

 

I then put those records into a global and paste it into a global field in my contacts table so that I can create records from the data.

 

The pasted result looks like:

<New Record>
<Person>Tori Oglesby
<Company>1st Quality Insurance Group - Bulk Mail Processing Center
<Street>250 East Park Ave
<City>Lake Wales
<State>FL
<Zip>33853
<Category>Insurance
<Note>BETTER PRICE . BETTER SERVICE . BETTER CHOICES Each insurance client doing business with 1st Quality Insurance Group, is provided a professional insurance consultant to assist with applicat... (more)

 

Then I loop through this global field and create contact records using the <xxx> to determine the field to set.

 

What I am wondering is if there is a standard for the <xxx> that is used for import and export. I recall seeing this idea a few decades ago. And if there is a standard are there sources of address lists using this standard. And what is it called?

Outcomes