Hi. I have data from a OUTLOOK export that's been corrupted. It appears that Outlook is putting extraneous data from the NOTES field into the TITLE field of the export, which ends up column shifting the resulting records that follow the first record.
Look at the sample data below: its column shifted the following: " Low Normal Web Page Down to the next line, and anything in the notes field gets stuffed into the Title field, where there should be nothing at all. How would I fix this with Grep ????? ========================== Columns ========================== Title First Name Middle Name Last Name Suffix Company Department Job Title Business Street "Business Street 2" "Business Street 3" Business City Business State Business Postal Code Business Country/Region Home Street "Home Street 2" "Home Street 3" Home City Home State Home Postal Code Home Country/Region Other Street "Other Street 2" "Other Street 3" Other City Other State Other Postal Code Other Country/ Region Assistant's Phone Business Fax Business Phone "Business Phone 2" Callback Car Phone Company Main Phone Home Fax Home Phone "Home Phone 2" ISDN Mobile Phone Other Fax Other Phone Pager Primary Phone Radio Phone TTY/TDD Phone Telex Account Anniversary Assistant's Name Billing Information Birthday Business Address PO Box Categories Children Directory Server E-mail Address E-mail Type E-mail Display Name E-mail 2 Address E-mail 2 Type E-mail 2 Display Name E-mail 3 Address E-mail 3 Type E-mail 3 Display Name Gender Government ID Number Hobby Home Address PO Box Initials Internet Free Busy Keywords Language Location Manager's Name Mileage Notes Office Location Organizational ID Number Other Address PO Box Priority Private Profession Referred By Sensitivity Spouse "User 1" "User 2" "User 3" "User 4" Web Page =========================== Sample Data =========================== Joan Fink The Dance Center 135 Lexington Avenue New York NY 10128 212)415 5555 - Amy K. -5555 JF 0/0/00 0/0/00 jf...@xxxxxxxxx.org SMTP Unspecified "Edward assistant 427-6119 562-0176" Low Normal http://www.xxxxxxxxx.org Maure Aron World Music/Crash Arts Executive Director 720 Lindist Avenue Los Angeles CA 90007 617/679.5555 617)876-5555 0/0/00 0/0/00 ma...@xxxxxxxxx.org SMTP Unspecified "Jeff Masone Jack Hirsch, came from ICAA, since Oct 08 " Low Normal http://www.xxxxxxxxxxx.org -- You received this message because you are subscribed to the "BBEdit Talk" discussion group on Google Groups. To post to this group, send email to bbedit@googlegroups.com To unsubscribe from this group, send email to bbedit+unsubscr...@googlegroups.com For more options, visit this group at <http://groups.google.com/group/bbedit?hl=en> If you have a feature request or would like to report a problem, please email "supp...@barebones.com" rather than posting to the group. Follow @bbedit on Twitter: <http://www.twitter.com/bbedit>