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>

Reply via email to