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].
