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
[email protected] 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 [email protected]
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 [email protected]
To unsubscribe from this group, send email to
[email protected]
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 "[email protected]" rather than posting to the group.
Follow @bbedit on Twitter: <http://www.twitter.com/bbedit>
