• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 14. Data Importing and Repairing > Cleaning Up Text Data Before Importi...

Cleaning Up Text Data Before Importing

Sometimes the data you want to import from a text file has a consistent quirk that is sure to cause problems. Most people work with fairly recent software versions, but in any organization you'll find isolated holdouts clinging to programs so antiquated that their software doesn't use standard delimiter characters (commas or tabs). Problems also occur with text files that contain extra return characters: The extra return produces a blank record, which can throw off the database import structure.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint