Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.


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

13. Cleaning Data: Impose order > The last name pattern is too complex for SUBS...

The last name pattern is too complex for SUBSTITUTE

The SUBSTITUTE function looks for a pattern in the form of a single text string to replace. The problem with the last names are that each has a different text string to replace.

image with no caption

And that’s not all: the pattern of messiness in the LastName field is more complex in that the messy strings show up in different positions within each cell and they have different lengths.

image with no caption

  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint