Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2017
    Posts
    1

    Unanswered: data extracting characters from words - Microsoft Access or Excrl

    Click image for larger version. 

Name:	Company Type example.PNG 
Views:	3 
Size:	3.9 KB 
ID:	17262

    I have data in a column called "company" it lists 3000 companies along with the company type - whether it is LLC, LP, Corp, etc. The format is like this: Microsoft_LLC_LLC. I want to remove the LLC portion and put it in another column called lets say company type. The problem is that the format is not consistent sometimes there is an extra space or underscore - Any ideas on to how to remove company type from company field? Much appreciated. An Image of example of data set is posted.

  2. #2
    weejas is offline Grumpy old man (training)
    Join Date
    Sep 2006
    Location
    Surrey, UK
    Posts
    1,101
    Provided Answers: 17
    Write a query that replaces underscores with spaces, and then from this query extract everything that appears after the last space.
    10% of magic is knowing something that no-one else does. The rest is misdirection.
    Beers earned: 2

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •