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 followed by a space, you can do a grep search for that, too. Then, if there are no other commas in "fields," you can search for commas followed by quotes.
On Friday, January 8, 2016 at 7:11:21 PM UTC-8, Jaimie Lancaster wrote: > > 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 than being Address, City, > State, Zip is all one block of information. It all imports into just one > field. > > Here is a sample record from the csv data: > > 253,Joe's Pool Hall FWB ,"999 Veterans Memorial Dr > Anytown, AL 39044-1550 > ",06/19/2008,01/01/1991,001107,$ 84.45,$ 84.45, > > > Here's the header row: Account Number,Recognition Name,Address Block,Date > of Donation,First Gift Date,Designation Short Display Name,Amt,Total Adj > Amt,Comment > > I did figure out that in the Address block I needed to change and add > Address, City, State, Zip. > > I thought if I just stripped out the " " marks that it would take care of > it but I need a comma before the City. > > Any help or a point in the direction to research more would be appreciated. > > Thanks, > -- This is the BBEdit Talk public discussion group. If you have a feature request or would like to report a problem, please email "[email protected]" rather than posting to the group. Follow @bbedit on Twitter: <http://www.twitter.com/bbedit> --- You received this message because you are subscribed to the Google Groups "BBEdit Talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected].
