Split one table cell into multiple cells.

  • Thread starter Thread starter Zaid
  • Start date Start date
Z

Zaid

At the company I work, we have a part number that is 10 characters long. The
first 3 are the product type, the middle 4 are the product logo, and the last
3 are the product color. The table I have now has one entry for the product
type. Is there anyway to split those entries into their 3 components, type,
logo, and finish either through a query or other means?
 
Product Type: Left([part number], 3)
Product Logo: Mid([part number], 4, 4)
Product Color: Right([part number], 3)
 
At the company I work, we have a part number that is 10 characters long. The
first 3 are the product type, the middle 4 are the product logo, and the last
3 are the product color. The table I have now has one entry for the product
type. Is there anyway to split those entries into their 3 components, type,
logo, and finish either through a query or other means?
Click to expand...

Good idea to do so!

Back up your database, then open this table in design view. Add the three new
fields, ProductType (don't use the reserved word Type), Logo and Color. Then
run an Update query updating ProductType to

Left([PartNumber], 3)

Logo to

Mid([PartNumber], 4, 4)

and Color to

Right([PartNumber], 3)
 
Back
Top