Re: Massaging CSV Data

2016-01-09 Thread Christopher Stone
On Jan 08, 2016, at 20:16, Jaimie Lancaster wrote: > I recently received a list of contacts in a csv format. (About 1400 pages) > and I'm trying to get them into Filemaker pro. __ Hey Jaimie, Your data-sample is far too small t

Re: Massaging CSV Data

2016-01-09 Thread Greg Raven
IMHO, this looks like a job for Panorama, not Filemaker. The answer is going to depend on how consistent the data are. If you have ZIP+4 in every address block, you can do a grep search for that. If each address has a comma followed by a space followed by a two-letter state abbreviation followe

Massaging CSV Data

2016-01-08 Thread Jaimie Lancaster
Hello, I need some help from the group please. My Bbedit skill are limited when it comes to programming and data manipulation. I recently received a list of contacts in a csv format. (About 1400 pages) and I'm trying to get them into Filemaker pro. All is fine except the address part, rather t