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:
|<Company>||1st Quality Insurance Group - Bulk Mail Processing Center|
|<Street>||250 East Park Ave|
|<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?